# --------------------------------------------------------
# Host:                         x.x.x.x
# DATABASE:                     xbmc_video2
# Server version:               5.1.45-community
# Server OS:                    Win64
# HeidiSQL version:             5.0.0.3222
# DATE/TIME:                    2010-04-17 09:25:12
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# Dumping DATABASE STRUCTURE FOR xbmc_video2
CREATE DATABASE IF NOT EXISTS `xbmc_video2` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `xbmc_video2`;


# Dumping STRUCTURE FOR TABLE xbmc_video2.actorlinkmovie
CREATE TABLE IF NOT EXISTS `actorlinkmovie` (
  `idActor` INT(11) DEFAULT NULL,
  `idMovie` INT(11) DEFAULT NULL,
  `strRole` text,
  UNIQUE KEY `ix_actorlinkmovie_1` (`idActor`,`idMovie`),
  UNIQUE KEY `ix_actorlinkmovie_2` (`idMovie`,`idActor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.actors
CREATE TABLE IF NOT EXISTS `actors` (
  `idActor` INT(11) NOT NULL AUTO_INCREMENT,
  `strActor` text,
  `strThumb` text,
  PRIMARY KEY (`idActor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.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=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.genre
CREATE TABLE IF NOT EXISTS `genre` (
  `idGenre` INT(11) NOT NULL AUTO_INCREMENT,
  `strGenre` text,
  PRIMARY KEY (`idGenre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.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=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.movie
CREATE TABLE IF NOT EXISTS `movie` (
  `idMovie` 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,
  `idFile` INT(11) DEFAULT NULL,
  PRIMARY KEY (`idMovie`),
  UNIQUE KEY `ix_movie_file_1` (`idFile`,`idMovie`),
  UNIQUE KEY `ix_movie_file_2` (`idMovie`,`idFile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.path
CREATE TABLE IF NOT EXISTS `path` (
  `idPath` INT(11) NOT NULL AUTO_INCREMENT,
  `strPath` VARCHAR(512) DEFAULT NULL,
  `strContent` text,
  `strScraper` text,
  `strHash` text,
  `scanRecursive` INT(11) DEFAULT NULL,
  `useFolderNames` tinyint(1) DEFAULT NULL,
  `strSettings` text,
  `noUpdate` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idPath`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.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,
  `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,
  UNIQUE KEY `ix_settings` (`idFile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.stacktimes
CREATE TABLE IF NOT EXISTS `stacktimes` (
  `idFile` INT(11) DEFAULT NULL,
  `times` text,
  UNIQUE KEY `ix_stacktimes` (`idFile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.sys_seq
CREATE TABLE IF NOT EXISTS `sys_seq` (
  `seq_name` VARCHAR(64) NOT NULL,
  `nextid` INT(11) NOT NULL,
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.version
CREATE TABLE IF NOT EXISTS `version` (
  `idVersion` INT(11) DEFAULT NULL,
  `iCompressCount` INT(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.


# Dumping STRUCTURE FOR TABLE xbmc_video2.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=InnoDB DEFAULT CHARSET=utf8;

# DATA exporting was unselected.
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;