rendered paste body Server: localhost
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 17, 2006 at 03:37 PM
-- Server version: 4.0.24
-- PHP Version: 5.0.5-2ubuntu1.1
--
-- Database: `mysql`
--
CREATE DATABASE `mysql`;
USE mysql;
-- --------------------------------------------------------
--
-- Table structure for table `columns_priv`
--
CREATE TABLE `columns_priv` (
`Host` char(60) binary NOT NULL default '',
`Db` char(64) binary NOT NULL default '',
`User` char(16) binary NOT NULL default '',
`Table_name` char(64) binary NOT NULL default '',
`Column_name` char(64) binary NOT NULL default '',
`Timestamp` timestamp(14) NOT NULL,
`Column_priv` set('Select','Insert','Update','References') NOT NULL default '',
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) TYPE=MyISAM COMMENT='Column privileges';
-- --------------------------------------------------------
--
-- Table structure for table `db`
--
CREATE TABLE `db` (
`Host` char(60) binary NOT NULL default '',
`Db` char(64) binary NOT NULL default '',
`User` char(16) binary NOT NULL default '',
`Select_priv` enum('N','Y') NOT NULL default 'N',
`Insert_priv` enum('N','Y') NOT NULL default 'N',
`Update_priv` enum('N','Y') NOT NULL default 'N',
`Delete_priv` enum('N','Y') NOT NULL default 'N',
`Create_priv` enum('N','Y') NOT NULL default 'N',
`Drop_priv` enum('N','Y') NOT NULL default 'N',
`Grant_priv` enum('N','Y') NOT NULL default 'N',
`References_priv` enum('N','Y') NOT NULL default 'N',
`Index_priv` enum('N','Y') NOT NULL default 'N',
`Alter_priv` enum('N','Y') NOT NULL default 'N',
`Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
`Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`Host`,`Db`,`User`),
KEY `User` (`User`)
) TYPE=MyISAM COMMENT='Database privileges';
-- --------------------------------------------------------
--
-- Table structure for table `func`
--
CREATE TABLE `func` (
`name` char(64) binary NOT NULL default '',
`ret` tinyint(1) NOT NULL default '0',
`dl` char(128) NOT NULL default '',
`type` enum('function','aggregate') NOT NULL default 'function',
PRIMARY KEY (`name`)
) TYPE=MyISAM COMMENT='User defined functions';
-- --------------------------------------------------------
--
-- Table structure for table `host`
--
CREATE TABLE `host` (
`Host` char(60) binary NOT NULL default '',
`Db` char(64) binary NOT NULL default '',
`Select_priv` enum('N','Y') NOT NULL default 'N',
`Insert_priv` enum('N','Y') NOT NULL default 'N',
`Update_priv` enum('N','Y') NOT NULL default 'N',
`Delete_priv` enum('N','Y') NOT NULL default 'N',
`Create_priv` enum('N','Y') NOT NULL default 'N',
`Drop_priv` enum('N','Y') NOT NULL default 'N',
`Grant_priv` enum('N','Y') NOT NULL default 'N',
`References_priv` enum('N','Y') NOT NULL default 'N',
`Index_priv` enum('N','Y') NOT NULL default 'N',
`Alter_priv` enum('N','Y') NOT NULL default 'N',
`Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
`Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`Host`,`Db`)
) TYPE=MyISAM COMMENT='Host privileges; Merged with database privileges';
-- --------------------------------------------------------
--
-- Table structure for table `tables_priv`
--
CREATE TABLE `tables_priv` (
`Host` char(60) binary NOT NULL default '',
`Db` char(64) binary NOT NULL default '',
`User` char(16) binary NOT NULL default '',
`Table_name` char(64) binary NOT NULL default '',
`Grantor` char(77) NOT NULL default '',
`Timestamp` timestamp(14) NOT NULL,
`Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') NOT NULL default '',
`Column_priv` set('Select','Insert','Update','References') NOT NULL default '',
PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
KEY `Grantor` (`Grantor`)
) TYPE=MyISAM COMMENT='Table privileges';
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`Host` varchar(60) binary NOT NULL default '',
`User` varchar(16) binary NOT NULL default '',
`Password` varchar(16) binary NOT NULL default '',
`Select_priv` enum('N','Y') NOT NULL default 'N',
`Insert_priv` enum('N','Y') NOT NULL default 'N',
`Update_priv` enum('N','Y') NOT NULL default 'N',
`Delete_priv` enum('N','Y') NOT NULL default 'N',
`Create_priv` enum('N','Y') NOT NULL default 'N',
`Drop_priv` enum('N','Y') NOT NULL default 'N',
`Reload_priv` enum('N','Y') NOT NULL default 'N',
`Shutdown_priv` enum('N','Y') NOT NULL default 'N',
`Process_priv` enum('N','Y') NOT NULL default 'N',
`File_priv` enum('N','Y') NOT NULL default 'N',
`Grant_priv` enum('N','Y') NOT NULL default 'N',
`References_priv` enum('N','Y') NOT NULL default 'N',
`Index_priv` enum('N','Y') NOT NULL default 'N',
`Alter_priv` enum('N','Y') NOT NULL default 'N',
`Show_db_priv` enum('N','Y') NOT NULL default 'N',
`Super_priv` enum('N','Y') NOT NULL default 'N',
`Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
`Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
`Execute_priv` enum('N','Y') NOT NULL default 'N',
`Repl_slave_priv` enum('N','Y') NOT NULL default 'N',
`Repl_client_priv` enum('N','Y') NOT NULL default 'N',
`ssl_type` enum('','ANY','X509','SPECIFIED') NOT NULL default '',
`ssl_cipher` blob NOT NULL,
`x509_issuer` blob NOT NULL,
`x509_subject` blob NOT NULL,
`max_questions` int(11) unsigned NOT NULL default '0',
`max_updates` int(11) unsigned NOT NULL default '0',
`max_connections` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`Host`,`User`)
) TYPE=MyISAM COMMENT='Users and global privileges';
--
-- Database: `mythconverg`
--
CREATE DATABASE `mythconverg`;
USE mythconverg;
-- --------------------------------------------------------
--
-- Table structure for table `callsignnetworkmap`
--
CREATE TABLE `callsignnetworkmap` (
`id` int(11) NOT NULL auto_increment,
`callsign` varchar(20) NOT NULL default '',
`network` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `callsign` (`callsign`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `capturecard`
--
CREATE TABLE `capturecard` (
`cardid` int(10) unsigned NOT NULL auto_increment,
`videodevice` varchar(128) default NULL,
`audiodevice` varchar(128) default NULL,
`vbidevice` varchar(128) default NULL,
`cardtype` varchar(32) default 'V4L',
`defaultinput` varchar(32) default 'Television',
`audioratelimit` int(11) default NULL,
`hostname` varchar(255) default NULL,
`dvb_swfilter` int(11) default '0',
`dvb_recordts` int(11) default '1',
`dvb_sat_type` int(11) NOT NULL default '0',
`dvb_wait_for_seqstart` int(11) NOT NULL default '1',
`dvb_dmx_buf_size` int(11) NOT NULL default '8192',
`dvb_pkt_buf_size` int(11) NOT NULL default '8192',
`skipbtaudio` tinyint(1) default '0',
`dvb_on_demand` tinyint(4) NOT NULL default '0',
`dvb_diseqc_type` smallint(6) default NULL,
`firewire_port` int(10) unsigned NOT NULL default '0',
`firewire_node` int(10) unsigned NOT NULL default '2',
`firewire_speed` int(10) unsigned NOT NULL default '0',
`firewire_model` varchar(32) default NULL,
`firewire_connection` int(10) unsigned NOT NULL default '0',
`dvb_hw_decoder` int(11) default '0',
`dbox2_port` int(10) unsigned NOT NULL default '31338',
`dbox2_httpport` int(10) unsigned NOT NULL default '80',
`dbox2_host` varchar(32) default NULL,
`signal_timeout` int(11) NOT NULL default '1000',
`channel_timeout` int(11) NOT NULL default '3000',
PRIMARY KEY (`cardid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `cardinput`
--
CREATE TABLE `cardinput` (
`cardinputid` int(10) unsigned NOT NULL auto_increment,
`cardid` int(10) unsigned NOT NULL default '0',
`sourceid` int(10) unsigned NOT NULL default '0',
`inputname` varchar(32) NOT NULL default '',
`externalcommand` varchar(128) default NULL,
`preference` int(11) NOT NULL default '0',
`shareable` char(1) default 'N',
`tunechan` varchar(5) NOT NULL default '',
`startchan` varchar(5) NOT NULL default '',
`freetoaironly` tinyint(1) default '1',
`diseqc_port` smallint(6) default NULL,
`diseqc_pos` float default NULL,
`lnb_lof_switch` int(11) default '11700000',
`lnb_lof_hi` int(11) default '10600000',
`lnb_lof_lo` int(11) default '9750000',
`displayname` varchar(64) NOT NULL default '',
PRIMARY KEY (`cardinputid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `channel`
--
CREATE TABLE `channel` (
`chanid` int(10) unsigned NOT NULL default '0',
`channum` varchar(5) NOT NULL default '',
`freqid` varchar(10) default NULL,
`sourceid` int(10) unsigned default NULL,
`callsign` varchar(20) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
`icon` varchar(255) NOT NULL default 'none',
`finetune` int(11) default NULL,
`videofilters` varchar(255) NOT NULL default '',
`xmltvid` varchar(64) NOT NULL default '',
`recpriority` int(10) NOT NULL default '0',
`contrast` int(11) default '32768',
`brightness` int(11) default '32768',
`colour` int(11) default '32768',
`hue` int(11) default '32768',
`tvformat` varchar(10) NOT NULL default 'Default',
`commfree` tinyint(4) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '1',
`outputfilters` varchar(255) NOT NULL default '',
`useonairguide` tinyint(1) default '0',
`mplexid` smallint(6) default NULL,
`serviceid` mediumint(8) unsigned default NULL,
`atscsrcid` int(11) default NULL,
PRIMARY KEY (`chanid`),
KEY `channel_src` (`channum`,`sourceid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `codecparams`
--
CREATE TABLE `codecparams` (
`profile` int(10) unsigned NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`value` varchar(128) default NULL,
PRIMARY KEY (`profile`,`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `credits`
--
CREATE TABLE `credits` (
`person` mediumint(8) unsigned NOT NULL default '0',
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',
UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
KEY `person` (`person`,`role`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `dtv_multiplex`
--
CREATE TABLE `dtv_multiplex` (
`mplexid` smallint(6) NOT NULL auto_increment,
`sourceid` smallint(6) default NULL,
`transportid` int(11) default NULL,
`networkid` int(11) default NULL,
`frequency` int(11) default NULL,
`inversion` char(1) default 'a',
`symbolrate` int(11) default NULL,
`fec` varchar(10) default 'auto',
`polarity` char(1) default NULL,
`modulation` varchar(10) default 'auto',
`bandwidth` char(1) default 'a',
`lp_code_rate` varchar(10) default 'auto',
`transmission_mode` char(1) default 'a',
`guard_interval` varchar(10) default 'auto',
`visible` smallint(1) NOT NULL default '0',
`constellation` varchar(10) default 'auto',
`hierarchy` varchar(10) default 'auto',
`hp_code_rate` varchar(10) default 'auto',
`sistandard` varchar(10) default 'dvb',
`serviceversion` smallint(6) default '33',
`updatetimestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`mplexid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `dtv_privatetypes`
--
CREATE TABLE `dtv_privatetypes` (
`sitype` varchar(4) NOT NULL default '',
`networkid` int(11) NOT NULL default '0',
`private_type` varchar(20) NOT NULL default '',
`private_value` varchar(100) NOT NULL default ''
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `dvdinput`
--
CREATE TABLE `dvdinput` (
`intid` int(10) unsigned NOT NULL default '0',
`hsize` int(10) unsigned default NULL,
`vsize` int(10) unsigned default NULL,
`ar_num` int(10) unsigned default NULL,
`ar_denom` int(10) unsigned default NULL,
`fr_code` int(10) unsigned default NULL,
`letterbox` tinyint(1) default NULL,
`v_format` varchar(16) default NULL,
PRIMARY KEY (`intid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `dvdtranscode`
--
CREATE TABLE `dvdtranscode` (
`intid` int(11) NOT NULL auto_increment,
`input` int(10) unsigned default NULL,
`name` varchar(128) NOT NULL default '',
`sync_mode` int(10) unsigned default NULL,
`use_yv12` tinyint(1) default NULL,
`cliptop` int(11) default NULL,
`clipbottom` int(11) default NULL,
`clipleft` int(11) default NULL,
`clipright` int(11) default NULL,
`f_resize_h` int(11) default NULL,
`f_resize_w` int(11) default NULL,
`hq_resize_h` int(11) default NULL,
`hq_resize_w` int(11) default NULL,
`grow_h` int(11) default NULL,
`grow_w` int(11) default NULL,
`clip2top` int(11) default NULL,
`clip2bottom` int(11) default NULL,
`clip2left` int(11) default NULL,
`clip2right` int(11) default NULL,
`codec` varchar(128) NOT NULL default '',
`codec_param` varchar(128) default NULL,
`bitrate` int(11) default NULL,
`a_sample_r` int(11) default NULL,
`a_bitrate` int(11) default NULL,
`two_pass` tinyint(1) default NULL,
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Table structure for table `favorites`
--
CREATE TABLE `favorites` (
`favid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`chanid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`favid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `filemarkup`
--
CREATE TABLE `filemarkup` (
`filename` text NOT NULL,
`mark` bigint(20) NOT NULL default '0',
`offset` varchar(32) default NULL,
`type` int(11) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `gallerymetadata`
--
CREATE TABLE `gallerymetadata` (
`image` varchar(255) NOT NULL default '',
`angle` int(11) NOT NULL default '0',
PRIMARY KEY (`image`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `gamemetadata`
--
CREATE TABLE `gamemetadata` (
`system` varchar(128) NOT NULL default '',
`romname` varchar(128) NOT NULL default '',
`gamename` varchar(128) NOT NULL default '',
`genre` varchar(128) NOT NULL default '',
`year` varchar(10) NOT NULL default '',
`publisher` varchar(128) NOT NULL default '',
`favorite` tinyint(1) default NULL,
`rompath` varchar(255) NOT NULL default '',
`gametype` varchar(64) NOT NULL default '',
`diskcount` tinyint(1) NOT NULL default '1',
`country` varchar(128) NOT NULL default '',
`crc_value` varchar(64) NOT NULL default '',
`display` tinyint(1) NOT NULL default '1',
`version` varchar(64) NOT NULL default '',
KEY `system` (`system`),
KEY `year` (`year`),
KEY `romname` (`romname`),
KEY `gamename` (`gamename`),
KEY `genre` (`genre`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `gameplayers`
--
CREATE TABLE `gameplayers` (
`gameplayerid` int(10) unsigned NOT NULL auto_increment,
`playername` varchar(64) NOT NULL default '',
`workingpath` varchar(255) NOT NULL default '',
`rompath` varchar(255) NOT NULL default '',
`screenshots` varchar(255) NOT NULL default '',
`commandline` text NOT NULL,
`gametype` varchar(64) NOT NULL default '',
`extensions` varchar(128) NOT NULL default '',
`spandisks` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`gameplayerid`),
UNIQUE KEY `playername` (`playername`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping`
--
CREATE TABLE `housekeeping` (
`tag` varchar(64) NOT NULL default '',
`lastrun` datetime default NULL,
PRIMARY KEY (`tag`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `inuseprograms`
--
CREATE TABLE `inuseprograms` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`recusage` varchar(128) NOT NULL default '',
`lastupdatetime` datetime NOT NULL default '0000-00-00 00:00:00',
`hostname` varchar(255) NOT NULL default '',
KEY `chanid` (`chanid`,`starttime`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `jobqueue`
--
CREATE TABLE `jobqueue` (
`id` int(11) NOT NULL auto_increment,
`chanid` int(10) NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`inserttime` datetime NOT NULL default '0000-00-00 00:00:00',
`type` int(11) NOT NULL default '0',
`cmds` int(11) NOT NULL default '0',
`flags` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`statustime` timestamp(14) NOT NULL,
`hostname` varchar(255) NOT NULL default '',
`args` blob NOT NULL,
`comment` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Table structure for table `jumppoints`
--
CREATE TABLE `jumppoints` (
`destination` varchar(128) NOT NULL default '',
`description` varchar(255) default NULL,
`keylist` varchar(32) default NULL,
`hostname` varchar(255) NOT NULL default '',
PRIMARY KEY (`destination`,`hostname`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `keybindings`
--
CREATE TABLE `keybindings` (
`context` varchar(32) NOT NULL default '',
`action` varchar(32) NOT NULL default '',
`description` varchar(255) default NULL,
`keylist` varchar(32) default NULL,
`hostname` varchar(255) NOT NULL default '',
PRIMARY KEY (`context`,`action`,`hostname`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `keyword`
--
CREATE TABLE `keyword` (
`phrase` varchar(128) NOT NULL default '',
`searchtype` int(10) unsigned NOT NULL default '3',
UNIQUE KEY `phrase` (`phrase`,`searchtype`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `musicmetadata`
--
CREATE TABLE `musicmetadata` (
`intid` int(10) unsigned NOT NULL auto_increment,
`artist` varchar(128) NOT NULL default '',
`compilation_artist` varchar(128) NOT NULL default '',
`album` varchar(128) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`genre` varchar(128) NOT NULL default '',
`year` int(10) unsigned NOT NULL default '0',
`tracknum` int(10) unsigned NOT NULL default '0',
`length` int(10) unsigned NOT NULL default '0',
`filename` text NOT NULL,
`rating` int(10) unsigned NOT NULL default '5',
`lastplay` timestamp(14) NOT NULL,
`playcount` int(10) unsigned NOT NULL default '0',
`mythdigest` varchar(255) default NULL,
`size` bigint(20) unsigned default NULL,
`date_added` datetime default NULL,
`date_modified` datetime default NULL,
`format` varchar(4) default NULL,
`description` varchar(255) default NULL,
`comment` varchar(255) default NULL,
`compilation` tinyint(4) default '0',
`composer` varchar(255) default NULL,
`disc_count` smallint(5) unsigned default '0',
`disc_number` smallint(5) unsigned default '0',
`track_count` smallint(5) unsigned default '0',
`start_time` int(10) unsigned default '0',
`stop_time` int(10) unsigned default NULL,
`eq_preset` varchar(255) default NULL,
`relative_volume` tinyint(4) default '0',
`sample_rate` int(10) unsigned default NULL,
`bpm` smallint(5) unsigned default NULL,
PRIMARY KEY (`intid`),
KEY `artist` (`artist`),
KEY `album` (`album`),
KEY `title` (`title`),
KEY `genre` (`genre`),
KEY `mythdigest` (`mythdigest`),
KEY `compilation_artist` (`compilation_artist`)
) TYPE=MyISAM AUTO_INCREMENT=658 ;
-- --------------------------------------------------------
--
-- Table structure for table `musicplaylist`
--
CREATE TABLE `musicplaylist` (
`playlistid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
`hostname` varchar(255) default NULL,
`songlist` text NOT NULL,
PRIMARY KEY (`playlistid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `mythlog`
--
CREATE TABLE `mythlog` (
`logid` int(10) unsigned NOT NULL auto_increment,
`module` varchar(32) NOT NULL default '',
`priority` int(11) NOT NULL default '0',
`acknowledged` tinyint(1) default '0',
`logdate` datetime default NULL,
`host` varchar(128) default NULL,
`message` varchar(255) NOT NULL default '',
`details` text,
PRIMARY KEY (`logid`)
) TYPE=MyISAM AUTO_INCREMENT=5052 ;
-- --------------------------------------------------------
--
-- Table structure for table `mythweb_sessions`
--
CREATE TABLE `mythweb_sessions` (
`id` varchar(128) NOT NULL default '',
`modified` timestamp(14) NOT NULL,
`data` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `modified` (`modified`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `netflix`
--
CREATE TABLE `netflix` (
`name` varchar(100) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`ico` varchar(255) default NULL,
`updated` int(10) unsigned default NULL,
`is_queue` int(10) unsigned default NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `networkiconmap`
--
CREATE TABLE `networkiconmap` (
`id` int(11) NOT NULL auto_increment,
`network` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `network` (`network`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `newssites`
--
CREATE TABLE `newssites` (
`name` varchar(100) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`ico` varchar(255) default NULL,
`updated` int(10) unsigned default NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `oldfind`
--
CREATE TABLE `oldfind` (
`recordid` int(11) NOT NULL default '0',
`findid` int(11) NOT NULL default '0',
PRIMARY KEY (`recordid`,`findid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `oldprogram`
--
CREATE TABLE `oldprogram` (
`oldtitle` varchar(128) NOT NULL default '',
`airdate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`oldtitle`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `oldrecorded`
--
CREATE TABLE `oldrecorded` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`seriesid` varchar(12) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`findid` int(11) NOT NULL default '0',
`recordid` int(11) NOT NULL default '0',
`station` varchar(20) NOT NULL default '',
`rectype` int(10) unsigned NOT NULL default '0',
`duplicate` tinyint(1) NOT NULL default '0',
`recstatus` int(11) NOT NULL default '0',
`reactivate` smallint(6) NOT NULL default '0',
`generic` tinyint(1) default '0',
PRIMARY KEY (`station`,`starttime`,`title`),
KEY `endtime` (`endtime`),
KEY `title` (`title`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`),
KEY `recordid` (`recordid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `people`
--
CREATE TABLE `people` (
`person` mediumint(8) unsigned NOT NULL auto_increment,
`name` char(128) NOT NULL default '',
PRIMARY KEY (`person`),
UNIQUE KEY `name` (`name`(41))
) TYPE=MyISAM AUTO_INCREMENT=14671 ;
-- --------------------------------------------------------
--
-- Table structure for table `phonecallhistory`
--
CREATE TABLE `phonecallhistory` (
`recid` int(10) unsigned NOT NULL auto_increment,
`displayname` text NOT NULL,
`url` text NOT NULL,
`timestamp` text NOT NULL,
`duration` int(10) unsigned NOT NULL default '0',
`directionin` int(10) unsigned NOT NULL default '0',
`directoryref` int(10) unsigned default NULL,
PRIMARY KEY (`recid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `phonedirectory`
--
CREATE TABLE `phonedirectory` (
`intid` int(10) unsigned NOT NULL auto_increment,
`nickname` text NOT NULL,
`firstname` text,
`surname` text,
`url` text NOT NULL,
`directory` text NOT NULL,
`photofile` text,
`speeddial` int(10) unsigned NOT NULL default '0',
`onhomelan` int(10) unsigned default '0',
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `pidcache`
--
CREATE TABLE `pidcache` (
`chanid` smallint(6) NOT NULL default '0',
`pid` int(11) NOT NULL default '-1',
`tableid` int(11) NOT NULL default '-1',
KEY `chanid` (`chanid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `playgroup`
--
CREATE TABLE `playgroup` (
`name` varchar(32) NOT NULL default '',
`titlematch` varchar(255) NOT NULL default '',
`skipahead` int(11) NOT NULL default '0',
`skipback` int(11) NOT NULL default '0',
`timestretch` int(11) NOT NULL default '0',
`jump` int(11) NOT NULL default '0',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `profilegroups`
--
CREATE TABLE `profilegroups` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) default NULL,
`cardtype` varchar(32) NOT NULL default 'V4L',
`is_default` int(1) default '0',
`hostname` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`hostname`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Table structure for table `program`
--
CREATE TABLE `program` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`category_type` varchar(64) NOT NULL default '',
`airdate` year(4) NOT NULL default '0000',
`stars` float NOT NULL default '0',
`previouslyshown` tinyint(4) NOT NULL default '0',
`title_pronounce` varchar(128) NOT NULL default '',
`stereo` tinyint(1) NOT NULL default '0',
`subtitled` tinyint(1) NOT NULL default '0',
`hdtv` tinyint(1) NOT NULL default '0',
`closecaptioned` tinyint(1) NOT NULL default '0',
`partnumber` int(11) NOT NULL default '0',
`parttotal` int(11) NOT NULL default '0',
`seriesid` varchar(12) NOT NULL default '',
`originalairdate` date default NULL,
`showtype` varchar(30) NOT NULL default '',
`colorcode` varchar(20) NOT NULL default '',
`syndicatedepisodenumber` varchar(20) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`manualid` int(10) unsigned NOT NULL default '0',
`generic` tinyint(1) default '0',
PRIMARY KEY (`chanid`,`starttime`,`manualid`),
KEY `endtime` (`endtime`),
KEY `title` (`title`),
KEY `title_pronounce` (`title_pronounce`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`),
KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `programgenres`
--
CREATE TABLE `programgenres` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`relevance` char(1) NOT NULL default '',
`genre` char(30) default NULL,
PRIMARY KEY (`chanid`,`starttime`,`relevance`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `programrating`
--
CREATE TABLE `programrating` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`system` char(8) NOT NULL default '',
`rating` char(8) NOT NULL default '',
UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
KEY `starttime` (`starttime`,`system`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recgrouppassword`
--
CREATE TABLE `recgrouppassword` (
`recgroup` varchar(32) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
PRIMARY KEY (`recgroup`),
UNIQUE KEY `recgroup` (`recgroup`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `record`
--
CREATE TABLE `record` (
`recordid` int(10) unsigned NOT NULL auto_increment,
`type` int(10) unsigned NOT NULL default '0',
`chanid` int(10) unsigned default NULL,
`starttime` time NOT NULL default '00:00:00',
`startdate` date NOT NULL default '0000-00-00',
`endtime` time NOT NULL default '00:00:00',
`enddate` date NOT NULL default '0000-00-00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`profile` varchar(128) NOT NULL default 'Default',
`recpriority` int(10) NOT NULL default '0',
`autoexpire` int(11) NOT NULL default '0',
`maxepisodes` int(11) NOT NULL default '0',
`maxnewest` int(11) NOT NULL default '0',
`startoffset` int(11) NOT NULL default '0',
`endoffset` int(11) NOT NULL default '0',
`recgroup` varchar(32) NOT NULL default 'Default',
`dupmethod` int(11) NOT NULL default '6',
`dupin` int(11) NOT NULL default '15',
`station` varchar(20) NOT NULL default '',
`seriesid` varchar(12) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`search` int(10) unsigned NOT NULL default '0',
`autotranscode` tinyint(1) NOT NULL default '0',
`autocommflag` tinyint(1) NOT NULL default '0',
`autouserjob1` tinyint(1) NOT NULL default '0',
`autouserjob2` tinyint(1) NOT NULL default '0',
`autouserjob3` tinyint(1) NOT NULL default '0',
`autouserjob4` tinyint(1) NOT NULL default '0',
`findday` tinyint(4) NOT NULL default '0',
`findtime` time NOT NULL default '00:00:00',
`findid` int(11) NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
`parentid` int(11) NOT NULL default '0',
`transcoder` int(11) NOT NULL default '0',
`tsdefault` float NOT NULL default '1',
`playgroup` varchar(32) NOT NULL default 'Default',
PRIMARY KEY (`recordid`),
KEY `chanid` (`chanid`,`starttime`),
KEY `title` (`title`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`)
) TYPE=MyISAM AUTO_INCREMENT=106 ;
-- --------------------------------------------------------
--
-- Table structure for table `record_tmp`
--
CREATE TABLE `record_tmp` (
`recordid` int(10) unsigned NOT NULL default '0',
`type` int(10) unsigned NOT NULL default '0',
`chanid` int(10) unsigned default NULL,
`starttime` time NOT NULL default '00:00:00',
`startdate` date NOT NULL default '0000-00-00',
`endtime` time NOT NULL default '00:00:00',
`enddate` date NOT NULL default '0000-00-00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`profile` varchar(128) NOT NULL default 'Default',
`recpriority` int(10) NOT NULL default '0',
`autoexpire` int(11) NOT NULL default '0',
`maxepisodes` int(11) NOT NULL default '0',
`maxnewest` int(11) NOT NULL default '0',
`startoffset` int(11) NOT NULL default '0',
`endoffset` int(11) NOT NULL default '0',
`recgroup` varchar(32) NOT NULL default 'Default',
`dupmethod` int(11) NOT NULL default '6',
`dupin` int(11) NOT NULL default '15',
`station` varchar(20) NOT NULL default '',
`seriesid` varchar(12) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`search` int(10) unsigned NOT NULL default '0',
`autotranscode` tinyint(1) NOT NULL default '0',
`autocommflag` tinyint(1) NOT NULL default '0',
`autouserjob1` tinyint(1) NOT NULL default '0',
`autouserjob2` tinyint(1) NOT NULL default '0',
`autouserjob3` tinyint(1) NOT NULL default '0',
`autouserjob4` tinyint(1) NOT NULL default '0',
`findday` tinyint(4) NOT NULL default '0',
`findtime` time NOT NULL default '00:00:00',
`findid` int(11) NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
`parentid` int(11) NOT NULL default '0',
`transcoder` int(11) NOT NULL default '0',
`tsdefault` float NOT NULL default '1',
`playgroup` varchar(32) NOT NULL default 'Default'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recorded`
--
CREATE TABLE `recorded` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`hostname` varchar(255) NOT NULL default '',
`bookmark` varchar(128) default NULL,
`editing` int(10) unsigned NOT NULL default '0',
`cutlist` text,
`autoexpire` int(11) NOT NULL default '0',
`commflagged` int(10) unsigned NOT NULL default '0',
`recgroup` varchar(32) NOT NULL default 'Default',
`recordid` int(11) default NULL,
`seriesid` varchar(12) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`lastmodified` timestamp(14) NOT NULL,
`filesize` bigint(20) NOT NULL default '0',
`stars` float NOT NULL default '0',
`previouslyshown` tinyint(1) default '0',
`originalairdate` date default NULL,
`preserve` tinyint(1) NOT NULL default '0',
`findid` int(11) NOT NULL default '0',
`deletepending` tinyint(1) NOT NULL default '0',
`transcoder` int(11) NOT NULL default '0',
`timestretch` float NOT NULL default '1',
`recpriority` int(11) NOT NULL default '0',
`basename` varchar(128) NOT NULL default '',
`progstart` datetime NOT NULL default '0000-00-00 00:00:00',
`progend` datetime NOT NULL default '0000-00-00 00:00:00',
`playgroup` varchar(32) NOT NULL default 'Default',
`profile` varchar(32) NOT NULL default '',
PRIMARY KEY (`chanid`,`starttime`),
KEY `endtime` (`endtime`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`),
KEY `title` (`title`),
KEY `recordid` (`recordid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recordedcredits`
--
CREATE TABLE `recordedcredits` (
`person` mediumint(8) unsigned NOT NULL default '0',
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',
UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
KEY `person` (`person`,`role`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recordedmarkup`
--
CREATE TABLE `recordedmarkup` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`mark` bigint(20) NOT NULL default '0',
`offset` varchar(32) default NULL,
`type` int(11) NOT NULL default '0',
PRIMARY KEY (`chanid`,`starttime`,`mark`,`type`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recordedprogram`
--
CREATE TABLE `recordedprogram` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL default '',
`subtitle` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(64) NOT NULL default '',
`category_type` varchar(64) NOT NULL default '',
`airdate` year(4) NOT NULL default '0000',
`stars` float unsigned NOT NULL default '0',
`previouslyshown` tinyint(4) NOT NULL default '0',
`title_pronounce` varchar(128) NOT NULL default '',
`stereo` tinyint(1) NOT NULL default '0',
`subtitled` tinyint(1) NOT NULL default '0',
`hdtv` tinyint(1) NOT NULL default '0',
`closecaptioned` tinyint(1) NOT NULL default '0',
`partnumber` int(11) NOT NULL default '0',
`parttotal` int(11) NOT NULL default '0',
`seriesid` varchar(12) NOT NULL default '',
`originalairdate` date default NULL,
`showtype` varchar(30) NOT NULL default '',
`colorcode` varchar(20) NOT NULL default '',
`syndicatedepisodenumber` varchar(20) NOT NULL default '',
`programid` varchar(20) NOT NULL default '',
`manualid` int(10) unsigned NOT NULL default '0',
`generic` tinyint(1) default '0',
PRIMARY KEY (`chanid`,`starttime`,`manualid`),
KEY `endtime` (`endtime`),
KEY `title` (`title`),
KEY `title_pronounce` (`title_pronounce`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`),
KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recordedrating`
--
CREATE TABLE `recordedrating` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`system` char(8) NOT NULL default '',
`rating` char(8) NOT NULL default '',
UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),
KEY `starttime` (`starttime`,`system`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `recordingprofiles`
--
CREATE TABLE `recordingprofiles` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) default NULL,
`videocodec` varchar(128) default NULL,
`audiocodec` varchar(128) default NULL,
`profilegroup` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
--
-- Table structure for table `recordmatch`
--
CREATE TABLE `recordmatch` (
`recordid` int(10) unsigned default NULL,
`chanid` int(10) unsigned default NULL,
`starttime` datetime default NULL,
`manualid` int(10) unsigned default NULL,
KEY `recordid` (`recordid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `romdb`
--
CREATE TABLE `romdb` (
`crc` varchar(64) NOT NULL default '',
`name` varchar(128) NOT NULL default '',
`description` varchar(128) NOT NULL default '',
`category` varchar(128) NOT NULL default '',
`year` varchar(10) NOT NULL default '',
`manufacturer` varchar(128) NOT NULL default '',
`country` varchar(128) NOT NULL default '',
`publisher` varchar(128) NOT NULL default '',
`platform` varchar(64) NOT NULL default '',
`filesize` int(12) default NULL,
`flags` varchar(64) NOT NULL default '',
`version` varchar(64) NOT NULL default '',
`binfile` varchar(64) NOT NULL default '',
KEY `crc` (`crc`),
KEY `year` (`year`),
KEY `category` (`category`),
KEY `name` (`name`),
KEY `description` (`description`),
KEY `platform` (`platform`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `schemalock`
--
CREATE TABLE `schemalock` (
`schemalock` int(1) default NULL
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`value` varchar(128) NOT NULL default '',
`data` text,
`hostname` varchar(255) default NULL,
KEY `value` (`value`,`hostname`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `smartplaylist`
--
CREATE TABLE `smartplaylist` (
`smartplaylistid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
`categoryid` int(10) unsigned NOT NULL default '0',
`matchtype` set('All','Any') NOT NULL default 'All',
`orderby` varchar(128) NOT NULL default '',
`limitto` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`smartplaylistid`),
KEY `name` (`name`),
KEY `categoryid` (`categoryid`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Table structure for table `smartplaylistcategory`
--
CREATE TABLE `smartplaylistcategory` (
`categoryid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
PRIMARY KEY (`categoryid`),
KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `smartplaylistitem`
--
CREATE TABLE `smartplaylistitem` (
`smartplaylistitemid` int(10) unsigned NOT NULL auto_increment,
`smartplaylistid` int(10) unsigned NOT NULL default '0',
`field` varchar(50) NOT NULL default '',
`operator` varchar(20) NOT NULL default '',
`value1` varchar(255) NOT NULL default '',
`value2` varchar(255) NOT NULL default '',
PRIMARY KEY (`smartplaylistitemid`),
KEY `smartplaylistid` (`smartplaylistid`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Table structure for table `tvchain`
--
CREATE TABLE `tvchain` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`chainid` varchar(128) NOT NULL default '',
`chainpos` int(10) NOT NULL default '0',
`discontinuity` tinyint(1) NOT NULL default '0',
`watching` int(10) NOT NULL default '0',
`hostprefix` varchar(128) NOT NULL default '',
`cardtype` varchar(32) NOT NULL default 'V4L',
`input` varchar(32) NOT NULL default '',
`channame` varchar(32) NOT NULL default '',
`endtime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`chanid`,`starttime`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videobookmarks`
--
CREATE TABLE `videobookmarks` (
`filename` varchar(255) NOT NULL default '',
`bookmark` varchar(128) default NULL,
PRIMARY KEY (`filename`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videocategory`
--
CREATE TABLE `videocategory` (
`intid` int(10) unsigned NOT NULL auto_increment,
`category` varchar(128) NOT NULL default '',
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `videocountry`
--
CREATE TABLE `videocountry` (
`intid` int(10) unsigned NOT NULL auto_increment,
`country` varchar(128) NOT NULL default '',
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `videogenre`
--
CREATE TABLE `videogenre` (
`intid` int(10) unsigned NOT NULL auto_increment,
`genre` varchar(128) NOT NULL default '',
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `videometadata`
--
CREATE TABLE `videometadata` (
`intid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(128) NOT NULL default '',
`director` varchar(128) NOT NULL default '',
`plot` text,
`rating` varchar(128) NOT NULL default '',
`inetref` varchar(32) NOT NULL default '',
`year` int(10) unsigned NOT NULL default '0',
`userrating` float NOT NULL default '0',
`length` int(10) unsigned NOT NULL default '0',
`showlevel` int(10) unsigned NOT NULL default '0',
`filename` text NOT NULL,
`coverfile` text NOT NULL,
`childid` int(11) NOT NULL default '-1',
`browse` tinyint(1) NOT NULL default '1',
`playcommand` varchar(255) default NULL,
`category` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`intid`),
KEY `director` (`director`),
KEY `title` (`title`),
KEY `title_2` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `videometadatacountry`
--
CREATE TABLE `videometadatacountry` (
`idvideo` int(10) unsigned NOT NULL default '0',
`idcountry` int(10) unsigned NOT NULL default '0',
KEY `idvideo` (`idvideo`),
KEY `idcountry` (`idcountry`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videometadatagenre`
--
CREATE TABLE `videometadatagenre` (
`idvideo` int(10) unsigned NOT NULL default '0',
`idgenre` int(10) unsigned NOT NULL default '0',
KEY `idvideo` (`idvideo`),
KEY `idgenre` (`idgenre`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `videosource`
--
CREATE TABLE `videosource` (
`sourceid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
`xmltvgrabber` varchar(128) default NULL,
`userid` varchar(128) NOT NULL default '',
`freqtable` varchar(16) NOT NULL default 'default',
`lineupid` varchar(64) default NULL,
`password` varchar(64) default NULL,
`useeit` smallint(6) NOT NULL default '0',
PRIMARY KEY (`sourceid`),
UNIQUE KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `videotypes`
--
CREATE TABLE `videotypes` (
`intid` int(10) unsigned NOT NULL auto_increment,
`extension` varchar(128) NOT NULL default '',
`playcommand` varchar(255) NOT NULL default '',
`f_ignore` tinyint(1) default NULL,
`use_default` tinyint(1) default NULL,
PRIMARY KEY (`intid`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Table structure for table `xvmc_buffer_settings`
--
CREATE TABLE `xvmc_buffer_settings` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(255) NOT NULL default '',
`osd_num` int(11) NOT NULL default '0',
`osd_res_num` int(11) NOT NULL default '0',
`min_surf` int(11) NOT NULL default '0',
`max_surf` int(11) NOT NULL default '0',
`decode_num` int(11) NOT NULL default '0',
`agressive` int(11) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Database: `test`
--
CREATE DATABASE `test`;
USE test;