<commit_before>-- MySQL dump 10.13  Distrib 5.5.46, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: web_db
-- ------------------------------------------------------
-- Server version	5.5.46-0ubuntu0.14.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `web_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `web_db` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `web_db`;

--
-- Table structure for table `Album`
--

DROP TABLE IF EXISTS `Album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Album` (
  `nomAlbum` varchar(30) NOT NULL,
  `nomArtist` varchar(30) NOT NULL,
  `Annee` year(4) DEFAULT NULL,
  `Label` smallint(5) unsigned DEFAULT NULL,
  `imagePath` varchar(120) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Album`
--

LOCK TABLES `Album` WRITE;
/*!40000 ALTER TABLE `Album` DISABLE KEYS */;
INSERT INTO `Album` VALUES ('XX','The xx',NULL,NULL,'/static/images/album/The xx/XX.jpg'),('Creatures','Rone',NULL,NULL,'/static/images/album/Rone/Creatures.jpg'),('All or Nothing','The Subways',NULL,NULL,'/static/images/album/The Subways/All or Nothing.jpg'),('Comme Des Enfants','Coeur De Pirate',NULL,NULL,'/static/images/album/Coeur De Pirate/Comme Des Enfants.jpg'),('Man on the Moon: The End of Da','Kid cudi',NULL,NULL,'/static/images/album/Kid cudi/Man on the Moon: The End of Day.jpg'),('Live in Hyde Park','Red Hot Chili Peppers',NULL,NULL,'/static/images/album/Red Hot Chili Peppers/Live in Hyde Park.jpg'),('Minutes to Midnight','Linkin Park',NULL,NULL,'/static/images/album/Linkin Park/Minutes to Midnight.jpg'),('Loco con da Frenchy Talkin','Shaka Ponk',NULL,NULL,'/static/images/album/Shaka Ponk/Loco con da Frenchy Talkin.jpg'),('Bad Porn Movie Trax','Shaka Ponk',NULL,NULL,'/static/images/album/Shaka Ponk/Bad Porn Movie Trax.jpg'),('Conditions','The Temper Trap',NULL,NULL,'/static/images/album/The Temper Trap/Conditions.jpg'),('We Started Nothing','The Ting Tings',NULL,NULL,'/static/images/album/The Ting Tings/We Started Nothing.jpg'),('Sweep of Days','Blue Foundation',NULL,NULL,'/static/images/album/Blue Foundation/Sweep of Days.jpg'),('Hybrid Theory','Linkin Park',NULL,NULL,'/static/images/album/Linkin Park/Hybrid Theory.jpg'),('How We Are','Bombay Bicycle Club',NULL,NULL,'/static/images/album/Bombay Bicycle Club/How We Are.jpg');
/*!40000 ALTER TABLE `Album` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Music`
--

DROP TABLE IF EXISTS `Music`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Music` (
  `idmusic` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titre` varchar(30) DEFAULT NULL,
  `compositeur` varchar(60) DEFAULT NULL,
  `nomAlbum` varchar(30) NOT NULL,
  `annee` year(4) DEFAULT NULL,
  `label` varchar(30) DEFAULT NULL,
  `imagePath` longtext,
  `musicPath` longtext,
  `caract` longtext,
  `dateAjout` date DEFAULT NULL,
  PRIMARY KEY (`idmusic`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Music`
--

LOCK TABLES `Music` WRITE;
/*!40000 ALTER TABLE `Music` DISABLE KEYS */;
INSERT INTO `Music` VALUES (52,'Crystalised','The xx','XX',NULL,NULL,'/static/images/album/The xx/XX.jpg','/static/musiques/The xx/XX/Crystalised.mp3','truc','2015-05-30'),(53,'Intro','Rone','Creatures',NULL,NULL,'/static/images/album/Rone/Creatures.jpg','/static/musiques/Rone/Creatures/Intro.mp3','truc','2015-05-24'),(54,'Lost Boy','The Subways','All or Nothing',NULL,NULL,'/static/images/album/The Subways/All or Nothing.jpg','/static/musiques/The Subways/All or Nothing/Lost Boy.mp3','bidule','2015-05-24'),(55,'Comme Des Enfants','Coeur De Pirate','Comme Des Enfants',NULL,NULL,'/static/images/album/Coeur De Pirate/Comme Des Enfants.jpg','/static/musiques/Coeur De Pirate/Comme Des Enfants/Comme Des Enfants.mp3','pop','2015-05-25'),(56,'heart of lion','Kid cudi','Man on the Moon: The End of Da',NULL,NULL,'/static/images/album/Kid cudi/Man on the Moon: The End of Day.jpg','/static/musiques/Kid cudi/Man on the Moon: The End of Day/heart of lion.mp3','hip hop','2015-05-26'),(57,'Fortune Faded','Red Hot Chili Peppers','Live in Hyde Park',NULL,NULL,'/static/images/album/Red Hot Chili Peppers/Live in Hyde Park.jpg','/static/musiques/Red Hot Chili Peppers/Live in Hyde Park/Fortune Faded.mp3','alternatif','2015-05-26'),(58,'My December','Linkin Park','Hybrid Theory',NULL,NULL,'/static/images/album/Linkin Park/Hybrid Theory.jpg','/static/musiques/Linkin Park/Hybrid Theory/My December.mp3','punk','2015-05-26'),(59,'In The End','Linkin Park','Hybrid Theory',NULL,NULL,'/static/images/album/Linkin Park/Hybrid Theory.jpg','/static/musiques/Linkin Park/Hybrid Theory/In The End.mp3','punk','2015-05-29'),(60,'What I ve done','Linkin Park','Minutes to Midnight',NULL,NULL,'/static/images/album/Linkin Park/Minutes to Midnight.jpg','/static/musiques/Linkin Park/Minutes to Midnight/What I ve done.mp3','punk','2015-04-28'),(61,'Fonk me','<NAME>k','Loco con da Frenchy Talkin',NULL,NULL,'/static/images/album/Shaka Ponk/Loco con da Frenchy Talkin.jpg','/static/musiques/Shaka Ponk/Loco con da Frenchy Talkin/Fonk me.mp3','rock','2015-04-29'),(62,'French touch puta madre','Sh<NAME>','Bad Porn Movie Trax',NULL,NULL,'/static/images/album/Shaka Ponk/Bad Porn Movie Trax.jpg','/static/musiques/Shaka Ponk/Bad Porn Movie Trax/French touch puta madre.mp3','rock','2015-04-30'),(63,'Science Of Fear','The Temper Trap','Conditions',NULL,NULL,'/static/images/album/The Temper Trap/Conditions.jpg','/static/musiques/The Temper Trap/Conditions/Science Of Fear.mp3','rock','2015-05-10'),(64,'We Walk','The Ting Tings','We Started Nothing',NULL,NULL,'/static/images/album/The Ting Tings/We Started Nothing.jpg','/static/musiques/The Ting Tings/We Started Nothing/We Walk.mp3','cool','2015-05-10'),(65,'Bonfires','Blue Foundation','Sweep of Days',NULL,NULL,'/static/images/album/Blue Foundation/Sweep of Days.jpg','/static/musiques/Blue Foundation/Sweep of Days/Bonfires.mp3','salut','2015-05-16'),(66,'How Are We','Bombay Bicycle Club','How We Are',NULL,NULL,'/static/images/album/Bombay Bicycle Club/How We Are.jpg','/static/musiques/Bombay Bicycle Club/How We Are/How Are We.mp3','indien','2015-05-16'),(67,'Ghost','Bombay Bicycle Club','How We Are',NULL,NULL,'/static/images/album/Bombay Bicycle Club/How We Are.jpg','/static/musiques/Bombay Bicycle Club/How We Are/Ghost.mp3','indien','2015-05-30');
/*!40000 ALTER TABLE `Music` ENABLE KEYS */;
UNLOCK TABLES;
<commit_msg>Update SQL initial query for initial support of Youtube links<commit_after>-- MySQL dump 10.13  Distrib 5.5.46, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: web_db
-- ------------------------------------------------------
-- Server version	5.5.46-0ubuntu0.14.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `web_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `web_db` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `web_db`;

--
-- Table structure for table `Album`
--

DROP TABLE IF EXISTS `Album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Album` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nomAlbum` varchar(30) NOT NULL,
  `nomArtist` varchar(30) NOT NULL,
  `Annee` year(4) DEFAULT NULL,
  `Label` smallint(5) unsigned DEFAULT NULL,
  `imagePath` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Album`
--

LOCK TABLES `Album` WRITE;
/*!40000 ALTER TABLE `Album` DISABLE KEYS */;
INSERT INTO `Album` (`nomAlbum`, `nomArtist`, `Annee`, `Label`, `imagePath`) VALUES ('XX','The xx',NULL,NULL,'/static/images/album/The xx/XX.jpg'),('Creatures','Rone',NULL,NULL,'/static/images/album/Rone/Creatures.jpg'),('All or Nothing','The Subways',NULL,NULL,'/static/images/album/The Subways/All or Nothing.jpg'),('Comme Des Enfants','Coeur De Pirate',NULL,NULL,'/static/images/album/Coeur De Pirate/Comme Des Enfants.jpg'),('Man on the Moon: The End of Da','Kid cudi',NULL,NULL,'/static/images/album/Kid cudi/Man on the Moon: The End of Day.jpg'),('Live in Hyde Park','Red Hot Chili Peppers',NULL,NULL,'/static/images/album/Red Hot Chili Peppers/Live in Hyde Park.jpg'),('Minutes to Midnight','Linkin Park',NULL,NULL,'/static/images/album/Linkin Park/Minutes to Midnight.jpg'),('Loco con da Frenchy Talkin','Shaka Ponk',NULL,NULL,'/static/images/album/Shaka Ponk/Loco con da Frenchy Talkin.jpg'),('Bad Porn Movie Trax','Shaka Ponk',NULL,NULL,'/static/images/album/Shaka Ponk/Bad Porn Movie Trax.jpg'),('Conditions','The Temper Trap',NULL,NULL,'/static/images/album/The Temper Trap/Conditions.jpg'),('We Started Nothing','The Ting Tings',NULL,NULL,'/static/images/album/The Ting Tings/We Started Nothing.jpg'),('Sweep of Days','Blue Foundation',NULL,NULL,'/static/images/album/Blue Foundation/Sweep of Days.jpg'),('Hybrid Theory','Linkin Park',NULL,NULL,'/static/images/album/Linkin Park/Hybrid Theory.jpg'),('How We Are','Bombay Bicycle Club',NULL,NULL,'/static/images/album/Bombay Bicycle Club/How We Are.jpg');
/*!40000 ALTER TABLE `Album` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Music`
--

DROP TABLE IF EXISTS `Music`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Music` (
  `idmusic` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titre` varchar(120) DEFAULT NULL,
  `compositeur` varchar(60) DEFAULT NULL,
  `nomAlbum` varchar(30) NOT NULL,
  `annee` year(4) DEFAULT NULL,
  `label` varchar(30) DEFAULT NULL,
  `source` varchar(45) NOT NULL,
  `imagePath` longtext,
  `musicPath` longtext,
  `caract` longtext,
  `dateAjout` date DEFAULT NULL,
  PRIMARY KEY (`idmusic`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Music`
--

LOCK TABLES `Music` WRITE;
/*!40000 ALTER TABLE `Music` DISABLE KEYS */;
INSERT INTO `Music` VALUES (52,'Crystalised','The xx','XX',NULL,NULL,'local','/static/images/album/The xx/XX.jpg','/static/musiques/The xx/XX/Crystalised.mp3','truc','2015-05-30'),(53,'Intro','Rone','Creatures',NULL,NULL,'local','/static/images/album/Rone/Creatures.jpg','/static/musiques/Rone/Creatures/Intro.mp3','truc','2015-05-24'),(54,'Lost Boy','The Subways','All or Nothing',NULL,NULL,'local','/static/images/album/The Subways/All or Nothing.jpg','/static/musiques/The Subways/All or Nothing/Lost Boy.mp3','bidule','2015-05-24'),(55,'Comme Des Enfants','Coeur De Pirate','Comme Des Enfants',NULL,NULL,'local','/static/images/album/Coeur De Pirate/Comme Des Enfants.jpg','/static/musiques/Coeur De Pirate/Comme Des Enfants/Comme Des Enfants.mp3','pop','2015-05-25'),(56,'heart of lion','Kid cudi','Man on the Moon: The End of Da',NULL,NULL,'local','/static/images/album/Kid cudi/Man on the Moon: The End of Day.jpg','/static/musiques/Kid cudi/Man on the Moon: The End of Day/heart of lion.mp3','hip hop','2015-05-26'),(57,'Fortune Faded','Red Hot Chili Peppers','Live in Hyde Park',NULL,NULL,'local','/static/images/album/Red Hot Chili Peppers/Live in Hyde Park.jpg','/static/musiques/Red Hot Chili Peppers/Live in Hyde Park/Fortune Faded.mp3','alternatif','2015-05-26'),(58,'My December','Linkin Park','Hybrid Theory',NULL,NULL,'local','/static/images/album/Linkin Park/Hybrid Theory.jpg','/static/musiques/Linkin Park/Hybrid Theory/My December.mp3','punk','2015-05-26'),(59,'In The End','Linkin Park','Hybrid Theory',NULL,NULL,'local','/static/images/album/Linkin Park/Hybrid Theory.jpg','/static/musiques/Linkin Park/Hybrid Theory/In The End.mp3','punk','2015-05-29'),(60,'What I ve done','Linkin Park','Minutes to Midnight',NULL,NULL,'local','/static/images/album/Linkin Park/Minutes to Midnight.jpg','/static/musiques/Linkin Park/Minutes to Midnight/What I ve done.mp3','punk','2015-04-28'),(61,'Fonk me','<NAME>','Loco con da Frenchy Talkin',NULL,NULL,'local','/static/images/album/Shaka Ponk/Loco con da Frenchy Talkin.jpg','/static/musiques/Shaka Ponk/Loco con da Frenchy Talkin/Fonk me.mp3','rock','2015-04-29'),(62,'French touch puta madre','<NAME>','Bad Porn Movie Trax',NULL,NULL,'local','/static/images/album/Shaka Ponk/Bad Porn Movie Trax.jpg','/static/musiques/Shaka Ponk/Bad Porn Movie Trax/French touch puta madre.mp3','rock','2015-04-30'),(63,'Science Of Fear','The Temper Trap','Conditions',NULL,NULL,'local','/static/images/album/The Temper Trap/Conditions.jpg','/static/musiques/The Temper Trap/Conditions/Science Of Fear.mp3','rock','2015-05-10'),(64,'We Walk','The Ting Tings','We Started Nothing',NULL,NULL,'local','/static/images/album/The Ting Tings/We Started Nothing.jpg','/static/musiques/The Ting Tings/We Started Nothing/We Walk.mp3','cool','2015-05-10'),(65,'Bonfires','Blue Foundation','Sweep of Days',NULL,NULL,'local','/static/images/album/Blue Foundation/Sweep of Days.jpg','/static/musiques/Blue Foundation/Sweep of Days/Bonfires.mp3','salut','2015-05-16'),(66,'How Are We','Bombay Bicycle Club','How We Are',NULL,NULL,'local','/static/images/album/Bombay Bicycle Club/How We Are.jpg','/static/musiques/Bombay Bicycle Club/How We Are/How Are We.mp3','indien','2015-05-16'),(67,'Ghost','Bombay Bicycle Club','How We Are',NULL,NULL,'local','/static/images/album/Bombay Bicycle Club/How We Are.jpg','/static/musiques/Bombay Bicycle Club/How We Are/Ghost.mp3','indien','2015-05-30');
/*!40000 ALTER TABLE `Music` ENABLE KEYS */;
UNLOCK TABLES;

{'fraction_non_alphanumeric': 0.18667115449343655, 'fraction_numerical': 0.04665095927297206, 'mean_word_length': 5.5968028419182945, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 32, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7159037', 'n_tokens_mistral': 5841, 'n_tokens_neox': 5293, 'n_words': 1117}