Warning, /multimedia/amarok/HACKING/mysql_database_schema.txt is written in an unsupported language. File is not indexed.

0001 
0002 Warning: outdated.
0003 Look at HACKING/amarokTables.svg and keep it up to date.
0004 
0005 
0006 -- MySQL dump 10.13  Distrib 5.1.58, for debian-linux-gnu (x86_64)
0007 --
0008 -- Host: localhost    Database: amarok
0009 -- ------------------------------------------------------
0010 -- Server version       5.1.58-1ubuntu1
0011 
0012 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
0013 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
0014 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
0015 /*!40101 SET NAMES utf8 */;
0016 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
0017 /*!40103 SET TIME_ZONE='+00:00' */;
0018 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
0019 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
0020 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
0021 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
0022 
0023 --
0024 -- Table structure for table `admin`
0025 --
0026 
0027 DROP TABLE IF EXISTS `admin`;
0028 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0029 /*!40101 SET character_set_client = utf8 */;
0030 CREATE TABLE `admin` (
0031   `component` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0032   `version` int(11) DEFAULT NULL
0033 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0034 /*!40101 SET character_set_client = @saved_cs_client */;
0035 
0036 --
0037 -- Table structure for table `albums`
0038 --
0039 
0040 DROP TABLE IF EXISTS `albums`;
0041 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0042 /*!40101 SET character_set_client = utf8 */;
0043 CREATE TABLE `albums` (
0044   `id` int(11) NOT NULL AUTO_INCREMENT,
0045   `name` varchar(255) COLLATE utf8_bin NOT NULL,
0046   `artist` int(11) DEFAULT NULL,
0047   `image` int(11) DEFAULT NULL,
0048   PRIMARY KEY (`id`),
0049   UNIQUE KEY `albums_name_artist` (`name`,`artist`),
0050   KEY `albums_name` (`name`),
0051   KEY `albums_artist` (`artist`),
0052   KEY `albums_image` (`image`)
0053 ) ENGINE=MyISAM AUTO_INCREMENT=547 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0054 /*!40101 SET character_set_client = @saved_cs_client */;
0055 
0056 --
0057 -- Table structure for table `amazon`
0058 --
0059 
0060 DROP TABLE IF EXISTS `amazon`;
0061 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0062 /*!40101 SET character_set_client = utf8 */;
0063 CREATE TABLE `amazon` (
0064   `asin` varchar(20) COLLATE utf8_bin DEFAULT NULL,
0065   `locale` varchar(2) COLLATE utf8_bin DEFAULT NULL,
0066   `filename` varchar(33) COLLATE utf8_bin DEFAULT NULL,
0067   `refetchdate` int(11) DEFAULT NULL,
0068   KEY `amazon_date` (`refetchdate`)
0069 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0070 /*!40101 SET character_set_client = @saved_cs_client */;
0071 
0072 --
0073 -- Table structure for table `artists`
0074 --
0075 
0076 DROP TABLE IF EXISTS `artists`;
0077 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0078 /*!40101 SET character_set_client = utf8 */;
0079 CREATE TABLE `artists` (
0080   `id` int(11) NOT NULL AUTO_INCREMENT,
0081   `name` varchar(255) COLLATE utf8_bin NOT NULL,
0082   PRIMARY KEY (`id`),
0083   UNIQUE KEY `artists_name` (`name`)
0084 ) ENGINE=MyISAM AUTO_INCREMENT=966 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0085 /*!40101 SET character_set_client = @saved_cs_client */;
0086 
0087 --
0088 -- Table structure for table `bookmark_groups`
0089 --
0090 
0091 DROP TABLE IF EXISTS `bookmark_groups`;
0092 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0093 /*!40101 SET character_set_client = utf8 */;
0094 CREATE TABLE `bookmark_groups` (
0095   `id` int(11) NOT NULL AUTO_INCREMENT,
0096   `parent_id` int(11) DEFAULT NULL,
0097   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0098   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0099   `custom` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0100   PRIMARY KEY (`id`)
0101 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0102 /*!40101 SET character_set_client = @saved_cs_client */;
0103 
0104 --
0105 -- Table structure for table `bookmarks`
0106 --
0107 
0108 DROP TABLE IF EXISTS `bookmarks`;
0109 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0110 /*!40101 SET character_set_client = utf8 */;
0111 CREATE TABLE `bookmarks` (
0112   `id` int(11) NOT NULL AUTO_INCREMENT,
0113   `parent_id` int(11) DEFAULT NULL,
0114   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0115   `url` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0116   `description` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0117   `custom` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0118   PRIMARY KEY (`id`)
0119 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0120 /*!40101 SET character_set_client = @saved_cs_client */;
0121 
0122 --
0123 -- Table structure for table `composers`
0124 --
0125 
0126 DROP TABLE IF EXISTS `composers`;
0127 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0128 /*!40101 SET character_set_client = utf8 */;
0129 CREATE TABLE `composers` (
0130   `id` int(11) NOT NULL AUTO_INCREMENT,
0131   `name` varchar(255) COLLATE utf8_bin NOT NULL,
0132   PRIMARY KEY (`id`),
0133   UNIQUE KEY `composers_name` (`name`)
0134 ) ENGINE=MyISAM AUTO_INCREMENT=268 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0135 /*!40101 SET character_set_client = @saved_cs_client */;
0136 
0137 --
0138 -- Table structure for table `devices`
0139 --
0140 
0141 DROP TABLE IF EXISTS `devices`;
0142 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0143 /*!40101 SET character_set_client = utf8 */;
0144 CREATE TABLE `devices` (
0145   `id` int(11) NOT NULL AUTO_INCREMENT,
0146   `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0147   `label` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0148   `lastmountpoint` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0149   `uuid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0150   `servername` varchar(80) COLLATE utf8_bin DEFAULT NULL,
0151   `sharename` varchar(240) COLLATE utf8_bin DEFAULT NULL,
0152   PRIMARY KEY (`id`),
0153   UNIQUE KEY `devices_uuid` (`uuid`),
0154   KEY `devices_type` (`type`),
0155   KEY `devices_rshare` (`servername`,`sharename`)
0156 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0157 /*!40101 SET character_set_client = @saved_cs_client */;
0158 
0159 --
0160 -- Table structure for table `directories`
0161 --
0162 
0163 DROP TABLE IF EXISTS `directories`;
0164 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0165 /*!40101 SET character_set_client = utf8 */;
0166 CREATE TABLE `directories` (
0167   `id` int(11) NOT NULL AUTO_INCREMENT,
0168   `deviceid` int(11) DEFAULT NULL,
0169   `dir` varchar(1000) COLLATE utf8_bin NOT NULL,
0170   `changedate` int(11) DEFAULT NULL,
0171   PRIMARY KEY (`id`),
0172   KEY `directories_deviceid` (`deviceid`)
0173 ) ENGINE=MyISAM AUTO_INCREMENT=1051 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0174 /*!40101 SET character_set_client = @saved_cs_client */;
0175 
0176 --
0177 -- Table structure for table `genres`
0178 --
0179 
0180 DROP TABLE IF EXISTS `genres`;
0181 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0182 /*!40101 SET character_set_client = utf8 */;
0183 CREATE TABLE `genres` (
0184   `id` int(11) NOT NULL AUTO_INCREMENT,
0185   `name` varchar(255) COLLATE utf8_bin NOT NULL,
0186   PRIMARY KEY (`id`),
0187   UNIQUE KEY `genres_name` (`name`)
0188 ) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0189 /*!40101 SET character_set_client = @saved_cs_client */;
0190 
0191 --
0192 -- Table structure for table `images`
0193 --
0194 
0195 DROP TABLE IF EXISTS `images`;
0196 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0197 /*!40101 SET character_set_client = utf8 */;
0198 CREATE TABLE `images` (
0199   `id` int(11) NOT NULL AUTO_INCREMENT,
0200   `path` varchar(255) COLLATE utf8_bin NOT NULL,
0201   PRIMARY KEY (`id`),
0202   UNIQUE KEY `images_name` (`path`)
0203 ) ENGINE=MyISAM AUTO_INCREMENT=356 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0204 /*!40101 SET character_set_client = @saved_cs_client */;
0205 
0206 --
0207 -- Table structure for table `labels`
0208 --
0209 
0210 DROP TABLE IF EXISTS `labels`;
0211 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0212 /*!40101 SET character_set_client = utf8 */;
0213 CREATE TABLE `labels` (
0214   `id` int(11) NOT NULL AUTO_INCREMENT,
0215   `label` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0216   PRIMARY KEY (`id`),
0217   UNIQUE KEY `labels_label` (`label`)
0218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0219 /*!40101 SET character_set_client = @saved_cs_client */;
0220 
0221 --
0222 -- Table structure for table `lyrics`
0223 --
0224 
0225 DROP TABLE IF EXISTS `lyrics`;
0226 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0227 /*!40101 SET character_set_client = utf8 */;
0228 CREATE TABLE `lyrics` (
0229   `url` int(11) NOT NULL,
0230   `lyrics` text COLLATE utf8_bin,
0231   PRIMARY KEY (`url`)
0232 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0233 /*!40101 SET character_set_client = @saved_cs_client */;
0234 
0235 --
0236 -- Table structure for table `magnatune_albums`
0237 --
0238 
0239 DROP TABLE IF EXISTS `magnatune_albums`;
0240 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0241 /*!40101 SET character_set_client = utf8 */;
0242 CREATE TABLE `magnatune_albums` (
0243   `id` int(11) NOT NULL AUTO_INCREMENT,
0244   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0245   `year` int(11) DEFAULT NULL,
0246   `artist_id` int(11) DEFAULT NULL,
0247   `album_code` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0248   `cover_url` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0249   `description` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0250   PRIMARY KEY (`id`),
0251   KEY `magnatune_albums_name` (`name`),
0252   KEY `magnatune_albums_artist_id` (`artist_id`)
0253 ) ENGINE=MyISAM AUTO_INCREMENT=1154 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0254 /*!40101 SET character_set_client = @saved_cs_client */;
0255 
0256 --
0257 -- Table structure for table `magnatune_artists`
0258 --
0259 
0260 DROP TABLE IF EXISTS `magnatune_artists`;
0261 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0262 /*!40101 SET character_set_client = utf8 */;
0263 CREATE TABLE `magnatune_artists` (
0264   `id` int(11) NOT NULL AUTO_INCREMENT,
0265   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0266   `artist_page` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0267   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0268   `photo_url` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0269   PRIMARY KEY (`id`),
0270   KEY `magnatune_artists_name` (`name`)
0271 ) ENGINE=MyISAM AUTO_INCREMENT=500 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0272 /*!40101 SET character_set_client = @saved_cs_client */;
0273 
0274 --
0275 -- Table structure for table `magnatune_genre`
0276 --
0277 
0278 DROP TABLE IF EXISTS `magnatune_genre`;
0279 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0280 /*!40101 SET character_set_client = utf8 */;
0281 CREATE TABLE `magnatune_genre` (
0282   `id` int(11) NOT NULL AUTO_INCREMENT,
0283   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0284   `album_id` int(11) DEFAULT NULL,
0285   PRIMARY KEY (`id`),
0286   KEY `magnatune_genre_name` (`name`),
0287   KEY `magnatune_genre_album_id` (`album_id`)
0288 ) ENGINE=MyISAM AUTO_INCREMENT=2783 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0289 /*!40101 SET character_set_client = @saved_cs_client */;
0290 
0291 --
0292 -- Table structure for table `magnatune_moods`
0293 --
0294 
0295 DROP TABLE IF EXISTS `magnatune_moods`;
0296 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0297 /*!40101 SET character_set_client = utf8 */;
0298 CREATE TABLE `magnatune_moods` (
0299   `id` int(11) NOT NULL AUTO_INCREMENT,
0300   `track_id` int(11) DEFAULT NULL,
0301   `mood` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0302   PRIMARY KEY (`id`)
0303 ) ENGINE=MyISAM AUTO_INCREMENT=2762 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0304 /*!40101 SET character_set_client = @saved_cs_client */;
0305 
0306 --
0307 -- Table structure for table `magnatune_tracks`
0308 --
0309 
0310 DROP TABLE IF EXISTS `magnatune_tracks`;
0311 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0312 /*!40101 SET character_set_client = utf8 */;
0313 CREATE TABLE `magnatune_tracks` (
0314   `id` int(11) NOT NULL AUTO_INCREMENT,
0315   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0316   `track_number` int(11) DEFAULT NULL,
0317   `length` int(11) DEFAULT NULL,
0318   `album_id` int(11) DEFAULT NULL,
0319   `artist_id` int(11) DEFAULT NULL,
0320   `preview_lofi` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0321   `preview_ogg` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0322   `preview_url` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0323   PRIMARY KEY (`id`),
0324   KEY `magnatune_tracks_album_id` (`album_id`),
0325   KEY `magnatune_tracks_artist_id` (`artist_id`)
0326 ) ENGINE=MyISAM AUTO_INCREMENT=14831 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0327 /*!40101 SET character_set_client = @saved_cs_client */;
0328 
0329 --
0330 -- Table structure for table `playlist_groups`
0331 --
0332 
0333 DROP TABLE IF EXISTS `playlist_groups`;
0334 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0335 /*!40101 SET character_set_client = utf8 */;
0336 CREATE TABLE `playlist_groups` (
0337   `id` int(11) NOT NULL AUTO_INCREMENT,
0338   `parent_id` int(11) DEFAULT NULL,
0339   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0340   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0341   PRIMARY KEY (`id`),
0342   KEY `parent_podchannel` (`parent_id`)
0343 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0344 /*!40101 SET character_set_client = @saved_cs_client */;
0345 
0346 --
0347 -- Table structure for table `playlist_tracks`
0348 --
0349 
0350 DROP TABLE IF EXISTS `playlist_tracks`;
0351 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0352 /*!40101 SET character_set_client = utf8 */;
0353 CREATE TABLE `playlist_tracks` (
0354   `id` int(11) NOT NULL AUTO_INCREMENT,
0355   `playlist_id` int(11) DEFAULT NULL,
0356   `track_num` int(11) DEFAULT NULL,
0357   `url` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0358   `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0359   `album` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0360   `artist` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0361   `length` int(11) DEFAULT NULL,
0362   `uniqueid` varchar(128) COLLATE utf8_bin DEFAULT NULL,
0363   PRIMARY KEY (`id`),
0364   KEY `parent_playlist_tracks` (`playlist_id`),
0365   KEY `playlist_tracks_uniqueid` (`uniqueid`)
0366 ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0367 /*!40101 SET character_set_client = @saved_cs_client */;
0368 
0369 --
0370 -- Table structure for table `playlists`
0371 --
0372 
0373 DROP TABLE IF EXISTS `playlists`;
0374 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0375 /*!40101 SET character_set_client = utf8 */;
0376 CREATE TABLE `playlists` (
0377   `id` int(11) NOT NULL AUTO_INCREMENT,
0378   `parent_id` int(11) DEFAULT NULL,
0379   `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0380   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0381   `urlid` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0382   PRIMARY KEY (`id`),
0383   KEY `parent_playlist` (`parent_id`)
0384 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0385 /*!40101 SET character_set_client = @saved_cs_client */;
0386 
0387 --
0388 -- Table structure for table `podcastchannels`
0389 --
0390 
0391 DROP TABLE IF EXISTS `podcastchannels`;
0392 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0393 /*!40101 SET character_set_client = utf8 */;
0394 CREATE TABLE `podcastchannels` (
0395   `id` int(11) NOT NULL AUTO_INCREMENT,
0396   `url` text COLLATE utf8_bin,
0397   `title` text COLLATE utf8_bin,
0398   `weblink` text COLLATE utf8_bin,
0399   `image` text COLLATE utf8_bin,
0400   `description` text COLLATE utf8_bin,
0401   `copyright` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0402   `directory` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0403   `labels` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0404   `subscribedate` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0405   `autoscan` tinyint(1) DEFAULT NULL,
0406   `fetchtype` int(11) DEFAULT NULL,
0407   `haspurge` tinyint(1) DEFAULT NULL,
0408   `purgecount` int(11) DEFAULT NULL,
0409   `writetags` tinyint(1) DEFAULT NULL,
0410   `filenamelayout` varchar(1024) COLLATE utf8_bin DEFAULT NULL,
0411   PRIMARY KEY (`id`),
0412   FULLTEXT KEY `url_podchannel` (`url`)
0413 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0414 /*!40101 SET character_set_client = @saved_cs_client */;
0415 
0416 --
0417 -- Table structure for table `podcastepisodes`
0418 --
0419 
0420 DROP TABLE IF EXISTS `podcastepisodes`;
0421 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0422 /*!40101 SET character_set_client = utf8 */;
0423 CREATE TABLE `podcastepisodes` (
0424   `id` int(11) NOT NULL AUTO_INCREMENT,
0425   `url` text COLLATE utf8_bin,
0426   `channel` int(11) DEFAULT NULL,
0427   `localurl` text COLLATE utf8_bin,
0428   `guid` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
0429   `title` text COLLATE utf8_bin,
0430   `subtitle` text COLLATE utf8_bin,
0431   `sequencenumber` int(11) DEFAULT NULL,
0432   `description` text COLLATE utf8_bin,
0433   `mimetype` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0434   `pubdate` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0435   `duration` int(11) DEFAULT NULL,
0436   `filesize` int(11) DEFAULT NULL,
0437   `isnew` tinyint(1) DEFAULT NULL,
0438   PRIMARY KEY (`id`),
0439   FULLTEXT KEY `url_podepisode` (`url`),
0440   FULLTEXT KEY `localurl_podepisode` (`localurl`)
0441 ) ENGINE=MyISAM AUTO_INCREMENT=263 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0442 /*!40101 SET character_set_client = @saved_cs_client */;
0443 
0444 --
0445 -- Table structure for table `statistics`
0446 --
0447 
0448 DROP TABLE IF EXISTS `statistics`;
0449 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0450 /*!40101 SET character_set_client = utf8 */;
0451 CREATE TABLE `statistics` (
0452   `id` int(11) NOT NULL AUTO_INCREMENT,
0453   `url` int(11) NOT NULL,
0454   `createdate` int(11) DEFAULT NULL,
0455   `accessdate` int(11) DEFAULT NULL,
0456   `score` float DEFAULT NULL,
0457   `rating` int(11) NOT NULL DEFAULT '0',
0458   `playcount` int(11) NOT NULL DEFAULT '0',
0459   `deleted` tinyint(1) NOT NULL DEFAULT '0',
0460   PRIMARY KEY (`id`),
0461   UNIQUE KEY `statistics_url` (`url`),
0462   KEY `statistics_createdate` (`createdate`),
0463   KEY `statistics_accessdate` (`accessdate`),
0464   KEY `statistics_score` (`score`),
0465   KEY `statistics_rating` (`rating`),
0466   KEY `statistics_playcount` (`playcount`)
0467 ) ENGINE=MyISAM AUTO_INCREMENT=6721 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0468 /*!40101 SET character_set_client = @saved_cs_client */;
0469 
0470 --
0471 -- Table structure for table `statistics_permanent`
0472 --
0473 
0474 DROP TABLE IF EXISTS `statistics_permanent`;
0475 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0476 /*!40101 SET character_set_client = utf8 */;
0477 CREATE TABLE `statistics_permanent` (
0478   `url` varchar(324) COLLATE utf8_bin NOT NULL,
0479   `firstplayed` datetime DEFAULT NULL,
0480   `lastplayed` datetime DEFAULT NULL,
0481   `score` float DEFAULT NULL,
0482   `rating` int(11) DEFAULT '0',
0483   `playcount` int(11) DEFAULT NULL,
0484   UNIQUE KEY `stats_perm_url` (`url`)
0485 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0486 /*!40101 SET character_set_client = @saved_cs_client */;
0487 
0488 --
0489 -- Table structure for table `statistics_tag`
0490 --
0491 
0492 DROP TABLE IF EXISTS `statistics_tag`;
0493 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0494 /*!40101 SET character_set_client = utf8 */;
0495 CREATE TABLE `statistics_tag` (
0496   `name` varchar(108) COLLATE utf8_bin DEFAULT NULL,
0497   `artist` varchar(108) COLLATE utf8_bin DEFAULT NULL,
0498   `album` varchar(108) COLLATE utf8_bin DEFAULT NULL,
0499   `firstplayed` datetime DEFAULT NULL,
0500   `lastplayed` datetime DEFAULT NULL,
0501   `score` float DEFAULT NULL,
0502   `rating` int(11) DEFAULT '0',
0503   `playcount` int(11) DEFAULT NULL,
0504   UNIQUE KEY `stats_tag_name_artist_album` (`name`,`artist`,`album`)
0505 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0506 /*!40101 SET character_set_client = @saved_cs_client */;
0507 
0508 --
0509 -- Table structure for table `tracks`
0510 --
0511 
0512 DROP TABLE IF EXISTS `tracks`;
0513 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0514 /*!40101 SET character_set_client = utf8 */;
0515 CREATE TABLE `tracks` (
0516   `id` int(11) NOT NULL AUTO_INCREMENT,
0517   `url` int(11) DEFAULT NULL,
0518   `artist` int(11) DEFAULT NULL,
0519   `album` int(11) DEFAULT NULL,
0520   `genre` int(11) DEFAULT NULL,
0521   `composer` int(11) DEFAULT NULL,
0522   `year` int(11) DEFAULT NULL,
0523   `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
0524   `comment` text COLLATE utf8_bin,
0525   `tracknumber` int(11) DEFAULT NULL,
0526   `discnumber` int(11) DEFAULT NULL,
0527   `bitrate` int(11) DEFAULT NULL,
0528   `length` int(11) DEFAULT NULL,
0529   `samplerate` int(11) DEFAULT NULL,
0530   `filesize` int(11) DEFAULT NULL,
0531   `filetype` int(11) DEFAULT NULL,
0532   `bpm` float DEFAULT NULL,
0533   `createdate` int(11) DEFAULT NULL,
0534   `modifydate` int(11) DEFAULT NULL,
0535   `albumgain` float DEFAULT NULL,
0536   `albumpeakgain` float DEFAULT NULL,
0537   `trackgain` float DEFAULT NULL,
0538   `trackpeakgain` float DEFAULT NULL,
0539   PRIMARY KEY (`id`),
0540   UNIQUE KEY `tracks_url` (`url`),
0541   KEY `tracks_id` (`id`),
0542   KEY `tracks_artist` (`artist`),
0543   KEY `tracks_album` (`album`),
0544   KEY `tracks_genre` (`genre`),
0545   KEY `tracks_composer` (`composer`),
0546   KEY `tracks_year` (`year`),
0547   KEY `tracks_title` (`title`),
0548   KEY `tracks_discnumber` (`discnumber`),
0549   KEY `tracks_createdate` (`createdate`),
0550   KEY `tracks_length` (`length`),
0551   KEY `tracks_bitrate` (`bitrate`),
0552   KEY `tracks_filesize` (`filesize`)
0553 ) ENGINE=MyISAM AUTO_INCREMENT=6721 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0554 /*!40101 SET character_set_client = @saved_cs_client */;
0555 
0556 --
0557 -- Table structure for table `urls`
0558 --
0559 
0560 DROP TABLE IF EXISTS `urls`;
0561 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0562 /*!40101 SET character_set_client = utf8 */;
0563 CREATE TABLE `urls` (
0564   `id` int(11) NOT NULL AUTO_INCREMENT,
0565   `deviceid` int(11) DEFAULT NULL,
0566   `rpath` varchar(324) COLLATE utf8_bin NOT NULL,
0567   `directory` int(11) DEFAULT NULL,
0568   `uniqueid` varchar(128) COLLATE utf8_bin DEFAULT NULL,
0569   PRIMARY KEY (`id`),
0570   UNIQUE KEY `uniqueid` (`uniqueid`),
0571   UNIQUE KEY `urls_id_rpath` (`deviceid`,`rpath`),
0572   KEY `urls_uniqueid` (`uniqueid`),
0573   KEY `urls_directory` (`directory`)
0574 ) ENGINE=MyISAM AUTO_INCREMENT=6721 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0575 /*!40101 SET character_set_client = @saved_cs_client */;
0576 
0577 --
0578 -- Table structure for table `urls_labels`
0579 --
0580 
0581 DROP TABLE IF EXISTS `urls_labels`;
0582 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0583 /*!40101 SET character_set_client = utf8 */;
0584 CREATE TABLE `urls_labels` (
0585   `url` int(11) DEFAULT NULL,
0586   `label` int(11) DEFAULT NULL,
0587   KEY `urlslabels_url` (`url`),
0588   KEY `urlslabels_label` (`label`)
0589 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0590 /*!40101 SET character_set_client = @saved_cs_client */;
0591 
0592 --
0593 -- Table structure for table `years`
0594 --
0595 
0596 DROP TABLE IF EXISTS `years`;
0597 /*!40101 SET @saved_cs_client     = @@character_set_client */;
0598 /*!40101 SET character_set_client = utf8 */;
0599 CREATE TABLE `years` (
0600   `id` int(11) NOT NULL AUTO_INCREMENT,
0601   `name` varchar(255) COLLATE utf8_bin NOT NULL,
0602   PRIMARY KEY (`id`),
0603   UNIQUE KEY `years_name` (`name`)
0604 ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
0605 /*!40101 SET character_set_client = @saved_cs_client */;
0606 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
0607 
0608 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
0609 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
0610 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
0611 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
0612 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
0613 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
0614 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
0615 
0616 -- Dump completed on 2011-12-21 12:50:14