Learning Mysql

) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table album ALTER TABLE album DISABLE KEYS LOCK TABLES album WRITE;
INSERT INTO album VALUES (Let Love In'),(1,1,'Retro - John McCready FAN'),
(1,2,'Substance (Disc Retro - Miranda Sawyer POP'),
(1,4,'Retro - New Order / Bobby Gillespie LIVE'),(3,1,'Live Around The World'),
(3,2,'In A Silent Way'),(1,5,'Power, Corruption & Lies'),
(4,1,'Exile On Main Street'),(1,6,'Substance 1987 (Disc Second Coming'),(6,1,'Light Years'),(1,7,'Brotherhood');
UNLOCK TABLES ALTER TABLE album ENABLE KEYS */;
--
-- Table structure for table `artist`
--
DROP TABLE IF EXISTS `artist`;
CREATE TABLE artist (
`artist_id` smallint(5) NOT NULL default '0',
`artist_name` char) default NULL,
PRIMARY KEY (`artist_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table artist ALTER TABLE artist DISABLE KEYS LOCK TABLES artist WRITE;
INSERT INTO artist VALUES (New Order'),(2,'Nick Cave & The Bad Seeds'),
(3,'Miles Davis'),(4,'The Rolling Stones'),(5,'The Stone Roses'),
(6,'Kylie Minogue');
UNLOCK TABLES ALTER TABLE artist ENABLE KEYS */;
--
-- Table structure for table `played`
--
DROP TABLE IF EXISTS `played`;
CREATE TABLE played (
`artist_id` smallint(5) NOT NULL default '0',
`album_id` smallint(4) NOT NULL default '0',
`track_id` smallint(3) NOT NULL default 'played timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`artist_id`,`album_id`,`track_id`,`played`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Dumping a Database as SQL Statements | 355

--
-- Dumping data for table played ALTER TABLE played DISABLE KEYS LOCK TABLES played WRITE;
INSERT INTO played VALUES 00:21:03'),(1,3,1,'2006-08-14 00:25:22'),
(1,3,2,'2006-08-14 00:30:25'),(1,3,3,'2006-08-14 00:36:54'),
(1,3,4,'2006-08-14 00:41:43'),(1,3,5,'2006-08-14 00:43:37'),
(1,3,6,'2006-08-14 00:47:21'),(1,3,7,'2006-08-14 00:54:02'),
(3,1,0,'2006-08-15 04:00:03'),(3,1,1,'2006-08-15 04:26:12'),
(3,1,2,'2006-08-15 UNLOCK TABLES ALTER TABLE played ENABLE KEYS */;
--
-- Table structure for table `track`
--
DROP TABLE IF EXISTS `track`;
CREATE TABLE track (
`track_id` smallint(3) NOT NULL default '0',
`track_name` char) default NULL,
`artist_id` smallint(5) NOT NULL default '0',
`album_id` smallint(4) NOT NULL default 'time time default NULL,
PRIMARY KEY (`artist_id`,`album_id`,`track_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table track ALTER TABLE track DISABLE KEYS LOCK TABLES track WRITE;
INSERT INTO track VALUES (Do You Love Me?',2,1,'00:05:95'),
(1,'Nobody's Baby Now',2,1,'00:03:87'),(2,'Loverman',2,1,'00:06:37'),
(3,'Jangling Jack',2,1,'00:02:78'),(4,'Red Right Hand',2,1,'00:06:18'),
(5,'I Let Love In',2,1,'00:04:25'),(6,'Thirsty Dog',2,1,'00:03:81'),
UNLOCK TABLES ALTER TABLE track ENABLE KEYS */;
/*!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 */;

Download 4.24 Mb.

Share with your friends: