2758 lines
100 KiB
MySQL
2758 lines
100 KiB
MySQL
|
-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64)
|
||
|
|
--
|
||
|
|
-- Host: localhost Database: mythconverg
|
||
|
|
-- ------------------------------------------------------
|
||
|
|
-- Server version 5.7.30-0ubuntu0.16.04.1
|
||
|
|
|
||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
|
|
/*!40101 SET NAMES utf8 */;
|
||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
|
|
/*!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' */;
|
||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `archiveitems`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `archiveitems`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `archiveitems` (
|
||
|
|
`intid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`type` set('Recording','Video','File') CHARACTER SET latin1 DEFAULT NULL,
|
||
|
|
`title` varchar(128) DEFAULT NULL,
|
||
|
|
`subtitle` varchar(128) DEFAULT NULL,
|
||
|
|
`description` text,
|
||
|
|
`startdate` varchar(30) DEFAULT NULL,
|
||
|
|
`starttime` varchar(30) DEFAULT NULL,
|
||
|
|
`size` bigint(20) unsigned NOT NULL,
|
||
|
|
`filename` text NOT NULL,
|
||
|
|
`hascutlist` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`cutlist` text,
|
||
|
|
`duration` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`cutduration` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`videowidth` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`videoheight` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`filecodec` varchar(50) NOT NULL DEFAULT '',
|
||
|
|
`videocodec` varchar(50) NOT NULL DEFAULT '',
|
||
|
|
`encoderprofile` varchar(50) NOT NULL DEFAULT 'NONE',
|
||
|
|
PRIMARY KEY (`intid`),
|
||
|
|
KEY `title` (`title`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `bdbookmark`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `bdbookmark`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `bdbookmark` (
|
||
|
|
`serialid` varchar(40) NOT NULL DEFAULT '',
|
||
|
|
`name` varchar(128) DEFAULT NULL,
|
||
|
|
`bdstate` varchar(4096) NOT NULL DEFAULT '',
|
||
|
|
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
PRIMARY KEY (`serialid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `callsignnetworkmap`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `callsignnetworkmap`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `capturecard`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `capturecard`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `capturecard` (
|
||
|
|
`cardid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`parentid` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`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(64) DEFAULT NULL,
|
||
|
|
`dvb_swfilter` int(11) DEFAULT '0',
|
||
|
|
`dvb_sat_type` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`dvb_wait_for_seqstart` int(11) NOT NULL DEFAULT '1',
|
||
|
|
`skipbtaudio` tinyint(1) DEFAULT '0',
|
||
|
|
`dvb_on_demand` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
`dvb_diseqc_type` smallint(6) DEFAULT NULL,
|
||
|
|
`firewire_speed` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`firewire_model` varchar(32) DEFAULT NULL,
|
||
|
|
`firewire_connection` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`signal_timeout` int(11) NOT NULL DEFAULT '1000',
|
||
|
|
`channel_timeout` int(11) NOT NULL DEFAULT '3000',
|
||
|
|
`dvb_tuning_delay` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`contrast` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`brightness` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`colour` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`hue` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`diseqcid` int(10) unsigned DEFAULT NULL,
|
||
|
|
`dvb_eitscan` tinyint(1) NOT NULL DEFAULT '1',
|
||
|
|
`inputname` varchar(32) NOT NULL DEFAULT 'None',
|
||
|
|
`sourceid` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`externalcommand` varchar(128) DEFAULT NULL,
|
||
|
|
`changer_device` varchar(128) DEFAULT NULL,
|
||
|
|
`changer_model` varchar(128) DEFAULT NULL,
|
||
|
|
`tunechan` varchar(10) DEFAULT NULL,
|
||
|
|
`startchan` varchar(10) DEFAULT NULL,
|
||
|
|
`displayname` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
`dishnet_eit` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`recpriority` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`quicktune` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
`schedorder` int(10) unsigned NOT NULL DEFAULT '1',
|
||
|
|
`livetvorder` int(10) unsigned NOT NULL DEFAULT '1',
|
||
|
|
PRIMARY KEY (`cardid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `cardinput`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `cardinput`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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,
|
||
|
|
`changer_device` varchar(128) DEFAULT NULL,
|
||
|
|
`changer_model` varchar(128) DEFAULT NULL,
|
||
|
|
`tunechan` varchar(10) DEFAULT NULL,
|
||
|
|
`startchan` varchar(10) DEFAULT NULL,
|
||
|
|
`displayname` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
`dishnet_eit` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`recpriority` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`quicktune` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
`schedorder` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`livetvorder` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`cardinputid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channel`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channel`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channel` (
|
||
|
|
`chanid` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`channum` varchar(10) 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 '',
|
||
|
|
`finetune` int(11) DEFAULT NULL,
|
||
|
|
`videofilters` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`xmltvid` varchar(255) 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',
|
||
|
|
`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,
|
||
|
|
`tmoffset` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`atsc_major_chan` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`atsc_minor_chan` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`last_record` datetime NOT NULL,
|
||
|
|
`default_authority` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
`commmethod` int(11) NOT NULL DEFAULT '-1',
|
||
|
|
`iptvid` smallint(6) unsigned DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`chanid`),
|
||
|
|
KEY `channel_src` (`channum`,`sourceid`),
|
||
|
|
KEY `sourceid` (`sourceid`,`xmltvid`,`chanid`),
|
||
|
|
KEY `visible` (`visible`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channelgroup`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channelgroup`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channelgroup` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`chanid` int(11) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`grpid` int(11) NOT NULL DEFAULT '1',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channelgroupnames`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channelgroupnames`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channelgroupnames` (
|
||
|
|
`grpid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`name` varchar(64) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`grpid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channelscan`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channelscan`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channelscan` (
|
||
|
|
`scanid` int(3) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`cardid` int(3) unsigned NOT NULL,
|
||
|
|
`sourceid` int(3) unsigned NOT NULL,
|
||
|
|
`processed` tinyint(1) unsigned NOT NULL,
|
||
|
|
`scandate` datetime NOT NULL,
|
||
|
|
PRIMARY KEY (`scanid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channelscan_channel`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channelscan_channel`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channelscan_channel` (
|
||
|
|
`transportid` int(6) unsigned NOT NULL,
|
||
|
|
`scanid` int(3) unsigned NOT NULL,
|
||
|
|
`mplex_id` smallint(6) NOT NULL,
|
||
|
|
`source_id` int(3) unsigned NOT NULL,
|
||
|
|
`channel_id` int(3) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`callsign` varchar(20) NOT NULL DEFAULT '',
|
||
|
|
`service_name` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
`chan_num` varchar(10) NOT NULL DEFAULT '',
|
||
|
|
`service_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`atsc_major_channel` int(4) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`atsc_minor_channel` int(4) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`use_on_air_guide` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`hidden` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`hidden_in_guide` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`freqid` varchar(10) NOT NULL DEFAULT '',
|
||
|
|
`icon` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`tvformat` varchar(10) NOT NULL DEFAULT 'Default',
|
||
|
|
`xmltvid` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
`pat_tsid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`vct_tsid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`vct_chan_tsid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`sdt_tsid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`orig_netid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`netid` int(5) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`si_standard` varchar(10) NOT NULL,
|
||
|
|
`in_channels_conf` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`in_pat` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`in_pmt` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`in_vct` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`in_nit` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`in_sdt` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`is_encrypted` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`is_data_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`is_audio_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`is_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`could_be_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`decryption_status` smallint(2) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`default_authority` varchar(32) NOT NULL DEFAULT ''
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `channelscan_dtv_multiplex`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `channelscan_dtv_multiplex`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `channelscan_dtv_multiplex` (
|
||
|
|
`transportid` int(6) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`scanid` int(3) unsigned NOT NULL,
|
||
|
|
`mplexid` smallint(6) unsigned NOT NULL,
|
||
|
|
`frequency` bigint(12) unsigned NOT NULL,
|
||
|
|
`inversion` char(1) NOT NULL DEFAULT 'a',
|
||
|
|
`symbolrate` bigint(12) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`fec` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`polarity` char(1) NOT NULL DEFAULT '',
|
||
|
|
`hp_code_rate` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`mod_sys` varchar(10) DEFAULT NULL,
|
||
|
|
`rolloff` varchar(4) DEFAULT NULL,
|
||
|
|
`lp_code_rate` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`modulation` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`transmission_mode` char(1) NOT NULL DEFAULT 'a',
|
||
|
|
`guard_interval` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`hierarchy` varchar(10) NOT NULL DEFAULT 'auto',
|
||
|
|
`bandwidth` char(1) NOT NULL DEFAULT 'a',
|
||
|
|
`sistandard` varchar(10) NOT NULL,
|
||
|
|
`tuner_type` smallint(2) unsigned NOT NULL,
|
||
|
|
`default_authority` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`transportid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `codecparams`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `codecparams`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `credits`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `credits`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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') CHARACTER SET latin1 NOT NULL DEFAULT '',
|
||
|
|
UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),
|
||
|
|
KEY `person` (`person`,`role`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `customexample`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `customexample`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `customexample` (
|
||
|
|
`rulename` varchar(64) NOT NULL,
|
||
|
|
`fromclause` varchar(10000) NOT NULL DEFAULT '',
|
||
|
|
`whereclause` varchar(10000) NOT NULL DEFAULT '',
|
||
|
|
`search` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`rulename`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `diseqc_config`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `diseqc_config`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `diseqc_config` (
|
||
|
|
`cardinputid` int(10) unsigned NOT NULL,
|
||
|
|
`diseqcid` int(10) unsigned NOT NULL,
|
||
|
|
`value` varchar(16) NOT NULL DEFAULT '',
|
||
|
|
KEY `id` (`cardinputid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `diseqc_tree`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `diseqc_tree`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `diseqc_tree` (
|
||
|
|
`diseqcid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`parentid` int(10) unsigned DEFAULT NULL,
|
||
|
|
`ordinal` tinyint(3) unsigned NOT NULL,
|
||
|
|
`type` varchar(16) NOT NULL DEFAULT '',
|
||
|
|
`subtype` varchar(16) NOT NULL DEFAULT '',
|
||
|
|
`description` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
`switch_ports` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`rotor_hi_speed` float NOT NULL DEFAULT '0',
|
||
|
|
`rotor_lo_speed` float NOT NULL DEFAULT '0',
|
||
|
|
`rotor_positions` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`lnb_lof_switch` int(10) NOT NULL DEFAULT '0',
|
||
|
|
`lnb_lof_hi` int(10) NOT NULL DEFAULT '0',
|
||
|
|
`lnb_lof_lo` int(10) NOT NULL DEFAULT '0',
|
||
|
|
`cmd_repeat` int(11) NOT NULL DEFAULT '1',
|
||
|
|
`lnb_pol_inv` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
`address` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`scr_userband` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`scr_frequency` int(10) unsigned NOT NULL DEFAULT '1400',
|
||
|
|
`scr_pin` int(11) NOT NULL DEFAULT '-1',
|
||
|
|
PRIMARY KEY (`diseqcid`),
|
||
|
|
KEY `parentid` (`parentid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `displayprofilegroups`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `displayprofilegroups`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `displayprofilegroups` (
|
||
|
|
`name` varchar(128) NOT NULL,
|
||
|
|
`hostname` varchar(64) NOT NULL,
|
||
|
|
`profilegroupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
PRIMARY KEY (`name`,`hostname`),
|
||
|
|
UNIQUE KEY `profilegroupid` (`profilegroupid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `displayprofiles`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `displayprofiles`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `displayprofiles` (
|
||
|
|
`profilegroupid` int(10) unsigned NOT NULL,
|
||
|
|
`profileid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`value` varchar(128) NOT NULL,
|
||
|
|
`data` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
KEY `profilegroupid` (`profilegroupid`),
|
||
|
|
KEY `profileid` (`profileid`,`value`),
|
||
|
|
KEY `profileid_2` (`profileid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `dtv_multiplex`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dtv_multiplex`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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',
|
||
|
|
`mod_sys` varchar(10) DEFAULT NULL,
|
||
|
|
`rolloff` varchar(4) DEFAULT NULL,
|
||
|
|
`sistandard` varchar(10) DEFAULT 'dvb',
|
||
|
|
`serviceversion` smallint(6) DEFAULT '33',
|
||
|
|
`updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
`default_authority` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`mplexid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `dtv_privatetypes`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dtv_privatetypes`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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 ''
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `dvdbookmark`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dvdbookmark`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `dvdbookmark` (
|
||
|
|
`serialid` varchar(16) NOT NULL DEFAULT '',
|
||
|
|
`name` varchar(32) DEFAULT NULL,
|
||
|
|
`title` smallint(6) NOT NULL DEFAULT '0',
|
||
|
|
`audionum` tinyint(4) NOT NULL DEFAULT '-1',
|
||
|
|
`subtitlenum` tinyint(4) NOT NULL DEFAULT '-1',
|
||
|
|
`framenum` bigint(20) NOT NULL DEFAULT '0',
|
||
|
|
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
`dvdstate` varchar(1024) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`serialid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `dvdinput`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dvdinput`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `dvdinput` (
|
||
|
|
`intid` int(10) unsigned NOT NULL,
|
||
|
|
`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`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `dvdtranscode`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dvdtranscode`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `dvdtranscode` (
|
||
|
|
`intid` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`input` int(10) unsigned DEFAULT NULL,
|
||
|
|
`name` varchar(128) NOT NULL,
|
||
|
|
`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,
|
||
|
|
`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,
|
||
|
|
`tc_param` varchar(128) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`intid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `eit_cache`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `eit_cache`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `eit_cache` (
|
||
|
|
`chanid` int(10) NOT NULL,
|
||
|
|
`eventid` int(10) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`tableid` tinyint(3) unsigned NOT NULL,
|
||
|
|
`version` tinyint(3) unsigned NOT NULL,
|
||
|
|
`endtime` int(10) unsigned NOT NULL,
|
||
|
|
`status` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`chanid`,`eventid`,`status`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `filemarkup`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `filemarkup`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `filemarkup` (
|
||
|
|
`filename` text NOT NULL,
|
||
|
|
`mark` mediumint(8) unsigned NOT NULL DEFAULT '0',
|
||
|
|
`offset` bigint(20) unsigned DEFAULT NULL,
|
||
|
|
`type` tinyint(4) NOT NULL DEFAULT '0',
|
||
|
|
KEY `filename` (`filename`(255))
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `gallery_directories`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `gallery_directories`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `gallery_directories` (
|
||
|
|
`dir_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`filename` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`path` varchar(255) NOT NULL,
|
||
|
|
`parent_id` int(11) NOT NULL,
|
||
|
|
`dir_count` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`file_count` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`hidden` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`dir_id`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `gallery_files`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `gallery_files`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `gallery_files` (
|
||
|
|
`file_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`filename` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`path` varchar(255) NOT NULL,
|
||
|
|
`dir_id` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`type` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`modtime` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`size` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`extension` varchar(255) NOT NULL,
|
||
|
|
`angle` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`date` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`zoom` int(11) NOT NULL DEFAULT '0',
|
||
|
|
`hidden` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
`orientation` int(11) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`file_id`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `gallerymetadata`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `gallerymetadata`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `gallerymetadata` (
|
||
|
|
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`angle` int(11) NOT NULL,
|
||
|
|
PRIMARY KEY (`image`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `gamemetadata`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `gamemetadata`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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 '',
|
||
|
|
`screenshot` varchar(255) NOT NULL,
|
||
|
|
`fanart` varchar(255) NOT NULL,
|
||
|
|
`plot` text NOT NULL,
|
||
|
|
`boxart` varchar(255) NOT NULL,
|
||
|
|
`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`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `gameplayers`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `gameplayers`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `housekeeping`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `housekeeping`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `housekeeping` (
|
||
|
|
`tag` varchar(64) NOT NULL,
|
||
|
|
`hostname` varchar(64) DEFAULT NULL,
|
||
|
|
`lastrun` datetime DEFAULT NULL,
|
||
|
|
`lastsuccess` datetime DEFAULT NULL,
|
||
|
|
UNIQUE KEY `task` (`tag`,`hostname`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `inputgroup`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `inputgroup`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `inputgroup` (
|
||
|
|
`cardinputid` int(10) unsigned NOT NULL,
|
||
|
|
`inputgroupid` int(10) unsigned NOT NULL,
|
||
|
|
`inputgroupname` varchar(128) DEFAULT NULL
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `internetcontent`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `internetcontent`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `internetcontent` (
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`thumbnail` varchar(255) DEFAULT NULL,
|
||
|
|
`type` smallint(3) NOT NULL,
|
||
|
|
`author` varchar(128) NOT NULL,
|
||
|
|
`description` text NOT NULL,
|
||
|
|
`commandline` text NOT NULL,
|
||
|
|
`version` double NOT NULL,
|
||
|
|
`updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
||
|
|
`search` tinyint(1) NOT NULL,
|
||
|
|
`tree` tinyint(1) NOT NULL,
|
||
|
|
`podcast` tinyint(1) NOT NULL,
|
||
|
|
`download` tinyint(1) NOT NULL,
|
||
|
|
`host` varchar(128) DEFAULT NULL
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `internetcontentarticles`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `internetcontentarticles`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `internetcontentarticles` (
|
||
|
|
`feedtitle` varchar(255) NOT NULL,
|
||
|
|
`path` text NOT NULL,
|
||
|
|
`paththumb` text NOT NULL,
|
||
|
|
`title` varchar(255) NOT NULL,
|
||
|
|
`subtitle` varchar(255) NOT NULL,
|
||
|
|
`season` smallint(5) NOT NULL DEFAULT '0',
|
||
|
|
`episode` smallint(5) NOT NULL DEFAULT '0',
|
||
|
|
`description` text NOT NULL,
|
||
|
|
`url` text NOT NULL,
|
||
|
|
`type` smallint(3) NOT NULL,
|
||
|
|
`thumbnail` text NOT NULL,
|
||
|
|
`mediaURL` text NOT NULL,
|
||
|
|
`author` varchar(255) NOT NULL,
|
||
|
|
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
||
|
|
`time` int(11) NOT NULL,
|
||
|
|
`rating` varchar(255) NOT NULL,
|
||
|
|
`filesize` bigint(20) NOT NULL,
|
||
|
|
`player` varchar(255) NOT NULL,
|
||
|
|
`playerargs` text NOT NULL,
|
||
|
|
`download` varchar(255) NOT NULL,
|
||
|
|
`downloadargs` text NOT NULL,
|
||
|
|
`width` smallint(6) NOT NULL,
|
||
|
|
`height` smallint(6) NOT NULL,
|
||
|
|
`language` varchar(128) NOT NULL,
|
||
|
|
`podcast` tinyint(1) NOT NULL,
|
||
|
|
`downloadable` tinyint(1) NOT NULL,
|
||
|
|
`customhtml` tinyint(1) NOT NULL,
|
||
|
|
`countries` varchar(255) NOT NULL
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `inuseprograms`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `inuseprograms`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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(64) NOT NULL DEFAULT '',
|
||
|
|
`rechost` varchar(64) NOT NULL,
|
||
|
|
`recdir` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
KEY `chanid` (`chanid`,`starttime`),
|
||
|
|
KEY `recusage` (`recusage`,`lastupdatetime`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `iptv_channel`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `iptv_channel`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `iptv_channel` (
|
||
|
|
`iptvid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`chanid` int(10) unsigned NOT NULL,
|
||
|
|
`url` text NOT NULL,
|
||
|
|
`type` set('data','rfc2733-1','rfc2733-2','rfc5109-1','rfc5109-2','smpte2022-1','smpte2022-2') DEFAULT NULL,
|
||
|
|
`bitrate` int(10) unsigned NOT NULL,
|
||
|
|
PRIMARY KEY (`iptvid`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `jobqueue`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `jobqueue`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
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 NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
`hostname` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
`args` blob NOT NULL,
|
||
|
|
`comment` varchar(128) NOT NULL DEFAULT '',
|
||
|
|
`schedruntime` datetime NOT NULL DEFAULT '2007-01-01 00:00:00',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=60450 DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `jumppoints`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `jumppoints`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `jumppoints` (
|
||
|
|
`destination` varchar(128) NOT NULL DEFAULT '',
|
||
|
|
`description` varchar(255) DEFAULT NULL,
|
||
|
|
`keylist` varchar(128) DEFAULT NULL,
|
||
|
|
`hostname` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`destination`,`hostname`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `keybindings`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `keybindings`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `keybindings` (
|
||
|
|
`context` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
`action` varchar(32) NOT NULL DEFAULT '',
|
||
|
|
`description` varchar(255) DEFAULT NULL,
|
||
|
|
`keylist` varchar(128) DEFAULT NULL,
|
||
|
|
`hostname` varchar(64) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`context`,`action`,`hostname`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `keyword`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `keyword`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `keyword` (
|
||
|
|
`phrase` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`searchtype` int(10) unsigned NOT NULL DEFAULT '3',
|
||
|
|
UNIQUE KEY `phrase` (`phrase`,`searchtype`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `livestream`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `livestream`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!40101 SET character_set_client = utf8 */;
|
||
|
|
CREATE TABLE `livestream` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`width` int(10) unsigned NOT NULL,
|
||
|
|