-- MySQL dump 10.9
--
-- Host: babe    Database: mythconverg
-- ------------------------------------------------------
-- Server version	4.1.20-log

/*!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 */;
/*!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 `capturecard`
--

DROP TABLE IF EXISTS `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',
  `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',
  `parentid` int(10) NOT NULL default '0',
  `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,
  PRIMARY KEY  (`cardid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `capturecard`
--


/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */;
LOCK TABLES `capturecard` WRITE;
INSERT INTO `capturecard` VALUES (1,'/dev/v4l/video0','/dev/dsp','/dev/v4l/vbi0','V4L','Television',0,'mythbackend',0,1,0,1,0,0,NULL,0,2,0,NULL,0,0,31338,80,NULL,1000,3000,0,0,0,0,0,0,0),(2,'0','','','DVB','Television',NULL,'mythbackend',0,1,0,1,0,1,NULL,0,2,0,NULL,0,0,31338,80,NULL,3000,5500,0,0,0,0,0,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */;

--
-- Table structure for table `dtv_multiplex`
--

DROP TABLE IF EXISTS `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 NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`mplexid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dtv_multiplex`
--


/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
LOCK TABLES `dtv_multiplex` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;

--
-- Table structure for table `channel`
--

DROP TABLE IF EXISTS `channel`;
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 '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,
  `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',
  PRIMARY KEY  (`chanid`),
  KEY `channel_src` (`channum`,`sourceid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `channel`
--


/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
LOCK TABLES `channel` WRITE;
INSERT INTO `channel` VALUES (1050,'5.0','50',1,'KCEC','KCEC','',0,'','10371',0,32768,32768,32768,32768,'Default',0,1,'',1,32767,0,NULL,0,50,0),(1071,'7.1','17',1,'KMGHDT','KMGHDT (KMGH-DT)','',0,'','20293',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,17,0),(1021,'2.1','34',1,'KWGNDT','KWGNDT (KWGN-DT)','',0,'','20370',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,34,0),(1041,'4.1','35',1,'KCNCDT','KCNCDT (KCNC-DT)','',0,'','21297',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,35,0),(1091,'9.1','16',1,'KUSADT','KUSADT (KUSA-DT)','',0,'','21298',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,16,0),(1311,'31.1','32',1,'KDVRDT','KDVRDT (KDVR-DT)','',0,'','21319',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,32,0),(1061,'6.1','18',1,'KRMADT','KRMADT (KRMA-DT)','',0,'','21723',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,18,0),(1531,'53.1','46',1,'KWHDDT','KWHDDT (KWHD-DT)','',0,'','35650',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,46,0),(1123,'12.3','38',1,'KBDIDT3','KBDIDT3 (KBDI-DT3)','',0,'','35816',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1122,'12.2','38',1,'KBDIDT2','KBDIDT2 (KBDI-DT2)','',0,'','35818',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1121,'12.1','38',1,'KBDIDT','KBDIDT (KBDI-DT)','',0,'','35856',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,38,0),(1022,'2.2','34',1,'KWGNDT2','KWGNDT2 (KWGN-DT2)','',0,'','43074',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,34,0),(1092,'9.2','16',1,'KUSADT2','KUSADT2 (KUSA-DT2)','',0,'','46171',0,32768,32768,32768,32768,'atsc',0,1,'',1,32767,0,NULL,0,16,0),(2064,'64','64',2,'AMC','AMC','/root/.mythtv/channels/amc_30.jpg',0,'','10021',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,64,0),(2095,'95','95',2,'BET','Black Entertainment Television','',0,'','10051',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,95,0),(2057,'57','57',2,'CSPAN','Cable Satellite Public Affairs Network','/root/.mythtv/channels/cspan_30.jpg',0,'','10161',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,57,0),(2096,'96','96',2,'CSPAN2','Cable Satellite Public Affairs Network 2','',0,'','10162',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,96,0),(2012,'12','12',2,'KBDI','KBDI','/root/.mythtv/channels/pbs_30.jpg',0,'','10342',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,12,0),(2004,'4','4',2,'KCNC','KCNC','/root/.mythtv/channels/cbs_30.jpg',0,'','10380',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,4,0),(2013,'13','13',2,'KDVR','KDVR','/root/.mythtv/channels/fox_30.jpg',0,'','10422',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,13,0),(2007,'7','7',2,'KMGH','KMGH','/root/.mythtv/channels/abc_30.jpg',0,'','10567',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,7,0),(2006,'6','6',2,'KRMA','KRMA','/root/.mythtv/channels/pbs_30.jpg',0,'','10669',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,6,0),(2003,'3','3',2,'KTVD','KTVD','/root/.mythtv/channels/upn_30.jpg',0,'','10748',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,3,0),(2017,'17','17',2,'KPXC','KPXC','/root/.mythtv/channels/i.jpg',0,'','10771',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,17,0),(2009,'9','9',2,'KUSA','KUSA','/root/.mythtv/channels/nbc_30.jpg',0,'','10780',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,9,0),(2002,'2','2',2,'KWGN','KWGN','/root/.mythtv/channels/wb_30.jpg',0,'','10816',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,2,0),(2053,'53','53',2,'KWHD','KWHD','',0,'','10818',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,53,0),(2048,'48','48',2,'SCIFI','Sci-Fi Channel','',0,'','11097',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,48,0),(2011,'11','11',2,'DSC','The Discovery Channel','/root/.mythtv/channels/discoverychannel_30.jpg',0,'','11150',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,11,0),(2022,'22','22',2,'TLC','The Learning Channel','/root/.mythtv/channels/tlc.jpg',0,'','11158',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,22,0),(2058,'58','58',2,'HALMRK','Hallmark Channel','',0,'','11221',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,58,0),(2049,'49','49',2,'TBS','Turner Broadcasting System','/root/.mythtv/channels/tbs_30.jpg',0,'','11867',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,49,0),(2047,'47','47',2,'FOOD','Food Network','',0,'','12574',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,47,0),(2077,'77','77',2,'SPEED','Speed Channel','',0,'','16011',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,77,0),(2078,'78','78',2,'TVLAND','TV Land','',0,'','16123',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,78,0),(2059,'59','59',2,'FITV','Fit Tv','',0,'','16125',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,59,0),(2065,'65','65',2,'MSNBC','MSNBC','/root/.mythtv/channels/msnbc.jpg',0,'','16300',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,65,0),(2099,'99','99',2,'TVGC','TV Guide Channel','',0,'','16715',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,99,0),(2052,'52','52',2,'WGNSAT','WGN/UVTV Satellite Group','/root/.mythtv/channels/sswgn30x30.jpg',0,'','17098',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,52,0),(2020,'20','20',2,'KDEN','KDEN','',0,'','18082',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,20,0),(2100,'22','22',2,'EDAC022','Educational Access - EDAC022','',0,'','22136',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,22,0),(2008,'8','8',2,'GOAC008','Government Access - GOAC008','',0,'','22221',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,8,0),(2005,'5','5',2,'LOOR005','Local Origination - LOOR005','',0,'','23313',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,5,0),(2054,'54','54',2,'PUAC054','Public Access - PUAC054','',0,'','23529',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,54,0),(2061,'61','61',2,'LEAC061','Leased Access - LEAC061','',0,'','23736',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,61,0),(2051,'51','51',2,'KZCSLP','KZCSLP','',0,'','46256',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,51,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `channel` ENABLE KEYS */;

--
-- Table structure for table `cardinput`
--

DROP TABLE IF EXISTS `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 '',
  `radioservices` tinyint(1) default '1',
  `childcardid` int(10) NOT NULL default '0',
  `dishnet_eit` tinyint(1) NOT NULL default '0',
  `recpriority` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cardinputid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cardinput`
--


/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;
LOCK TABLES `cardinput` WRITE;
INSERT INTO `cardinput` VALUES (1,1,2,'Television','',0,'N','','64',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0),(2,2,1,'DVBInput',NULL,0,'N','','2.1',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;