· 7 years ago · Oct 13, 2018, 06:08 AM
1--- v60.sql 2012-05-24 13:39:50.580203893 +0200
2+++ v64.sql 2012-05-24 13:40:47.202049463 +0200
3@@ -53,6 +53,21 @@
4 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
5
6 --
7+-- Table structure for table `art`
8+--
9+
10+DROP TABLE IF EXISTS `art`;
11+CREATE TABLE `art` (
12+ `art_id` int(11) NOT NULL AUTO_INCREMENT,
13+ `media_id` int(11) DEFAULT NULL,
14+ `media_type` text,
15+ `type` text,
16+ `url` text,
17+ PRIMARY KEY (`art_id`),
18+ KEY `ix_art` (`media_id`,`media_type`(20),`type`(20))
19+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
20+
21+--
22 -- Table structure for table `artistlinkmusicvideo`
23 --
24
25@@ -185,11 +200,14 @@
26 `c21` text,
27 `c22` text,
28 `c23` text,
29+ `idShow` int(11) DEFAULT NULL,
30 PRIMARY KEY (`idEpisode`),
31 UNIQUE KEY `ix_episode_file_1` (`idEpisode`,`idFile`),
32 UNIQUE KEY `id_episode_file_2` (`idFile`,`idEpisode`),
33 KEY `ix_episode_season_episode` (`c12`,`c13`),
34 KEY `ix_episode_bookmark` (`c17`),
35+ KEY `ix_episode_show1` (`idEpisode`,`idShow`),
36+ KEY `ix_episode_show2` (`idShow`,`idEpisode`),
37 KEY `ixEpisodeBasePath` (`c19`(12))
38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
39
40@@ -204,6 +222,7 @@
41 `strFilename` text,
42 `playCount` int(11) DEFAULT NULL,
43 `lastPlayed` text,
44+ `dateAdded` text,
45 PRIMARY KEY (`idFile`),
46 UNIQUE KEY `ix_files` (`idPath`,`strFilename`(255))
47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
48@@ -359,11 +378,25 @@
49 `strSettings` text,
50 `noUpdate` tinyint(1) DEFAULT NULL,
51 `exclude` tinyint(1) DEFAULT NULL,
52+ `dateAdded` text,
53 PRIMARY KEY (`idPath`),
54 UNIQUE KEY `ix_path` (`strPath`(255))
55 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
56
57 --
58+-- Table structure for table `seasons`
59+--
60+
61+DROP TABLE IF EXISTS `seasons`;
62+CREATE TABLE `seasons` (
63+ `idSeason` int(11) NOT NULL AUTO_INCREMENT,
64+ `idShow` int(11) DEFAULT NULL,
65+ `season` int(11) DEFAULT NULL,
66+ PRIMARY KEY (`idSeason`),
67+ KEY `ix_seasons` (`idShow`,`season`)
68+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
69+
70+--
71 -- Table structure for table `setlinkmovie`
72 --
73
74@@ -537,18 +570,6 @@
75 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
76
77 --
78--- Table structure for table `tvshowlinkepisode`
79---
80-
81-DROP TABLE IF EXISTS `tvshowlinkepisode`;
82-CREATE TABLE `tvshowlinkepisode` (
83- `idShow` int(11) DEFAULT NULL,
84- `idEpisode` int(11) DEFAULT NULL,
85- UNIQUE KEY `ix_tvshowlinkepisode_1` (`idShow`,`idEpisode`),
86- UNIQUE KEY `ix_tvshowlinkepisode_2` (`idEpisode`,`idShow`)
87-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
88-
89---
90 -- Table structure for table `tvshowlinkpath`
91 --