XBMC video database update : v60 to v64 (tables structure only)

gistfile1.diff

--- v60.sql     2012-05-24 13:39:50.580203893 +0200
+++ v64.sql     2012-05-24 13:40:47.202049463 +0200
@@ -53,6 +53,21 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 --
+-- Table structure for table `art`
+--
+
+DROP TABLE IF EXISTS `art`;
+CREATE TABLE `art` (
+  `art_id` int(11) NOT NULL AUTO_INCREMENT,
+  `media_id` int(11) DEFAULT NULL,
+  `media_type` text,
+  `type` text,
+  `url` text,
+  PRIMARY KEY (`art_id`),
+  KEY `ix_art` (`media_id`,`media_type`(20),`type`(20))
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
 -- Table structure for table `artistlinkmusicvideo`
 --

@@ -185,11 +200,14 @@
   `c21` text,
   `c22` text,
   `c23` text,
+  `idShow` int(11) DEFAULT NULL,
   PRIMARY KEY (`idEpisode`),
   UNIQUE KEY `ix_episode_file_1` (`idEpisode`,`idFile`),
   UNIQUE KEY `id_episode_file_2` (`idFile`,`idEpisode`),
   KEY `ix_episode_season_episode` (`c12`,`c13`),
   KEY `ix_episode_bookmark` (`c17`),
+  KEY `ix_episode_show1` (`idEpisode`,`idShow`),
+  KEY `ix_episode_show2` (`idShow`,`idEpisode`),
   KEY `ixEpisodeBasePath` (`c19`(12))
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

@@ -204,6 +222,7 @@
   `strFilename` text,
   `playCount` int(11) DEFAULT NULL,
   `lastPlayed` text,
+  `dateAdded` text,
   PRIMARY KEY (`idFile`),
   UNIQUE KEY `ix_files` (`idPath`,`strFilename`(255))
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -359,11 +378,25 @@
   `strSettings` text,
   `noUpdate` tinyint(1) DEFAULT NULL,
   `exclude` tinyint(1) DEFAULT NULL,
+  `dateAdded` text,
   PRIMARY KEY (`idPath`),
   UNIQUE KEY `ix_path` (`strPath`(255))
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 --
+-- Table structure for table `seasons`
+--
+
+DROP TABLE IF EXISTS `seasons`;
+CREATE TABLE `seasons` (
+  `idSeason` int(11) NOT NULL AUTO_INCREMENT,
+  `idShow` int(11) DEFAULT NULL,
+  `season` int(11) DEFAULT NULL,
+  PRIMARY KEY (`idSeason`),
+  KEY `ix_seasons` (`idShow`,`season`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
 -- Table structure for table `setlinkmovie`
 --

@@ -537,18 +570,6 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 --
--- Table structure for table `tvshowlinkepisode`
---
-
-DROP TABLE IF EXISTS `tvshowlinkepisode`;
-CREATE TABLE `tvshowlinkepisode` (
-  `idShow` int(11) DEFAULT NULL,
-  `idEpisode` int(11) DEFAULT NULL,
-  UNIQUE KEY `ix_tvshowlinkepisode_1` (`idShow`,`idEpisode`),
-  UNIQUE KEY `ix_tvshowlinkepisode_2` (`idEpisode`,`idShow`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
 -- Table structure for table `tvshowlinkpath`
 --