-- MySQL dump 10.9
--
-- Host: localhost    Database: slimserver
-- ------------------------------------------------------
-- Server version	4.1.12

/*!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 */;
/*!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 `albums`
--

DROP TABLE IF EXISTS `albums`;
CREATE TABLE `albums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` text,
  `titlesort` text,
  `titlesearch` text,
  `customsearch` text,
  `contributor` int(10) unsigned default NULL,
  `compilation` tinyint(1) default NULL,
  `year` smallint(5) unsigned default NULL,
  `artwork` int(10) unsigned default NULL,
  `disc` tinyint(1) unsigned default NULL,
  `discc` tinyint(1) unsigned default NULL,
  `replay_gain` float default NULL,
  `replay_peak` float default NULL,
  `musicbrainz_id` varchar(40) default NULL,
  `musicmagic_mixable` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `albumsTitleIndex` (`title`(255)),
  KEY `albumsSortIndex` (`titlesort`(255)),
  KEY `albumsSearchIndex` (`titlesearch`(255)),
  KEY `albumsCustomSearchIndex` (`customsearch`(255)),
  KEY `compilationSortIndex` (`compilation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `albums`
--


/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
LOCK TABLES `albums` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `albums` ENABLE KEYS */;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `track` int(10) unsigned default NULL,
  `value` text,
  PRIMARY KEY  (`id`),
  KEY `trackIndex` (`track`),
  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `comments`
--


/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
LOCK TABLES `comments` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;

--
-- Table structure for table `contributor_album`
--

DROP TABLE IF EXISTS `contributor_album`;
CREATE TABLE `contributor_album` (
  `role` int(10) unsigned NOT NULL default '0',
  `contributor` int(10) unsigned NOT NULL default '0',
  `album` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`role`,`contributor`,`album`),
  KEY `contributor_trackContribIndex` (`contributor`),
  KEY `contributor_trackAlbumIndex` (`album`),
  KEY `contributor_trackRoleIndex` (`role`),
  CONSTRAINT `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contributor_album_ibfk_2` FOREIGN KEY (`contributor`) REFERENCES `contributors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contributor_album`
--


/*!40000 ALTER TABLE `contributor_album` DISABLE KEYS */;
LOCK TABLES `contributor_album` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `contributor_album` ENABLE KEYS */;

--
-- Table structure for table `contributor_track`
--

DROP TABLE IF EXISTS `contributor_track`;
CREATE TABLE `contributor_track` (
  `role` int(10) unsigned NOT NULL default '0',
  `contributor` int(10) unsigned NOT NULL default '0',
  `track` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`role`,`contributor`,`track`),
  KEY `contributor_trackContribIndex` (`contributor`),
  KEY `contributor_trackTrackIndex` (`track`),
  KEY `contributor_trackRoleIndex` (`role`),
  CONSTRAINT `contributor_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contributor_track_ibfk_2` FOREIGN KEY (`contributor`) REFERENCES `contributors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contributor_track`
--


/*!40000 ALTER TABLE `contributor_track` DISABLE KEYS */;
LOCK TABLES `contributor_track` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `contributor_track` ENABLE KEYS */;

--
-- Table structure for table `contributors`
--

DROP TABLE IF EXISTS `contributors`;
CREATE TABLE `contributors` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `namesort` text,
  `namesearch` text,
  `customsearch` text,
  `moodlogic_id` int(10) unsigned default NULL,
  `moodlogic_mixable` tinyint(1) default NULL,
  `musicbrainz_id` varchar(40) default NULL,
  `musicmagic_mixable` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `contributorsNameIndex` (`name`(255)),
  KEY `contributorsSortIndex` (`namesort`(255)),
  KEY `contributorsSearchIndex` (`namesearch`(255)),
  KEY `contributorsCustomSearchIndex` (`customsearch`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contributors`
--


/*!40000 ALTER TABLE `contributors` DISABLE KEYS */;
LOCK TABLES `contributors` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `contributors` ENABLE KEYS */;

--
-- Table structure for table `dbix_migration`
--

DROP TABLE IF EXISTS `dbix_migration`;
CREATE TABLE `dbix_migration` (
  `name` char(64) NOT NULL default '',
  `value` char(64) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbix_migration`
--


/*!40000 ALTER TABLE `dbix_migration` DISABLE KEYS */;
LOCK TABLES `dbix_migration` WRITE;
INSERT INTO `dbix_migration` VALUES ('version','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE `dbix_migration` ENABLE KEYS */;

--
-- Table structure for table `genre_track`
--

DROP TABLE IF EXISTS `genre_track`;
CREATE TABLE `genre_track` (
  `genre` int(10) unsigned NOT NULL default '0',
  `track` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`genre`,`track`),
  KEY `genre_trackGenreIndex` (`genre`),
  KEY `genre_trackTrackIndex` (`track`),
  CONSTRAINT `genre_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `genre_track_ibfk_2` FOREIGN KEY (`genre`) REFERENCES `genres` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genre_track`
--


/*!40000 ALTER TABLE `genre_track` DISABLE KEYS */;
LOCK TABLES `genre_track` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `genre_track` ENABLE KEYS */;

--
-- Table structure for table `genres`
--

DROP TABLE IF EXISTS `genres`;
CREATE TABLE `genres` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `namesort` text,
  `namesearch` text,
  `customsearch` text,
  `moodlogic_id` int(10) unsigned default NULL,
  `moodlogic_mixable` tinyint(1) default NULL,
  `musicmagic_mixable` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `genreNameIndex` (`name`(255)),
  KEY `genreSortIndex` (`namesort`(255)),
  KEY `genreSearchIndex` (`namesearch`(255)),
  KEY `genreCustomSearchIndex` (`customsearch`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genres`
--


/*!40000 ALTER TABLE `genres` DISABLE KEYS */;
LOCK TABLES `genres` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `genres` ENABLE KEYS */;

--
-- Table structure for table `metainformation`
--

DROP TABLE IF EXISTS `metainformation`;
CREATE TABLE `metainformation` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `metainformation`
--


/*!40000 ALTER TABLE `metainformation` DISABLE KEYS */;
LOCK TABLES `metainformation` WRITE;
INSERT INTO `metainformation` VALUES ('isScanning','0'),('lastRescanTime','0');
UNLOCK TABLES;
/*!40000 ALTER TABLE `metainformation` ENABLE KEYS */;

--
-- Table structure for table `playlist_track`
--

DROP TABLE IF EXISTS `playlist_track`;
CREATE TABLE `playlist_track` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `position` int(10) unsigned default NULL,
  `playlist` int(10) unsigned default NULL,
  `track` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `trackIndex` (`track`),
  CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `playlist_track`
--


/*!40000 ALTER TABLE `playlist_track` DISABLE KEYS */;
LOCK TABLES `playlist_track` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `playlist_track` ENABLE KEYS */;

--
-- Table structure for table `pluginversion`
--

DROP TABLE IF EXISTS `pluginversion`;
CREATE TABLE `pluginversion` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `version` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pluginversion`
--


/*!40000 ALTER TABLE `pluginversion` DISABLE KEYS */;
LOCK TABLES `pluginversion` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `pluginversion` ENABLE KEYS */;

--
-- Table structure for table `rescans`
--

DROP TABLE IF EXISTS `rescans`;
CREATE TABLE `rescans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `files_scanned` int(10) unsigned default NULL,
  `files_to_scan` int(10) unsigned default NULL,
  `start_time` int(10) unsigned default NULL,
  `end_time` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rescans`
--


/*!40000 ALTER TABLE `rescans` DISABLE KEYS */;
LOCK TABLES `rescans` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `rescans` ENABLE KEYS */;

--
-- Table structure for table `tracks`
--

DROP TABLE IF EXISTS `tracks`;
CREATE TABLE `tracks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `url` text NOT NULL,
  `title` text,
  `titlesort` text,
  `titlesearch` text,
  `customsearch` text,
  `album` int(10) unsigned default NULL,
  `tracknum` int(10) unsigned default NULL,
  `content_type` varchar(255) default NULL,
  `tag` tinyint(1) default NULL,
  `timestamp` int(10) unsigned default NULL,
  `filesize` int(10) unsigned default NULL,
  `audio_size` int(10) unsigned default NULL,
  `audio_offset` int(10) unsigned default NULL,
  `year` smallint(5) unsigned default NULL,
  `secs` float unsigned default NULL,
  `cover` varchar(255) default NULL,
  `thumb` varchar(255) default NULL,
  `vbr_scale` varchar(255) default NULL,
  `bitrate` float unsigned default NULL,
  `samplerate` int(10) unsigned default NULL,
  `samplesize` int(10) unsigned default NULL,
  `channels` tinyint(1) unsigned default NULL,
  `block_alignment` int(10) unsigned default NULL,
  `endian` tinyint(1) default NULL,
  `bpm` smallint(5) unsigned default NULL,
  `tagversion` varchar(255) default NULL,
  `drm` tinyint(1) default NULL,
  `rating` tinyint(1) unsigned default NULL,
  `disc` tinyint(1) unsigned default NULL,
  `playCount` int(10) unsigned default NULL,
  `lastPlayed` int(10) unsigned default NULL,
  `audio` tinyint(1) default NULL,
  `remote` tinyint(1) default NULL,
  `lossless` tinyint(1) default NULL,
  `lyrics` text,
  `moodlogic_id` int(10) unsigned default NULL,
  `moodlogic_mixable` tinyint(1) default NULL,
  `musicbrainz_id` varchar(40) default NULL,
  `musicmagic_mixable` tinyint(1) default NULL,
  `replay_gain` float default NULL,
  `replay_peak` float default NULL,
  `multialbumsortkey` text,
  PRIMARY KEY  (`id`),
  KEY `trackTitleIndex` (`title`(255)),
  KEY `trackAlbumIndex` (`album`),
  KEY `ctSortIndex` (`content_type`),
  KEY `trackSortIndex` (`titlesort`(255)),
  KEY `trackSearchIndex` (`titlesearch`(255)),
  KEY `trackCustomSearchIndex` (`customsearch`(255)),
  KEY `trackRatingIndex` (`rating`),
  KEY `trackPlayCountIndex` (`playCount`),
  KEY `trackAudioIndex` (`audio`),
  KEY `trackRemoteIndex` (`remote`),
  KEY `trackLosslessIndex` (`lossless`),
  KEY `trackSortKeyIndex` (`multialbumsortkey`(255)),
  KEY `urlIndex` (`url`(255)),
  CONSTRAINT `tracks_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tracks`
--


/*!40000 ALTER TABLE `tracks` DISABLE KEYS */;
LOCK TABLES `tracks` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tracks` ENABLE KEYS */;

--
-- Table structure for table `unreadable_tracks`
--

DROP TABLE IF EXISTS `unreadable_tracks`;
CREATE TABLE `unreadable_tracks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rescan` int(10) unsigned default NULL,
  `url` text NOT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `unreadableRescanIndex` (`rescan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `unreadable_tracks`
--


/*!40000 ALTER TABLE `unreadable_tracks` DISABLE KEYS */;
LOCK TABLES `unreadable_tracks` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `unreadable_tracks` ENABLE KEYS */;

/*!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 */;