Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # --------------------------------------------------------
- # 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement