-- MySQL dump 10.10
--
-- Host: localhost    Database: mythconverg
-- ------------------------------------------------------
-- Server version	5.0.27-Debian_1-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 */;
/*!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 `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`
--

LOCK TABLES `channel` WRITE;
/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
INSERT INTO `channel` VALUES (3006,'31','548250',1,'31-AD','31-Adl','',0,'','31-Adl',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(3001,'2','64250',1,'ABC-S','ABC-SA','',0,'','ABC-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,NULL,0,NULL,0,0,0),(3003,'9','196250',1,'NINE-','Nine-SA','',0,'','Nine-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,NULL,0,NULL,0,0,0),(3005,'28','527250',1,'SBS-S','SBS-SA','',0,'','SBS-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,NULL,0,NULL,0,0,0),(3002,'7','182250',1,'SEVEN','Seven-SA','',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,NULL,0,NULL,0,0,0),(3004,'10','209250',1,'TEN-S','Ten-SA','',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,NULL,0,NULL,0,0,0),(1501,'501','',1,'ABC HDTV','ABC HDTV','none',0,'','ABC-SA',0,32768,32768,32768,32768,'Default',0,1,'',0,12,592,NULL,0,0,0),(1502,'502','',1,'ABC TV Adelaide','ABC TV Adelaide','none',0,'','ABC-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,12,593,NULL,0,0,0),(1503,'503','',1,'ABC2','ABC2','none',0,'','ABC2',0,32768,32768,32768,32768,'Default',0,1,'',0,12,594,NULL,0,0,0),(1504,'504','',1,'ABC TV','ABC TV','none',0,'','ABC-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,12,595,NULL,0,0,0),(1505,'505','',1,'ABC DiG Radio','ABC DiG Radio','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,12,598,NULL,0,0,0),(1506,'506','',1,'ABC DiG Jazz','ABC DiG Jazz','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,12,599,NULL,0,0,0),(1507,'507','',1,'7 Digital','7 Digital','none',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,1,'',0,13,1360,NULL,0,0,0),(1508,'508','',1,'7 Digital 1','7 Digital 1','none',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,13,1361,NULL,0,0,0),(1509,'509','',1,'7 Digital 2','7 Digital 2','none',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,13,1362,NULL,0,0,0),(1510,'510','',1,'7 Digital 3','7 Digital 3','none',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,13,1363,NULL,0,0,0),(1511,'511','',1,'7 HD Digital','7 HD Digital','none',0,'','Seven-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,13,1364,NULL,0,0,0),(1512,'512','',1,'7 Guide','7 Guide','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,13,1366,NULL,0,0,0),(1513,'513','',1,'NINE Digital','NINE Digital','none',0,'','Nine-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,14,1105,NULL,0,0,0),(1514,'514','',1,'NINE HD','NINE HD','none',0,'','Nine-SA',0,32768,32768,32768,32768,'Default',0,1,'',0,14,1112,NULL,0,0,0),(1515,'515','',1,'TEN Digital','TEN Digital','none',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,15,1617,NULL,0,0,0),(1516,'516','',1,'TEN Digital 1','TEN Digital 1','none',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,15,1618,NULL,0,0,0),(1517,'517','',1,'TEN Digital 2','TEN Digital 2','none',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,15,1619,NULL,0,0,0),(1518,'518','',1,'TEN Digital 3','TEN Digital 3','none',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,15,1620,NULL,0,0,0),(1519,'519','',1,'TEN Guide','TEN Guide','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,15,1623,NULL,0,0,0),(1520,'520','',1,'TEN HD','TEN HD','none',0,'','Ten-SA',0,32768,32768,32768,32768,'Default',0,1,'',0,15,1624,NULL,0,0,0),(1521,'521','',1,'SBS HD','SBS HD','none',0,'','SBS-SA',0,32768,32768,32768,32768,'Default',0,1,'',0,16,832,NULL,0,0,0),(1522,'522','',1,'SBS DIGITAL 1','SBS DIGITAL 1','none',0,'','SBS-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,16,833,NULL,0,0,0),(1523,'523','',1,'SBS DIGITAL 2','SBS DIGITAL 2','none',0,'','SBS-SA',0,32768,32768,32768,32768,'Default',0,0,'',0,16,834,NULL,0,0,0),(1524,'524','',1,'SBS EPG','SBS EPG','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,16,835,NULL,0,0,0),(1525,'525','',1,'SBS RADIO 1','SBS RADIO 1','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,16,846,NULL,0,0,0),(1526,'526','',1,'SBS RADIO 2','SBS RADIO 2','none',0,'','',0,32768,32768,32768,32768,'Default',0,0,'',0,16,847,NULL,0,0,0);
/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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 AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

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

LOCK TABLES `dtv_multiplex` WRITE;
/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
INSERT INTO `dtv_multiplex` VALUES (1,1,1285,4115,177500000,'0',NULL,NULL,NULL,'qam_16','7','auto','8','auto',0,'qam_64','n','auto','dvb',22,'2007-03-11 04:13:24'),(2,1,1,12849,191500000,'0',NULL,NULL,NULL,'qam_16','7','auto','8','auto',0,'qam_64','n','auto','dvb',9,'2007-03-11 04:14:17'),(3,1,1541,4116,219500000,'0',NULL,NULL,NULL,'qam_16','7','auto','8','auto',0,'qam_64','n','auto','dvb',5,'2007-03-11 04:14:27'),(4,1,593,4112,226500000,'0',NULL,NULL,NULL,'qam_16','7','auto','8','auto',0,'qam_64','n','auto','dvb',4,'2007-03-11 04:14:29'),(5,1,768,12802,571500000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(6,1,784,12802,536625000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(7,1,800,12802,536625000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(8,1,816,12802,585625000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(9,1,832,12802,564500000,'0',NULL,NULL,NULL,'qam_16','7','auto','8','auto',0,'qam_64','n','auto','dvb',25,'2007-03-11 04:14:41'),(10,1,848,12802,543500000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(11,1,864,12802,536500000,'a',NULL,NULL,NULL,NULL,'7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 04:14:41'),(12,1,NULL,NULL,226500000,'a',0,'auto','v','auto','7','3/4','8','1/16',0,'qam_64','n','3/4','dvb',33,'2007-03-11 05:50:31'),(13,1,NULL,NULL,177500000,'a',0,'auto','v','auto','7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 05:50:31'),(14,1,NULL,NULL,191625000,'a',0,'auto','v','auto','7','1/2','8','1/16',0,'qam_64','n','3/4','dvb',33,'2007-03-11 05:50:31'),(15,1,NULL,NULL,219500000,'a',0,'auto','v','auto','7','1/2','8','1/16',0,'qam_64','n','3/4','dvb',33,'2007-03-11 05:50:31'),(16,1,NULL,NULL,564500000,'a',0,'auto','v','auto','7','2/3','8','1/8',0,'qam_64','n','2/3','dvb',33,'2007-03-11 05:50:31');
/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2007-03-12  1:15:47