-
Notifications
You must be signed in to change notification settings - Fork 1
/
db_dump.sql
116 lines (101 loc) · 15.5 KB
/
db_dump.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
CREATE DATABASE IF NOT EXISTS `web_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `web_db`;
-- MySQL dump 10.13 Distrib 5.6.23, for Win64 (x86_64)
--
-- Host: localhost Database: web_db
-- ------------------------------------------------------
-- Server version 5.6.24-log
/*!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 */;
--
-- Table structure for table `rates`
--
DROP TABLE IF EXISTS `avis`;
DROP TABLE IF EXISTS `rates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rates` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`useremail` varchar(30) NOT NULL,
`idmusic` int(10) unsigned NOT NULL,
`rating` smallint(5) unsigned DEFAULT NULL,
`mood` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rates`
--
LOCK TABLES `rates` WRITE;
/*!40000 ALTER TABLE `rates` DISABLE KEYS */;
INSERT INTO `rates` VALUES (7,'[email protected]',52,5,'Cool'),(8,'[email protected]',65,3,'Cool'),(9,'[email protected]',56,3,'Cool'),(10,'[email protected]',52,2,'Codeur'),(11,'[email protected]',53,4,NULL),(12,'[email protected]',54,5,NULL),(13,'[email protected]',55,5,NULL),(14,'[email protected]',56,3,NULL),(15,'[email protected]',57,2,NULL),(16,'[email protected]',58,1,NULL),(17,'[email protected]',60,2,NULL),(18,'[email protected]',61,4,NULL),(19,'[email protected]',62,5,NULL),(20,'[email protected]',63,4,NULL),(21,'[email protected]',64,2,NULL),(22,'[email protected]',67,3,NULL),(23,'[email protected]',66,4,NULL),(24,'[email protected]',52,5,'Calme'),(25,'[email protected]',1,NULL,'Gaming'),(26,'[email protected]',16,NULL,'Chill'),(27,'[email protected]',53,4,'Motivee'),(28,'[email protected]',54,4,'Motivee'),(29,'[email protected]',53,5,'Creative'),(30,'[email protected]',52,4,'Triste'),(31,'[email protected]',54,5,'Triste'),(32,'[email protected]',56,5,'Chill'),(33,'[email protected]',52,3,'Chill'),(34,'[email protected]',118,4,NULL);
/*!40000 ALTER TABLE `rates` 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,
`title` varchar(120) DEFAULT NULL,
`artist` varchar(60) DEFAULT NULL,
`album` varchar(30) NOT NULL,
`year` year(4) DEFAULT NULL,
`label` varchar(120) DEFAULT NULL,
`source` varchar(45) NOT NULL,
`imagePath` longtext,
`musicPath` longtext,
`genre` longtext,
`dateAdded` date DEFAULT NULL,
PRIMARY KEY (`idmusic`)
) ENGINE=InnoDB AUTO_INCREMENT=168 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','Shaka Ponk','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','Shaka Ponk','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'),(118,'Roar (Official)','Katy Perry','Prism',2013,'Capitol Records','youtube',NULL,'CevxZvSJLk8','pop','2015-11-26'),(119,'Wake Me Up (Official Video)','Avicii','True',2013,'PRMD','youtube',NULL,'IcrbM1l_BoI','house','2015-11-26'),(120,'Royals (US Version)','Lorde','Pure Herione',2013,'Republic Records; Lava Records; Universal Music NZ','youtube',NULL,'nlcIKh6sBtc','electropop','2015-11-26'),(121,'Wrecking Ball','Miley Cyrus','Bangerz',2013,'RCA Records','youtube',NULL,'My2FRPA3Gf8','pop','2015-11-26'),(122,'La La La ft. Sam Smith','Naughty Boy','Hotel Cabana',2013,'Naughty Boy Recordings','youtube',NULL,'3O1_3zBUKM8','R&B','2015-11-26'),(123,'Dark Horse (Official) ft. Juicy J','Katy Perry','Prism',2013,'Capitol Records','youtube',NULL,'0KSOMA3QBU0','hip hop','2015-11-26'),(124,'Counting Stars','OneRepublic','Native',2013,'Interscope Records; Mosley Music Group','youtube',NULL,'hT_nvWreIhg','rock','2015-11-26'),(125,'The Monster (Explicit) ft. Rihanna','Eminem','The Marshall Mathers LP 2',2013,'Shady Records; Aftermath Entertainment; Interscope Records; Aftermath Records','youtube',NULL,'EHkozMIXZ8w','hip hop','2015-11-26'),(126,'Beauty And A Beat ft. Nicki Minaj','Justin Bieber','Believe',2012,'Island Records','youtube',NULL,'Ys7-6_t7OEQ','electropop','2015-11-26'),(127,'Firework','Katy Perry','Teenage Dreams',2010,'Capitol Records; Virgin Records','youtube',NULL,'QGJuMBdaqIw','dance','2015-11-26'),(128,'Party Rock Anthem ft. Lauren Bennett, GoonRock','LMFAO','Sorry for Party Rocking',2011,'Interscope Records; Cherrytree Records; will.i.am Music Group','youtube',NULL,'KQ6zr6kCPj8','EDM','2015-11-26'),(129,'Not Afraid','Eminem','Recovery',2010,'Universal Music LLC; Universal Music Argentina S.A.','youtube',NULL,'j5-yKhDd64s','hip hop','2015-11-26'),(130,'Only Girl (In The World)','Rihanna','Loud',2010,'Def Jam Recordings; SRP Records','youtube',NULL,'pa14VNsdSYM','dance','2015-11-26'),(131,'Love The Way You Lie ft. Rihanna','Eminem','Recovery',2010,'Universal Music LLC; Universal Music Argentina S.A.','youtube',NULL,'uelHwf8o7_U','hip hop','2015-11-26'),(132,'Burn','Ellie Goulding','Halcyon',2012,'Interscope Records','youtube',NULL,'CGyEd0aKWZE','pop','2015-11-26'),(133,'Diamonds','Rihanna','Unapologetic',2012,'Def Jam Recordings; Island Records','youtube',NULL,'lWA2pjMjpBs','electropop','2015-11-26'),(134,'Someone Like You','Adele','21',2011,'XL Records; Hostess Entertainment','youtube',NULL,'hLQl3WQQoQ0','soul','2015-11-26'),(135,'Feel This Moment ft. Christina Aguilera','Pitbull','Global Warming',2012,'RCA Records','youtube',NULL,'5jlI4uzZGjU','dance','2015-11-26'),(136,'Never Say Never ft. Jaden Smith','Justin Bieber','My Worlds',2010,'Mercury Records','youtube',NULL,'_Z5-P9v3F8w','R&B','2015-11-26'),(137,'Scream & Shout ft. Britney Spears','will.i.am','Willpower',2013,'Interscope Records; Universal Music LLC','youtube',NULL,'kYtGl1dX5qI','dance','2015-11-26'),(138,'Bad Romance','Lady Gaga','The Fame Monster',2009,'Universal International; Streamline','youtube',NULL,'qrO4YZeyl0I','dance','2015-11-26'),(139,'Timber ft. Ke$ha','Pitbull','Meltdown',2013,'MR. 305; Polo Grounds; RCA Records','youtube',NULL,'hHUbLv4ThOo','EDM','2015-11-26'),(140,'Super Bass','Nicki Minaj','Pink Friday',2010,'Young Money Entertainment; Cash Money Records; Universal Motown','youtube',NULL,'4JipHEz53sU','pop','2015-11-26'),(141,'We Found Love ft. Calvin Harris','Rihanna','Talk That Talk',2011,'The Island Def Jam Music Group; Mercury Records','youtube',NULL,'tg00YEETFzg','house','2015-11-26'),(142,'International Love ft. Chris Brown','Pitbull','Planet Pit',2011,'J Records','youtube',NULL,'CdXesX6mYUE','dance','2015-11-26'),(143,'Levels','Avicii','True',2013,'PRMD','youtube',NULL,'_ovdm2yX4MA','house','2015-11-26'),(144,'On The Floor ft. Pitbull','Jennifer Lopez','Love?',2011,'Mercury Records','youtube',NULL,'t4H_Zoh7G5A','dance','2015-11-26'),(145,'What Makes You Beautiful','One Direction','Up All Night',2011,'Columbia Records; Syco; Syco Music UK','youtube',NULL,'QJO3ROT-A4E','pop','2015-11-26'),(146,'Waka Waka (This Time for Africa) (The Official 2010 FIFA World Cup™ Song)','Shakira','Sala el Sol',2010,'Epic Records','youtube',NULL,'pRpeEdMmmQ0','pop','2015-11-26'),(147,'Rain Over Me ft. Marc Anthony','Pitbull','Planet Pit',2011,'J Records','youtube',NULL,'SmM0653YvXU','pop','2015-11-26'),(148,'Rolling in the Deep','Adele','21',2011,'XL Records; Hostess Entertainment','youtube',NULL,'rYEDA3JcQqw','soul','2015-11-26'),(149,'Can\'t Remember to Forget You ft. Rihanna','Shakira','Shakira',2014,'RCA Records; RCA/Sony Latin Iberia','youtube',NULL,'o3mP3mJDL2k','rock','2015-11-26'),(150,'Summer','Calvin Harris','Motion',2014,'Columbia Records; Syco; Syco Music UK','youtube',NULL,'ebXbLfLACGM','house','2015-11-26'),(151,'What\'s My Name? ft. Drake','Rihanna','Loud',2010,'Def Jam Records; SRP Records','youtube',NULL,'U0CGsw6h60k','R&B','2015-11-26'),(152,'Just Dance ft. Colby O\'Donis','Lady Gaga','The Fame',2008,'Streamline; Kon Live; Cherrytree; Interscope','youtube',NULL,'2Abk1jAONjw','electropop','2015-11-26'),(153,'Single Ladies (Put a Ring on It)','Beyoncé','I Am... Sasha Fierce',2008,'Columbia Records;','youtube',NULL,'4m1EFMoRFvY','R&B','2015-11-26'),(154,'Price Tag ft. B.o.B','Jessie J','Who You Are',2010,'Universal','youtube',NULL,'qMxX-QOV9tI','R&B','2015-11-26'),(155,'You Belong With Me','Taylor Swift','Love Story',2009,'Big Machine; Universal Republic','youtube',NULL,'VuNIsY6JdUw','country','2015-11-26'),(156,'TiK ToK','Ke$ha','Animal',2009,'RCA Records','youtube',NULL,'iP6XpLQM2Cs','electropop','2015-11-26'),(157,'Bailando (Español) ft. Descemer Bueno, Gente De Zona','Enrique Iglesias','Sex and Love',2014,'Republic Records; Lava Records; Universal Music NZ','youtube',NULL,'NUsoVlDFqZg','NULL','2015-11-26'),(158,'Shake It Off','Taylor Swift','1989',2014,'Big Machine','youtube',NULL,'nfWlot6h_JM','pop','2015-11-26'),(159,'All About That Bass','Meghan Trainor','Title',2014,'Epic Records','youtube',NULL,'7PCkvCPvDXk','pop','2015-11-26'),(160,'See You Again ft. Charlie Puth [Official Video] Furious 7 Soundtrack','Wiz Khalifa','Furious 7',2015,'Atlantic','youtube',NULL,'RgKAFK5djSk','hip hop','2015-11-26'),(161,'Blank Space','Taylor Swift','1989',2014,'Big Machine; Republic Records','youtube',NULL,'e-ORhEE9VVg','electropop','2015-11-26'),(162,'Chandelier (Official Video)','Sia','1000 Forms of Fear',2014,'Inertia; Money Puzzle; RCA','youtube',NULL,'2vjPBrBU-TM','electropop','2015-11-26'),(163,'Baby ft. Ludacris','Justin Bieber','My World 2.0',2010,'Island Records; RBMG','youtube',NULL,'kffacxfA7G4','pop','2015-11-26'),(164,'Uptown Funk ft. Bruno Mars','Mark Ronson','Uptown Special',2014,'RCA','youtube',NULL,'OPf0YbXqDm0','soul','2015-11-26'),(165,'Bad Blood ft. Kendrick Lamar','Taylor Swift','1989',2015,'Big Machine; Republic Records','youtube',NULL,'QcIy9NiNbmo','electropop','2015-11-26'),(166,'Sugar','Maroon 5','V',2015,'Interscope','youtube',NULL,'09R8_2nJtjg','disco','2015-11-26'),(167,'Hips Don\'t Lie ft. Wyclef Jean','Shakira','Oral Fixation',2006,'Epic Records','youtube',NULL,'DUT5rEU6pqM','reggae','2015-11-26');
/*!40000 ALTER TABLE `music` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`email` varchar(30) NOT NULL,
`password` varchar(120) NOT NULL,
`username` varchar(30) DEFAULT NULL,
`imagePath` varchar(2083) DEFAULT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('[email protected]','cda1d665441ef8120c3d3e82610e74ab0d3b043763784676654d8ef1','asd',NULL),('[email protected]','lok','céline',NULL),('[email protected]','23970774a854b7f7cb4dcab703406688dad7e58979400ba13b9f8963','edmundo',NULL),('[email protected]','1234',NULL,NULL),('[email protected]','lok','kjhb',NULL),('[email protected]','lok','kksksks',NULL),('[email protected]','lok3','AMINE',NULL),('[email protected]','lok','jsncjnc',NULL),('[email protected]','lok','aelf,zknzlf',NULL),('[email protected]','lok','lokmane','/static/images/userprofile/[email protected]'),('[email protected]','lok','example',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2015-12-01 17:30:52