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