-- phpMyAdmin SQL Dump
-- version 3.5.0-rc2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 27, 2012 at 08:47 
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `xbmc_video_60`
--

-- --------------------------------------------------------

--
-- Table structure for table `actorlinkepisode`
--

CREATE TABLE IF NOT EXISTS `actorlinkepisode` (
  `idActor` int(11) DEFAULT NULL,
  `idEpisode` int(11) DEFAULT NULL,
  `strRole` text,
  `iOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_actorlinkepisode_1` (`idActor`,`idEpisode`),
  UNIQUE KEY `ix_actorlinkepisode_2` (`idEpisode`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `actorlinkmovie`
--

CREATE TABLE IF NOT EXISTS `actorlinkmovie` (
  `idActor` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  `strRole` text,
  `iOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_actorlinkmovie_1` (`idActor`,`idMovie`),
  UNIQUE KEY `ix_actorlinkmovie_2` (`idMovie`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `actorlinktvshow`
--

CREATE TABLE IF NOT EXISTS `actorlinktvshow` (
  `idActor` int(11) DEFAULT NULL,
  `idShow` int(11) DEFAULT NULL,
  `strRole` text,
  `iOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_actorlinktvshow_1` (`idActor`,`idShow`),
  UNIQUE KEY `ix_actorlinktvshow_2` (`idShow`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `actors`
--

CREATE TABLE IF NOT EXISTS `actors` (
  `idActor` int(11) NOT NULL AUTO_INCREMENT,
  `strActor` text,
  `strThumb` text,
  PRIMARY KEY (`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `artistlinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `artistlinkmusicvideo` (
  `idArtist` int(11) DEFAULT NULL,
  `idMVideo` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_artistlinkmusicvideo_1` (`idArtist`,`idMVideo`),
  UNIQUE KEY `ix_artistlinkmusicvideo_2` (`idMVideo`,`idArtist`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `bookmark`
--

CREATE TABLE IF NOT EXISTS `bookmark` (
  `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
  `idFile` int(11) DEFAULT NULL,
  `timeInSeconds` double DEFAULT NULL,
  `totalTimeInSeconds` double DEFAULT NULL,
  `thumbNailImage` text,
  `player` text,
  `playerState` text,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`idBookmark`),
  KEY `ix_bookmark` (`idFile`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `idCountry` int(11) NOT NULL AUTO_INCREMENT,
  `strCountry` text,
  PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `countrylinkmovie`
--

CREATE TABLE IF NOT EXISTS `countrylinkmovie` (
  `idCountry` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_countrylinkmovie_1` (`idCountry`,`idMovie`),
  UNIQUE KEY `ix_countrylinkmovie_2` (`idMovie`,`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `directorlinkepisode`
--

CREATE TABLE IF NOT EXISTS `directorlinkepisode` (
  `idDirector` int(11) DEFAULT NULL,
  `idEpisode` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_directorlinkepisode_1` (`idDirector`,`idEpisode`),
  UNIQUE KEY `ix_directorlinkepisode_2` (`idEpisode`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `directorlinkmovie`
--

CREATE TABLE IF NOT EXISTS `directorlinkmovie` (
  `idDirector` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_directorlinkmovie_1` (`idDirector`,`idMovie`),
  UNIQUE KEY `ix_directorlinkmovie_2` (`idMovie`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `directorlinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `directorlinkmusicvideo` (
  `idDirector` int(11) DEFAULT NULL,
  `idMVideo` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_directorlinkmusicvideo_1` (`idDirector`,`idMVideo`),
  UNIQUE KEY `ix_directorlinkmusicvideo_2` (`idMVideo`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `directorlinktvshow`
--

CREATE TABLE IF NOT EXISTS `directorlinktvshow` (
  `idDirector` int(11) DEFAULT NULL,
  `idShow` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_directorlinktvshow_1` (`idDirector`,`idShow`),
  UNIQUE KEY `ix_directorlinktvshow_2` (`idShow`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `episode`
--

CREATE TABLE IF NOT EXISTS `episode` (
  `idEpisode` int(11) NOT NULL AUTO_INCREMENT,
  `idFile` int(11) DEFAULT NULL,
  `c00` text,
  `c01` text,
  `c02` text,
  `c03` text,
  `c04` text,
  `c05` text,
  `c06` text,
  `c07` text,
  `c08` text,
  `c09` text,
  `c10` text,
  `c11` text,
  `c12` varchar(24) DEFAULT NULL,
  `c13` varchar(24) DEFAULT NULL,
  `c14` text,
  `c15` text,
  `c16` text,
  `c17` varchar(24) DEFAULT NULL,
  `c18` text,
  `c19` text,
  `c20` text,
  `c21` text,
  `c22` text,
  `c23` text,
  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 `ixEpisodeBasePath` (`c19`(12))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Stand-in structure for view `episodeview`
--
CREATE TABLE IF NOT EXISTS `episodeview` (
`idEpisode` int(11)
,`idFile` int(11)
,`c00` text
,`c01` text
,`c02` text
,`c03` text
,`c04` text
,`c05` text
,`c06` text
,`c07` text
,`c08` text
,`c09` text
,`c10` text
,`c11` text
,`c12` varchar(24)
,`c13` varchar(24)
,`c14` text
,`c15` text
,`c16` text
,`c17` varchar(24)
,`c18` text
,`c19` text
,`c20` text
,`c21` text
,`c22` text
,`c23` text
,`strFileName` text
,`strPath` text
,`playCount` int(11)
,`lastPlayed` text
,`strTitle` text
,`strStudio` text
,`idShow` int(11)
,`premiered` text
,`mpaa` text
,`strShowPath` text
);
-- --------------------------------------------------------

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `idFile` int(11) NOT NULL AUTO_INCREMENT,
  `idPath` int(11) DEFAULT NULL,
  `strFilename` text,
  `playCount` int(11) DEFAULT NULL,
  `lastPlayed` text,
  PRIMARY KEY (`idFile`),
  UNIQUE KEY `ix_files` (`idPath`,`strFilename`(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `genre`
--

CREATE TABLE IF NOT EXISTS `genre` (
  `idGenre` int(11) NOT NULL AUTO_INCREMENT,
  `strGenre` text,
  PRIMARY KEY (`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `genrelinkmovie`
--

CREATE TABLE IF NOT EXISTS `genrelinkmovie` (
  `idGenre` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_genrelinkmovie_1` (`idGenre`,`idMovie`),
  UNIQUE KEY `ix_genrelinkmovie_2` (`idMovie`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `genrelinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `genrelinkmusicvideo` (
  `idGenre` int(11) DEFAULT NULL,
  `idMVideo` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_genrelinkmusicvideo_1` (`idGenre`,`idMVideo`),
  UNIQUE KEY `ix_genrelinkmusicvideo_2` (`idMVideo`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `genrelinktvshow`
--

CREATE TABLE IF NOT EXISTS `genrelinktvshow` (
  `idGenre` int(11) DEFAULT NULL,
  `idShow` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_genrelinktvshow_1` (`idGenre`,`idShow`),
  UNIQUE KEY `ix_genrelinktvshow_2` (`idShow`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `movie`
--

CREATE TABLE IF NOT EXISTS `movie` (
  `idMovie` int(11) NOT NULL AUTO_INCREMENT,
  `idFile` int(11) DEFAULT NULL,
  `c00` text,
  `c01` text,
  `c02` text,
  `c03` text,
  `c04` text,
  `c05` text,
  `c06` text,
  `c07` text,
  `c08` text,
  `c09` text,
  `c10` text,
  `c11` text,
  `c12` text,
  `c13` text,
  `c14` text,
  `c15` text,
  `c16` text,
  `c17` text,
  `c18` text,
  `c19` text,
  `c20` text,
  `c21` text,
  `c22` text,
  `c23` text,
  PRIMARY KEY (`idMovie`),
  UNIQUE KEY `ix_movie_file_1` (`idFile`,`idMovie`),
  UNIQUE KEY `ix_movie_file_2` (`idMovie`,`idFile`),
  KEY `ixMovieBasePath` (`c23`(12))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `movielinktvshow`
--

CREATE TABLE IF NOT EXISTS `movielinktvshow` (
  `idMovie` int(11) DEFAULT NULL,
  `IdShow` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_movielinktvshow_1` (`IdShow`,`idMovie`),
  UNIQUE KEY `ix_movielinktvshow_2` (`idMovie`,`IdShow`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Stand-in structure for view `movieview`
--
CREATE TABLE IF NOT EXISTS `movieview` (
`idMovie` int(11)
,`idFile` int(11)
,`c00` text
,`c01` text
,`c02` text
,`c03` text
,`c04` text
,`c05` text
,`c06` text
,`c07` text
,`c08` text
,`c09` text
,`c10` text
,`c11` text
,`c12` text
,`c13` text
,`c14` text
,`c15` text
,`c16` text
,`c17` text
,`c18` text
,`c19` text
,`c20` text
,`c21` text
,`c22` text
,`c23` text
,`strFileName` text
,`strPath` text
,`playCount` int(11)
,`lastPlayed` text
);
-- --------------------------------------------------------

--
-- Table structure for table `musicvideo`
--

CREATE TABLE IF NOT EXISTS `musicvideo` (
  `idMVideo` int(11) NOT NULL AUTO_INCREMENT,
  `idFile` int(11) DEFAULT NULL,
  `c00` text,
  `c01` text,
  `c02` text,
  `c03` text,
  `c04` text,
  `c05` text,
  `c06` text,
  `c07` text,
  `c08` text,
  `c09` text,
  `c10` text,
  `c11` text,
  `c12` text,
  `c13` text,
  `c14` text,
  `c15` text,
  `c16` text,
  `c17` text,
  `c18` text,
  `c19` text,
  `c20` text,
  `c21` text,
  `c22` text,
  `c23` text,
  PRIMARY KEY (`idMVideo`),
  UNIQUE KEY `ix_musicvideo_file_1` (`idMVideo`,`idFile`),
  UNIQUE KEY `ix_musicvideo_file_2` (`idFile`,`idMVideo`),
  KEY `ixMusicVideoBasePath` (`c14`(12))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Stand-in structure for view `musicvideoview`
--
CREATE TABLE IF NOT EXISTS `musicvideoview` (
`idMVideo` int(11)
,`idFile` int(11)
,`c00` text
,`c01` text
,`c02` text
,`c03` text
,`c04` text
,`c05` text
,`c06` text
,`c07` text
,`c08` text
,`c09` text
,`c10` text
,`c11` text
,`c12` text
,`c13` text
,`c14` text
,`c15` text
,`c16` text
,`c17` text
,`c18` text
,`c19` text
,`c20` text
,`c21` text
,`c22` text
,`c23` text
,`strFileName` text
,`strPath` text
,`playCount` int(11)
,`lastPlayed` text
);
-- --------------------------------------------------------

--
-- Table structure for table `path`
--

CREATE TABLE IF NOT EXISTS `path` (
  `idPath` int(11) NOT NULL AUTO_INCREMENT,
  `strPath` text,
  `strContent` text,
  `strScraper` text,
  `strHash` text,
  `scanRecursive` int(11) DEFAULT NULL,
  `useFolderNames` tinyint(1) DEFAULT NULL,
  `strSettings` text,
  `noUpdate` tinyint(1) DEFAULT NULL,
  `exclude` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idPath`),
  UNIQUE KEY `ix_path` (`strPath`(255))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `path`
--

INSERT INTO `path` (`idPath`, `strPath`, `strContent`, `strScraper`, `strHash`, `scanRecursive`, `useFolderNames`, `strSettings`, `noUpdate`, `exclude`) VALUES
(1, 'O:\\3D (1080p)\\', 'movies', 'metadata.themoviedb.org', NULL, 2147483647, 1, '<settings><setting id="RatingS" value="TMDb" /><setting id="TrailerQ" value="No" /><setting id="fanart" value="true" /><setting id="keeporiginaltitle" value="false" /><setting id="language" value="en" /><setting id="trailer" value="true" /></settings>', 0, 0),
(2, 'O:\\HD (1080p)\\', 'movies', 'metadata.themoviedb.org', NULL, 2147483647, 1, '<settings><setting id="RatingS" value="TMDb" /><setting id="TrailerQ" value="No" /><setting id="fanart" value="true" /><setting id="keeporiginaltitle" value="false" /><setting id="language" value="en" /><setting id="trailer" value="true" /></settings>', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `setlinkmovie`
--

CREATE TABLE IF NOT EXISTS `setlinkmovie` (
  `idSet` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_setlinkmovie_1` (`idSet`,`idMovie`),
  UNIQUE KEY `ix_setlinkmovie_2` (`idMovie`,`idSet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sets`
--

CREATE TABLE IF NOT EXISTS `sets` (
  `idSet` int(11) NOT NULL AUTO_INCREMENT,
  `strSet` text,
  PRIMARY KEY (`idSet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `idFile` int(11) DEFAULT NULL,
  `Deinterlace` tinyint(1) DEFAULT NULL,
  `ViewMode` int(11) DEFAULT NULL,
  `ZoomAmount` float DEFAULT NULL,
  `PixelRatio` float DEFAULT NULL,
  `VerticalShift` float DEFAULT NULL,
  `AudioStream` int(11) DEFAULT NULL,
  `SubtitleStream` int(11) DEFAULT NULL,
  `SubtitleDelay` float DEFAULT NULL,
  `SubtitlesOn` tinyint(1) DEFAULT NULL,
  `Brightness` float DEFAULT NULL,
  `Contrast` float DEFAULT NULL,
  `Gamma` float DEFAULT NULL,
  `VolumeAmplification` float DEFAULT NULL,
  `AudioDelay` float DEFAULT NULL,
  `OutputToAllSpeakers` tinyint(1) DEFAULT NULL,
  `ResumeTime` int(11) DEFAULT NULL,
  `Crop` tinyint(1) DEFAULT NULL,
  `CropLeft` int(11) DEFAULT NULL,
  `CropRight` int(11) DEFAULT NULL,
  `CropTop` int(11) DEFAULT NULL,
  `CropBottom` int(11) DEFAULT NULL,
  `Sharpness` float DEFAULT NULL,
  `NoiseReduction` float DEFAULT NULL,
  `NonLinStretch` tinyint(1) DEFAULT NULL,
  `PostProcess` tinyint(1) DEFAULT NULL,
  `ScalingMethod` int(11) DEFAULT NULL,
  `DeinterlaceMode` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_settings` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `stacktimes`
--

CREATE TABLE IF NOT EXISTS `stacktimes` (
  `idFile` int(11) DEFAULT NULL,
  `times` text,
  UNIQUE KEY `ix_stacktimes` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `streamdetails`
--

CREATE TABLE IF NOT EXISTS `streamdetails` (
  `idFile` int(11) DEFAULT NULL,
  `iStreamType` int(11) DEFAULT NULL,
  `strVideoCodec` text,
  `fVideoAspect` float DEFAULT NULL,
  `iVideoWidth` int(11) DEFAULT NULL,
  `iVideoHeight` int(11) DEFAULT NULL,
  `strAudioCodec` text,
  `iAudioChannels` int(11) DEFAULT NULL,
  `strAudioLanguage` text,
  `strSubtitleLanguage` text,
  `iVideoDuration` int(11) DEFAULT NULL,
  KEY `ix_streamdetails` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `studio`
--

CREATE TABLE IF NOT EXISTS `studio` (
  `idStudio` int(11) NOT NULL AUTO_INCREMENT,
  `strStudio` text,
  PRIMARY KEY (`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `studiolinkmovie`
--

CREATE TABLE IF NOT EXISTS `studiolinkmovie` (
  `idStudio` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_studiolinkmovie_1` (`idStudio`,`idMovie`),
  UNIQUE KEY `ix_studiolinkmovie_2` (`idMovie`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `studiolinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `studiolinkmusicvideo` (
  `idStudio` int(11) DEFAULT NULL,
  `idMVideo` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_studiolinkmusicvideo_1` (`idStudio`,`idMVideo`),
  UNIQUE KEY `ix_studiolinkmusicvideo_2` (`idMVideo`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `studiolinktvshow`
--

CREATE TABLE IF NOT EXISTS `studiolinktvshow` (
  `idStudio` int(11) DEFAULT NULL,
  `idShow` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_studiolinktvshow_1` (`idStudio`,`idShow`),
  UNIQUE KEY `ix_studiolinktvshow_2` (`idShow`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tvshow`
--

CREATE TABLE IF NOT EXISTS `tvshow` (
  `idShow` int(11) NOT NULL AUTO_INCREMENT,
  `c00` text,
  `c01` text,
  `c02` text,
  `c03` text,
  `c04` text,
  `c05` text,
  `c06` text,
  `c07` text,
  `c08` text,
  `c09` text,
  `c10` text,
  `c11` text,
  `c12` text,
  `c13` text,
  `c14` text,
  `c15` text,
  `c16` text,
  `c17` text,
  `c18` text,
  `c19` text,
  `c20` text,
  `c21` text,
  `c22` text,
  `c23` text,
  PRIMARY KEY (`idShow`),
  KEY `ixTVShowBasePath` (`c17`(12))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tvshowlinkepisode`
--

CREATE TABLE IF NOT EXISTS `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`
--

CREATE TABLE IF NOT EXISTS `tvshowlinkpath` (
  `idShow` int(11) DEFAULT NULL,
  `idPath` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_tvshowlinkpath_1` (`idShow`,`idPath`),
  UNIQUE KEY `ix_tvshowlinkpath_2` (`idPath`,`idShow`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Stand-in structure for view `tvshowview`
--
CREATE TABLE IF NOT EXISTS `tvshowview` (
`idShow` int(11)
,`c00` text
,`c01` text
,`c02` text
,`c03` text
,`c04` text
,`c05` text
,`c06` text
,`c07` text
,`c08` text
,`c09` text
,`c10` text
,`c11` text
,`c12` text
,`c13` text
,`c14` text
,`c15` text
,`c16` text
,`c17` text
,`c18` text
,`c19` text
,`c20` text
,`c21` text
,`c22` text
,`c23` text
,`strPath` text
,`totalCount` bigint(21)
,`watchedcount` bigint(21)
,`totalSeasons` bigint(21)
);
-- --------------------------------------------------------

--
-- Table structure for table `version`
--

CREATE TABLE IF NOT EXISTS `version` (
  `idVersion` int(11) DEFAULT NULL,
  `iCompressCount` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `version`
--

INSERT INTO `version` (`idVersion`, `iCompressCount`) VALUES
(60, 0);

-- --------------------------------------------------------

--
-- Table structure for table `writerlinkepisode`
--

CREATE TABLE IF NOT EXISTS `writerlinkepisode` (
  `idWriter` int(11) DEFAULT NULL,
  `idEpisode` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_writerlinkepisode_1` (`idWriter`,`idEpisode`),
  UNIQUE KEY `ix_writerlinkepisode_2` (`idEpisode`,`idWriter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `writerlinkmovie`
--

CREATE TABLE IF NOT EXISTS `writerlinkmovie` (
  `idWriter` int(11) DEFAULT NULL,
  `idMovie` int(11) DEFAULT NULL,
  UNIQUE KEY `ix_writerlinkmovie_1` (`idWriter`,`idMovie`),
  UNIQUE KEY `ix_writerlinkmovie_2` (`idMovie`,`idWriter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure for view `episodeview`
--
DROP TABLE IF EXISTS `episodeview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `episodeview` AS select `episode`.`idEpisode` AS `idEpisode`,`episode`.`idFile` AS `idFile`,`episode`.`c00` AS `c00`,`episode`.`c01` AS `c01`,`episode`.`c02` AS `c02`,`episode`.`c03` AS `c03`,`episode`.`c04` AS `c04`,`episode`.`c05` AS `c05`,`episode`.`c06` AS `c06`,`episode`.`c07` AS `c07`,`episode`.`c08` AS `c08`,`episode`.`c09` AS `c09`,`episode`.`c10` AS `c10`,`episode`.`c11` AS `c11`,`episode`.`c12` AS `c12`,`episode`.`c13` AS `c13`,`episode`.`c14` AS `c14`,`episode`.`c15` AS `c15`,`episode`.`c16` AS `c16`,`episode`.`c17` AS `c17`,`episode`.`c18` AS `c18`,`episode`.`c19` AS `c19`,`episode`.`c20` AS `c20`,`episode`.`c21` AS `c21`,`episode`.`c22` AS `c22`,`episode`.`c23` AS `c23`,`files`.`strFilename` AS `strFileName`,`path`.`strPath` AS `strPath`,`files`.`playCount` AS `playCount`,`files`.`lastPlayed` AS `lastPlayed`,`tvshow`.`c00` AS `strTitle`,`tvshow`.`c14` AS `strStudio`,`tvshow`.`idShow` AS `idShow`,`tvshow`.`c05` AS `premiered`,`tvshow`.`c13` AS `mpaa`,`tvshow`.`c16` AS `strShowPath` from ((((`episode` join `files` on((`files`.`idFile` = `episode`.`idFile`))) join `tvshowlinkepisode` on((`episode`.`idEpisode` = `tvshowlinkepisode`.`idEpisode`))) join `tvshow` on((`tvshow`.`idShow` = `tvshowlinkepisode`.`idShow`))) join `path` on((`files`.`idPath` = `path`.`idPath`)));

-- --------------------------------------------------------

--
-- Structure for view `movieview`
--
DROP TABLE IF EXISTS `movieview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `movieview` AS select `movie`.`idMovie` AS `idMovie`,`movie`.`idFile` AS `idFile`,`movie`.`c00` AS `c00`,`movie`.`c01` AS `c01`,`movie`.`c02` AS `c02`,`movie`.`c03` AS `c03`,`movie`.`c04` AS `c04`,`movie`.`c05` AS `c05`,`movie`.`c06` AS `c06`,`movie`.`c07` AS `c07`,`movie`.`c08` AS `c08`,`movie`.`c09` AS `c09`,`movie`.`c10` AS `c10`,`movie`.`c11` AS `c11`,`movie`.`c12` AS `c12`,`movie`.`c13` AS `c13`,`movie`.`c14` AS `c14`,`movie`.`c15` AS `c15`,`movie`.`c16` AS `c16`,`movie`.`c17` AS `c17`,`movie`.`c18` AS `c18`,`movie`.`c19` AS `c19`,`movie`.`c20` AS `c20`,`movie`.`c21` AS `c21`,`movie`.`c22` AS `c22`,`movie`.`c23` AS `c23`,`files`.`strFilename` AS `strFileName`,`path`.`strPath` AS `strPath`,`files`.`playCount` AS `playCount`,`files`.`lastPlayed` AS `lastPlayed` from ((`movie` join `files` on((`files`.`idFile` = `movie`.`idFile`))) join `path` on((`path`.`idPath` = `files`.`idPath`)));

-- --------------------------------------------------------

--
-- Structure for view `musicvideoview`
--
DROP TABLE IF EXISTS `musicvideoview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `musicvideoview` AS select `musicvideo`.`idMVideo` AS `idMVideo`,`musicvideo`.`idFile` AS `idFile`,`musicvideo`.`c00` AS `c00`,`musicvideo`.`c01` AS `c01`,`musicvideo`.`c02` AS `c02`,`musicvideo`.`c03` AS `c03`,`musicvideo`.`c04` AS `c04`,`musicvideo`.`c05` AS `c05`,`musicvideo`.`c06` AS `c06`,`musicvideo`.`c07` AS `c07`,`musicvideo`.`c08` AS `c08`,`musicvideo`.`c09` AS `c09`,`musicvideo`.`c10` AS `c10`,`musicvideo`.`c11` AS `c11`,`musicvideo`.`c12` AS `c12`,`musicvideo`.`c13` AS `c13`,`musicvideo`.`c14` AS `c14`,`musicvideo`.`c15` AS `c15`,`musicvideo`.`c16` AS `c16`,`musicvideo`.`c17` AS `c17`,`musicvideo`.`c18` AS `c18`,`musicvideo`.`c19` AS `c19`,`musicvideo`.`c20` AS `c20`,`musicvideo`.`c21` AS `c21`,`musicvideo`.`c22` AS `c22`,`musicvideo`.`c23` AS `c23`,`files`.`strFilename` AS `strFileName`,`path`.`strPath` AS `strPath`,`files`.`playCount` AS `playCount`,`files`.`lastPlayed` AS `lastPlayed` from ((`musicvideo` join `files` on((`files`.`idFile` = `musicvideo`.`idFile`))) join `path` on((`path`.`idPath` = `files`.`idPath`)));

-- --------------------------------------------------------

--
-- Structure for view `tvshowview`
--
DROP TABLE IF EXISTS `tvshowview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `tvshowview` AS select `tvshow`.`idShow` AS `idShow`,`tvshow`.`c00` AS `c00`,`tvshow`.`c01` AS `c01`,`tvshow`.`c02` AS `c02`,`tvshow`.`c03` AS `c03`,`tvshow`.`c04` AS `c04`,`tvshow`.`c05` AS `c05`,`tvshow`.`c06` AS `c06`,`tvshow`.`c07` AS `c07`,`tvshow`.`c08` AS `c08`,`tvshow`.`c09` AS `c09`,`tvshow`.`c10` AS `c10`,`tvshow`.`c11` AS `c11`,`tvshow`.`c12` AS `c12`,`tvshow`.`c13` AS `c13`,`tvshow`.`c14` AS `c14`,`tvshow`.`c15` AS `c15`,`tvshow`.`c16` AS `c16`,`tvshow`.`c17` AS `c17`,`tvshow`.`c18` AS `c18`,`tvshow`.`c19` AS `c19`,`tvshow`.`c20` AS `c20`,`tvshow`.`c21` AS `c21`,`tvshow`.`c22` AS `c22`,`tvshow`.`c23` AS `c23`,`path`.`strPath` AS `strPath`,nullif(count(`episode`.`c12`),0) AS `totalCount`,count(`files`.`playCount`) AS `watchedcount`,nullif(count(distinct `episode`.`c12`),0) AS `totalSeasons` from (((((`tvshow` left join `tvshowlinkpath` on((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`))) left join `path` on((`path`.`idPath` = `tvshowlinkpath`.`idPath`))) left join `tvshowlinkepisode` on((`tvshowlinkepisode`.`idShow` = `tvshow`.`idShow`))) left join `episode` on((`episode`.`idEpisode` = `tvshowlinkepisode`.`idEpisode`))) left join `files` on((`files`.`idFile` = `episode`.`idFile`))) group by `tvshow`.`idShow`;