Databases Reference
In-Depth Information
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `album`
--
/*!40000 ALTER TABLE `album` DISABLE KEYS */;
LOCK TABLES `album` WRITE;
INSERT INTO `album` VALUES (2,1,'Let Love In'),(1,1,'Retro - John McCready FAN'),
(1,2,'Substance (Disc 2)'),(1,3,'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 1)'),
(5,1,'Second Coming'),(6,1,'Light Years'),(1,7,'Brotherhood');
UNLOCK TABLES;
/*!40000 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(128) default NULL,
PRIMARY KEY (`artist_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `artist`
--
/*!40000 ALTER TABLE `artist` DISABLE KEYS */;
LOCK TABLES `artist` WRITE;
INSERT INTO `artist` VALUES (1,'New Order'),(2,'Nick Cave & The Bad Seeds'),
(3,'Miles Davis'),(4,'The Rolling Stones'),(5,'The Stone Roses'),
(6,'Kylie Minogue');
UNLOCK TABLES;
/*!40000 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 '0',
`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;
