AUHNMkgF

1--
2-- Create album database
3-- as of 2014-02-24 bw
4--
5
6CREATE DATABASE IF NOT EXISTS album DEFAULT CHARSET = utf8;
7USE album;
8
9--
10-- Table structure for table `album`
11--
12
13DROP TABLE IF EXISTS `album`;
14SET @saved_cs_client     = @@character_set_client;
15SET character_set_client = utf8;
16CREATE TABLE `album` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `title` varchar(255) DEFAULT NULL,
19  `artist` varchar(255) DEFAULT NULL,
20  `label` varchar(255) DEFAULT NULL,
21  `released` date DEFAULT NULL,
22  PRIMARY KEY (`id`)
23) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
24SET character_set_client = @saved_cs_client;
25
26--
27-- Dumping data for table `album`
28--
29
30LOCK TABLES `album` WRITE;
31/*!40000 ALTER TABLE `album` DISABLE KEYS */;
32INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (1,'Two Men with the Blues','Willie Nelson and Wynton Marsalis','Blue Note','2008-07-08');
33INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (11,'Hendrix in the West','Jimi Hendrix','Polydor','1972-01-00');
34INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (12,'Rubber Soul','The Beatles','Parlophone','1965-12-03');
35INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (13,'Birds of Fire','Mahavishnu Orchestra','Columbia','1973-03-00');
36INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (16,'Live And','Johnny Winter','Columbia','1971-05-00');
37INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (17,'Apostrophe','Frank Zappa','DiscReet','1974-04-22');
38INSERT INTO `album` (`id`, `title`, `artist`, `label`, `released`) VALUES (18,'Kind of Blue','Miles Davis','Columbia','1959-08-17');
39/*!40000 ALTER TABLE `album` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `track`
44--
45
46DROP TABLE IF EXISTS `track`;
47SET @saved_cs_client     = @@character_set_client;
48SET character_set_client = utf8;
49CREATE TABLE `track` (
50  `id` int(11) NOT NULL AUTO_INCREMENT,
51  `album_id` int(11) DEFAULT NULL,
52  `title` varchar(255) DEFAULT NULL,
53  `track_number` int(11) DEFAULT NULL,
54  `duration` int(11) DEFAULT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
57SET character_set_client = @saved_cs_client;
58
59--
60-- Dumping data for table `track`
61--
62
63LOCK TABLES `track` WRITE;
64/*!40000 ALTER TABLE `track` DISABLE KEYS */;
65INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (1,1,'Bright Lights Big City',1,320);
66INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (2,1,'Night Life',2,344);
67INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (3,1,'Basin Street Blues',5,296);
68INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (4,1,'Caldonia',3,205);
69INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (5,1,'Stardust',4,308);
70INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (6,1,'Georgia On My Mind',6,280);
71INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (7,1,'Rainy Day Blues',7,343);
72INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (8,1,'My Bucket\'s Got A Hole In It',8,296);
73INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (9,1,'Ain\'t Nobody\'s Business',9,447);
74INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (10,1,'That\'s All',10,368);
75INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (15,11,'Lover Man',2,185);
76INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (14,11,'Johnny B. Goode',1,285);
77INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (16,11,'Blue Suede xShoes',3,266);
78INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (17,11,'Voodoo Chile',4,469);
79INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (18,11,'The Queen',5,160);
80INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (19,11,'Sgt. Pepper\'s Lonely Hearts Club Band',6,76);
81INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (20,11,'Little Wing',7,194);
82INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (21,11,'Red House',8,786);
83INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (22,12,'Drive My Car',1,150);
84INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (23,12,'Norwegian Wood (This Bird Has Flown)',2,125);
85INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (24,12,'You Won\'t See Me',3,202);
86INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (25,12,'Nowhere Man',4,164);
87INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (26,12,'Think for Yourself',5,139);
88INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (27,12,'The Word',6,163);
89INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (28,12,'Michelle',7,162);
90INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (29,12,'What Goes On',8,170);
91INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (30,12,'Girl',9,153);
92INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (31,12,'I\'m Looking Through You',10,147);
93INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (32,12,'In My Life',11,147);
94INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (33,12,'Wait',12,136);
95INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (34,12,'If I Needed Someone',13,143);
96INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (35,12,'Run for Your Life',14,138);
97INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (37,13,'Birds of Fire',1,350);
98INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (38,13,'Miles Beyond',2,287);
99INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (39,13,'Celestial Terrestrial Commuters',3,174);
100INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (40,13,'Sapphire Bullets of Pure Love',4,24);
101INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (41,13,'Thousand Island Park',5,203);
102INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (42,13,'Hope',6,119);
103INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (43,13,'One Word',7,597);
104INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (44,13,'Sanctuary',8,305);
105INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (45,13,'Open Country Joy',9,236);
106INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (46,13,'Resolution',10,129);
107INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (51,16,'It\'s My Own Fault',2,734);
108INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (50,16,'Good Morning Little Schoolgirl',1,285);
109INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (52,16,'Jumpin\' Jack Flash',3,266);
110INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (53,16,'Rock And Roll Medley',4,406);
111INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (54,16,'Mean Town Blues',5,539);
112INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (55,16,'Johnny B. Goode',6,202);
113INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (56,17,'Don\'t Eat the Yellow Snow',1,127);
114INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (57,17,'Nanook Rubs It',2,278);
115INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (58,17,'St. Alfonzo\'s Pancake Breakfast',3,110);
116INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (59,17,'Father O\'Blivion',4,138);
117INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (60,17,'Cosmik Debris',5,254);
118INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (61,17,'Excentrifugal Forz',6,93);
119INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (62,17,'Apostrophe',7,350);
120INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (63,17,'Uncle Remus',8,164);
121INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (64,17,'Stink-Foot',9,393);
122INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (65,18,'So What',1,565);
123INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (66,18,'Freddy Freeloader',2,589);
124INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (67,18,'Blue in Green',3,338);
125INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (68,18,'All Blues',4,696);
126INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (69,18,'Flamenco Sketches',5,566);
127INSERT INTO `track` (`id`, `album_id`, `title`, `track_number`, `duration`) VALUES (70,11,'Fake Track',9,549);
128/*!40000 ALTER TABLE `track` ENABLE KEYS */;
129UNLOCK TABLES;
130
131-- Dump completed on 2009-02-02  1:32:15