Databases Reference
In-Depth Information
--
-- Dumping data for table `played`
--
/*!40000 ALTER TABLE `played` DISABLE KEYS */;
LOCK TABLES `played` WRITE;
INSERT INTO `played` VALUES
(1,3,0,'2006-08-14 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 04:33:57');
UNLOCK TABLES;
/*!40000 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(128) default NULL,
`artist_id` smallint(5) NOT NULL default '0',
`album_id` smallint(4) NOT NULL default '0',
`time` time default NULL,
PRIMARY KEY (`artist_id`,`album_id`,`track_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `track`
--
/*!40000 ALTER TABLE `track` DISABLE KEYS */;
LOCK TABLES `track` WRITE;
INSERT INTO `track` VALUES (0,'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;
/*!40000 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 */;
