Ticket #8983: post-scan.sql

File post-scan.sql, 40.6 KB (added by Richard <mythtv@…>, 14 years ago)

channelscan, channelscan_channel and channelscan_dtv_multiplex tables after the scan

Line 
1-- MySQL dump 10.13  Distrib 5.1.36, for suse-linux-gnu (x86_64)
2--
3-- Host: localhost    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       5.1.36-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `channel`
20--
21
22DROP TABLE IF EXISTS `channel`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `channel` (
26  `chanid` int(10) unsigned NOT NULL DEFAULT '0',
27  `channum` varchar(10) NOT NULL DEFAULT '',
28  `freqid` varchar(10) DEFAULT NULL,
29  `sourceid` int(10) unsigned DEFAULT NULL,
30  `callsign` varchar(20) NOT NULL DEFAULT '',
31  `name` varchar(64) NOT NULL DEFAULT '',
32  `icon` varchar(255) NOT NULL DEFAULT 'none',
33  `finetune` int(11) DEFAULT NULL,
34  `videofilters` varchar(255) NOT NULL DEFAULT '',
35  `xmltvid` varchar(64) NOT NULL DEFAULT '',
36  `recpriority` int(10) NOT NULL DEFAULT '0',
37  `contrast` int(11) DEFAULT '32768',
38  `brightness` int(11) DEFAULT '32768',
39  `colour` int(11) DEFAULT '32768',
40  `hue` int(11) DEFAULT '32768',
41  `tvformat` varchar(10) NOT NULL DEFAULT 'Default',
42  `visible` tinyint(1) NOT NULL DEFAULT '1',
43  `outputfilters` varchar(255) NOT NULL DEFAULT '',
44  `useonairguide` tinyint(1) DEFAULT '0',
45  `mplexid` smallint(6) DEFAULT NULL,
46  `serviceid` mediumint(8) unsigned DEFAULT NULL,
47  `tmoffset` int(11) NOT NULL DEFAULT '0',
48  `atsc_major_chan` int(10) unsigned NOT NULL DEFAULT '0',
49  `atsc_minor_chan` int(10) unsigned NOT NULL DEFAULT '0',
50  `last_record` datetime NOT NULL,
51  `default_authority` varchar(32) NOT NULL DEFAULT '',
52  `commmethod` int(11) NOT NULL DEFAULT '-1',
53  PRIMARY KEY (`chanid`),
54  KEY `channel_src` (`channum`,`sourceid`),
55  KEY `sourceid` (`sourceid`,`xmltvid`,`chanid`),
56  KEY `visible` (`visible`)
57) ENGINE=MyISAM DEFAULT CHARSET=utf8;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `channel`
62--
63
64LOCK TABLES `channel` WRITE;
65/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
66INSERT INTO `channel` VALUES (1012,'12','11',1,'ONE Digital','ONE Digital','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,4,1592,0,0,0,'0000-00-00 00:00:00','crid://melbourne.one.ten.au',-1),(1024,'24','12',1,'ABC News 24','ABC News 24','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,2,560,0,0,0,'0000-00-00 00:00:00','CRID://melbourneabcnews24.abc.ne',-1),(1002,'2','12',1,'ABC1','ABC1','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,2,561,0,0,0,'0000-00-00 00:00:00','CRID://melbourne2.abc.net.au',-1),(1022,'22','12',1,'ABC2','ABC2','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,2,562,0,0,0,'0000-00-00 00:00:00','CRID://melbourne22.abc.net.au',-1),(1021,'21','12',1,'ABC1','ABC1','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,2,563,0,0,0,'0000-00-00 00:00:00','CRID://melbourne21.abc.net.au',-1),(1023,'23','12',1,'ABC3','ABC3','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,2,564,0,0,0,'0000-00-00 00:00:00','CRID://melbourne23.abc.net.au',-1),(1003,'3','29',1,'SBS ONE','SBS ONE','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,6,785,0,0,0,'0000-00-00 00:00:00','',-1),(1032,'32','29',1,'SBS TWO','SBS TWO','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,6,786,0,0,0,'0000-00-00 00:00:00','',-1),(1033,'33','29',1,'SBS 3','SBS 3','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,6,787,0,0,0,'0000-00-00 00:00:00','',-1),(1034,'34','29',1,'SBS 4','SBS 4','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,6,788,0,0,0,'0000-00-00 00:00:00','',-1),(1030,'30','29',1,'SBS HD','SBS HD','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,6,789,0,0,0,'0000-00-00 00:00:00','',-1),(1044,'44','32',1,'C31','C31','',NULL,'','',0,32768,32768,32768,32768,'',1,'',0,25,3585,0,0,0,'0000-00-00 00:00:00','',-1),(1040,'40','35',1,'3D Trial','3D Trial','',NULL,'','',0,32768,32768,32768,32768,'',1,'',0,26,13107,0,0,0,'0000-00-00 00:00:00','',-1),(1011,'11','11',1,'ONE HD','ONE HD','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,4,1591,0,0,0,'0000-00-00 00:00:00','crid://melbourne.onehd11.ten.au',-1),(1001,'1','11',1,'ONE HD','ONE HD','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,4,1585,0,0,0,'0000-00-00 00:00:00','crid://melbourne.onehd.ten.au',-1),(1010,'10','11',1,'TEN Digital','TEN Digital','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,4,1589,0,0,0,'0000-00-00 00:00:00','crid://melbourne.ten.au',-1),(1099,'99','7',1,'GO!','GO!','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,3,1074,0,0,0,'0000-00-00 00:00:00','',-1),(1090,'90','7',1,'Nine Digital HD','Nine Digital HD','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,3,1073,0,0,0,'0000-00-00 00:00:00','',-1),(1071,'71','5',1,'7 Digital 1','7 Digital 1','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,17,1329,0,0,0,'0000-00-00 00:00:00','',-1),(1072,'72','5',1,'7TWO','7TWO','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,17,1330,0,0,0,'0000-00-00 00:00:00','',-1),(1073,'73','5',1,'7mate','7mate','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,17,1331,0,0,0,'0000-00-00 00:00:00','',-1),(1070,'70','5',1,'7 HD Digital','7 HD Digital','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,17,1332,0,0,0,'0000-00-00 00:00:00','',-1),(1009,'9','7',1,'Nine Digital','Nine Digital','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,3,1072,0,0,0,'0000-00-00 00:00:00','',-1),(1007,'7','5',1,'7 Digital','7 Digital','',NULL,'','',0,32768,32768,32768,32768,'',1,'',1,17,1328,0,0,0,'0000-00-00 00:00:00','',-1);
67/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `dtv_multiplex`
72--
73
74DROP TABLE IF EXISTS `dtv_multiplex`;
75/*!40101 SET @saved_cs_client     = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `dtv_multiplex` (
78  `mplexid` smallint(6) NOT NULL AUTO_INCREMENT,
79  `sourceid` smallint(6) DEFAULT NULL,
80  `transportid` int(11) DEFAULT NULL,
81  `networkid` int(11) DEFAULT NULL,
82  `frequency` int(11) DEFAULT NULL,
83  `inversion` char(1) DEFAULT 'a',
84  `symbolrate` int(11) DEFAULT NULL,
85  `fec` varchar(10) DEFAULT 'auto',
86  `polarity` char(1) DEFAULT NULL,
87  `modulation` varchar(10) DEFAULT 'auto',
88  `bandwidth` char(1) DEFAULT 'a',
89  `lp_code_rate` varchar(10) DEFAULT 'auto',
90  `transmission_mode` char(1) DEFAULT 'a',
91  `guard_interval` varchar(10) DEFAULT 'auto',
92  `visible` smallint(1) NOT NULL DEFAULT '0',
93  `constellation` varchar(10) DEFAULT 'auto',
94  `hierarchy` varchar(10) DEFAULT 'auto',
95  `hp_code_rate` varchar(10) DEFAULT 'auto',
96  `mod_sys` varchar(10) DEFAULT NULL,
97  `rolloff` varchar(4) DEFAULT NULL,
98  `sistandard` varchar(10) DEFAULT 'dvb',
99  `serviceversion` smallint(6) DEFAULT '33',
100  `updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
101  `default_authority` varchar(32) NOT NULL DEFAULT '',
102  PRIMARY KEY (`mplexid`)
103) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `dtv_multiplex`
108--
109
110LOCK TABLES `dtv_multiplex` WRITE;
111/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;
112INSERT INTO `dtv_multiplex` VALUES (2,1,NULL,NULL,226500000,'a',0,'auto','v','auto','7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'mpeg',33,'2007-01-21 11:54:23',''),(3,1,NULL,NULL,191625000,'a',0,'auto','v','auto','7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'mpeg',33,'2007-01-21 11:54:23',''),(4,1,NULL,NULL,219500000,'a',0,'auto','v','auto','7','1/2','8','1/16',0,'qam_64','n','3/4','1',NULL,'mpeg',33,'2007-01-21 11:54:23',''),(6,1,NULL,NULL,536500000,'a',0,'auto','v','auto','7','2/3','8','1/8',0,'qam_64','n','2/3','1',NULL,'mpeg',33,'2007-01-21 11:54:23',''),(17,1,NULL,NULL,177500000,'a',0,'auto','v','auto','7','2/3','8','1/16',0,'qam_64','n','2/3','1',NULL,'mpeg',33,'2007-01-21 11:54:23',''),(25,1,3584,12832,557500000,'0',0,'auto','v','auto','7','auto','8','auto',0,'auto','n','auto','UNDEFINED','0.35','dvb',33,'2010-09-22 21:40:53',''),(26,1,13104,8228,578500000,'0',0,'auto','v','auto','7','auto','8','auto',0,'auto','n','auto','UNDEFINED','0.35','dvb',33,'2010-09-22 21:40:53','');
113/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;
114UNLOCK TABLES;
115
116--
117-- Table structure for table `channelscan`
118--
119
120DROP TABLE IF EXISTS `channelscan`;
121/*!40101 SET @saved_cs_client     = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `channelscan` (
124  `scanid` int(3) unsigned NOT NULL AUTO_INCREMENT,
125  `cardid` int(3) unsigned NOT NULL,
126  `sourceid` int(3) unsigned NOT NULL,
127  `processed` tinyint(1) unsigned NOT NULL,
128  `scandate` datetime NOT NULL,
129  PRIMARY KEY (`scanid`)
130) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Dumping data for table `channelscan`
135--
136
137LOCK TABLES `channelscan` WRITE;
138/*!40000 ALTER TABLE `channelscan` DISABLE KEYS */;
139INSERT INTO `channelscan` VALUES (1,21,1,1,'2009-10-09 19:13:02'),(2,21,1,1,'2009-10-09 19:27:05'),(9,22,1,1,'2010-09-23 07:40:37'),(7,23,1,1,'2009-11-02 22:13:59'),(6,23,1,1,'2009-11-02 22:00:07');
140/*!40000 ALTER TABLE `channelscan` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `channelscan_channel`
145--
146
147DROP TABLE IF EXISTS `channelscan_channel`;
148/*!40101 SET @saved_cs_client     = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `channelscan_channel` (
151  `transportid` int(6) unsigned NOT NULL,
152  `scanid` int(3) unsigned NOT NULL,
153  `mplex_id` smallint(6) NOT NULL,
154  `source_id` int(3) unsigned NOT NULL,
155  `channel_id` int(3) unsigned NOT NULL DEFAULT '0',
156  `callsign` varchar(20) NOT NULL DEFAULT '',
157  `service_name` varchar(64) NOT NULL DEFAULT '',
158  `chan_num` varchar(10) NOT NULL DEFAULT '',
159  `service_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
160  `atsc_major_channel` int(4) unsigned NOT NULL DEFAULT '0',
161  `atsc_minor_channel` int(4) unsigned NOT NULL DEFAULT '0',
162  `use_on_air_guide` tinyint(1) NOT NULL DEFAULT '0',
163  `hidden` tinyint(1) NOT NULL DEFAULT '0',
164  `hidden_in_guide` tinyint(1) NOT NULL DEFAULT '0',
165  `freqid` varchar(10) NOT NULL DEFAULT '',
166  `icon` varchar(255) NOT NULL DEFAULT '',
167  `tvformat` varchar(10) NOT NULL DEFAULT 'Default',
168  `xmltvid` varchar(64) NOT NULL DEFAULT '',
169  `pat_tsid` int(5) unsigned NOT NULL DEFAULT '0',
170  `vct_tsid` int(5) unsigned NOT NULL DEFAULT '0',
171  `vct_chan_tsid` int(5) unsigned NOT NULL DEFAULT '0',
172  `sdt_tsid` int(5) unsigned NOT NULL DEFAULT '0',
173  `orig_netid` int(5) unsigned NOT NULL DEFAULT '0',
174  `netid` int(5) unsigned NOT NULL DEFAULT '0',
175  `si_standard` varchar(10) NOT NULL,
176  `in_channels_conf` tinyint(1) unsigned NOT NULL DEFAULT '0',
177  `in_pat` tinyint(1) unsigned NOT NULL DEFAULT '0',
178  `in_pmt` tinyint(1) unsigned NOT NULL DEFAULT '0',
179  `in_vct` tinyint(1) unsigned NOT NULL DEFAULT '0',
180  `in_nit` tinyint(1) unsigned NOT NULL DEFAULT '0',
181  `in_sdt` tinyint(1) unsigned NOT NULL DEFAULT '0',
182  `is_encrypted` tinyint(1) unsigned NOT NULL DEFAULT '0',
183  `is_data_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
184  `is_audio_service` tinyint(1) unsigned NOT NULL DEFAULT '0',
185  `is_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
186  `could_be_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0',
187  `decryption_status` smallint(2) unsigned NOT NULL DEFAULT '0',
188  `default_authority` varchar(32) NOT NULL DEFAULT ''
189) ENGINE=MyISAM DEFAULT CHARSET=utf8;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `channelscan_channel`
194--
195
196LOCK TABLES `channelscan_channel` WRITE;
197/*!40000 ALTER TABLE `channelscan_channel` DISABLE KEYS */;
198INSERT INTO `channelscan_channel` VALUES (1,1,17,1,0,'7 Digital','7 Digital','7',1328,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(1,1,17,1,0,'7 Digital 1','7 Digital 1','71',1329,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(1,1,17,1,0,'7 Digital 2','7 Digital 2','72',1330,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(1,1,17,1,0,'7 Digital 3','7 Digital 3','73',1331,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(1,1,17,1,0,'7 HD Digital','7 HD Digital','70',1332,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(2,1,3,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(2,1,3,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(2,1,3,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(3,1,4,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(3,1,4,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(3,1,4,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(3,1,4,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC HDTV','ABC HDTV','20',560,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(4,1,2,1,0,'ABC DiG Radio','ABC DiG Radio','200',566,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(4,1,2,1,0,'ABC DiG Jazz','ABC DiG Jazz','201',567,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(5,1,6,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(5,1,6,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(5,1,6,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(5,1,6,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(5,1,6,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(5,1,6,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(5,1,6,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(6,2,17,1,0,'7 Digital','7 Digital','',1328,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,0,'dvb',0,1,1,0,0,1,0,0,0,0,0,0,''),(6,2,17,1,0,'7 Digital 1','7 Digital 1','',1329,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,0,'dvb',0,1,1,0,0,1,0,0,0,0,0,0,''),(6,2,17,1,0,'7 Digital 2','7 Digital 2','',1330,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,0,'dvb',0,1,1,0,0,1,0,0,0,0,0,0,''),(6,2,17,1,0,'7 Digital 3','7 Digital 3','',1331,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,0,'dvb',0,1,1,0,0,1,0,0,0,0,0,0,''),(6,2,17,1,0,'7 HD Digital','7 HD Digital','',1332,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,0,'dvb',0,1,1,0,0,1,0,0,0,0,0,0,''),(7,2,3,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(7,2,3,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(7,2,3,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(8,2,4,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(8,2,4,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(8,2,4,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(8,2,4,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC HDTV','ABC HDTV','20',560,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(9,2,2,1,0,'ABC DiG Radio','ABC DiG Radio','200',566,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(9,2,2,1,0,'ABC DiG Jazz','ABC DiG Jazz','201',567,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(10,2,6,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(10,2,6,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(10,2,6,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(10,2,6,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(10,2,6,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(10,2,6,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(10,2,6,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(39,6,18,1,0,'7 HD Digital','7 HD Digital','70',1332,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(39,6,18,1,0,'7 Digital 3','7 Digital 3','73',1331,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(39,6,18,1,0,'7TWO','7TWO','72',1330,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(39,6,18,1,0,'7 Digital 1','7 Digital 1','71',1329,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(39,6,18,1,0,'7 Digital','7 Digital','7',1328,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(38,6,17,1,0,'7 HD Digital','7 HD Digital','70',1332,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(38,6,17,1,0,'7 Digital 3','7 Digital 3','73',1331,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(38,6,17,1,0,'7TWO','7TWO','72',1330,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(38,6,17,1,0,'7 Digital 1','7 Digital 1','71',1329,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(38,6,17,1,0,'7 Digital','7 Digital','7',1328,0,0,1,0,0,'','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(37,6,16,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(37,6,16,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(37,6,16,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(37,6,16,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(37,6,16,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(37,6,16,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(37,6,16,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(36,6,12,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(36,6,12,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(36,6,12,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(36,6,12,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(36,6,12,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(36,6,12,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(36,6,12,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(35,6,11,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(35,6,11,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(35,6,11,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(35,6,11,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(35,6,11,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(35,6,11,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(35,6,11,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(34,6,9,1,0,'ABC DiG Jazz','ABC DiG Jazz','201',567,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(34,6,9,1,0,'ABC DiG Radio','ABC DiG Radio','200',566,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(34,6,9,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(34,6,9,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(34,6,9,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(34,6,9,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(34,6,9,1,0,'ABC HDTV','ABC HDTV','20',560,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(33,6,8,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(33,6,8,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(33,6,8,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(33,6,8,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(32,6,7,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(32,6,7,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(32,6,7,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(31,6,6,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(31,6,6,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(31,6,6,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(31,6,6,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(31,6,6,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(31,6,6,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(31,6,6,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(30,6,5,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(30,6,5,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(30,6,5,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(30,6,5,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(30,6,5,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(30,6,5,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(30,6,5,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(29,6,4,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(29,6,4,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(29,6,4,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(29,6,4,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(28,6,3,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(28,6,3,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(28,6,3,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(27,6,2,1,0,'ABC DiG Jazz','ABC DiG Jazz','201',567,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(27,6,2,1,0,'ABC DiG Radio','ABC DiG Radio','200',566,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(27,6,2,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(27,6,2,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(27,6,2,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(27,6,2,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(27,6,2,1,0,'ABC HDTV','ABC HDTV','20',560,0,0,1,0,0,'','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(40,6,24,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(40,6,24,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(40,6,24,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(41,7,17,1,0,'7 Digital','7 Digital','7',1328,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(41,7,17,1,0,'7 Digital 1','7 Digital 1','71',1329,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(41,7,17,1,0,'7TWO','7TWO','72',1330,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(41,7,17,1,0,'7 Digital 3','7 Digital 3','73',1331,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(41,7,17,1,0,'7 HD Digital','7 HD Digital','70',1332,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(42,7,3,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(42,7,3,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(42,7,3,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(43,7,4,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(43,7,4,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(43,7,4,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(43,7,4,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC HDTV','ABC HDTV','20',560,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(44,7,2,1,0,'ABC DiG Radio','ABC DiG Radio','200',566,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(44,7,2,1,0,'ABC DiG Jazz','ABC DiG Jazz','201',567,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(45,7,6,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(45,7,6,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(45,7,6,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(45,7,6,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(45,7,6,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(45,7,6,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(45,7,6,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(55,9,2,1,0,'ABC Dig Music','ABC Dig Music','200',566,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(55,9,2,1,0,'ABC3','ABC3','23',564,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'CRID://melbourne23.abc.net.au'),(55,9,2,1,0,'ABC1','ABC1','21',563,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'CRID://melbourne21.abc.net.au'),(55,9,2,1,0,'ABC2','ABC2','22',562,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'CRID://melbourne22.abc.net.au'),(55,9,2,1,0,'ABC1','ABC1','2',561,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'CRID://melbourne2.abc.net.au'),(55,9,2,1,0,'ABC News 24','ABC News 24','24',560,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'CRID://melbourneabcnews24.abc.ne'),(54,9,4,1,0,'ONE Digital','ONE Digital','12',1592,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'crid://melbourne.one.ten.au'),(54,9,4,1,0,'ONE HD','ONE HD','11',1591,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'crid://melbourne.onehd11.ten.au'),(54,9,4,1,0,'TEN Digital','TEN Digital','10',1589,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'crid://melbourne.ten.au'),(54,9,4,1,0,'ONE HD','ONE HD','1',1585,0,0,1,0,0,'11','','','',1539,0,0,1539,4116,12831,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'crid://melbourne.onehd.ten.au'),(53,9,3,1,0,'GO!','GO!','99',1074,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(53,9,3,1,0,'Nine Digital HD','Nine Digital HD','90',1073,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(53,9,3,1,0,'Nine Digital','Nine Digital','9',1072,0,0,1,0,0,'7','','','',1072,0,0,1072,4114,12829,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(52,9,17,1,0,'7 HD Digital','7 HD Digital','70',1332,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(52,9,17,1,0,'7mate','7mate','73',1331,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(52,9,17,1,0,'7TWO','7TWO','72',1330,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(52,9,17,1,0,'7 Digital 1','7 Digital 1','71',1329,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(52,9,17,1,0,'7 Digital','7 Digital','7',1328,0,0,1,0,0,'5','','','',1283,0,0,1283,4115,12830,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(55,9,2,1,0,'ABC Jazz','ABC Jazz','201',567,0,0,1,0,0,'12','','','',561,0,0,561,4112,12827,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(56,9,6,1,0,'SBS ONE','SBS ONE','3',785,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(56,9,6,1,0,'SBS TWO','SBS TWO','32',786,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(56,9,6,1,0,'SBS 3','SBS 3','33',787,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(56,9,6,1,0,'SBS 4','SBS 4','34',788,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(56,9,6,1,0,'SBS HD','SBS HD','30',789,0,0,1,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(56,9,6,1,0,'SBS Radio 1','SBS Radio 1','38',798,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(56,9,6,1,0,'SBS Radio 2','SBS Radio 2','39',799,0,0,0,0,0,'29','','','',784,0,0,784,12802,12802,'dvb',0,1,1,0,1,1,0,0,1,0,0,0,''),(57,9,0,1,0,'C31','C31','44',3585,0,0,0,0,0,'32','','','',3584,0,0,3584,12832,12832,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(58,9,0,1,0,'C31','C31','44',3585,0,0,0,0,0,'32','','','',3584,0,0,3584,12832,12832,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(59,9,0,1,0,'3D Trial','3D Trial','40',13107,0,0,0,0,0,'35','','','',13104,0,0,13104,8228,13056,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,''),(60,9,0,1,0,'3D Trial','3D Trial','40',13107,0,0,0,0,0,'35','','','',13104,0,0,13104,8228,13056,'dvb',0,1,1,0,1,1,0,0,0,0,0,0,'');
199/*!40000 ALTER TABLE `channelscan_channel` ENABLE KEYS */;
200UNLOCK TABLES;
201
202--
203-- Table structure for table `channelscan_dtv_multiplex`
204--
205
206DROP TABLE IF EXISTS `channelscan_dtv_multiplex`;
207/*!40101 SET @saved_cs_client     = @@character_set_client */;
208/*!40101 SET character_set_client = utf8 */;
209CREATE TABLE `channelscan_dtv_multiplex` (
210  `transportid` int(6) unsigned NOT NULL AUTO_INCREMENT,
211  `scanid` int(3) unsigned NOT NULL,
212  `mplexid` smallint(6) unsigned NOT NULL,
213  `frequency` bigint(12) unsigned NOT NULL,
214  `inversion` char(1) NOT NULL DEFAULT 'a',
215  `symbolrate` bigint(12) unsigned NOT NULL DEFAULT '0',
216  `fec` varchar(10) NOT NULL DEFAULT 'auto',
217  `polarity` char(1) NOT NULL DEFAULT '',
218  `hp_code_rate` varchar(10) NOT NULL DEFAULT 'auto',
219  `mod_sys` varchar(10) DEFAULT NULL,
220  `rolloff` varchar(4) DEFAULT NULL,
221  `lp_code_rate` varchar(10) NOT NULL DEFAULT 'auto',
222  `modulation` varchar(10) NOT NULL DEFAULT 'auto',
223  `transmission_mode` char(1) NOT NULL DEFAULT 'a',
224  `guard_interval` varchar(10) NOT NULL DEFAULT 'auto',
225  `hierarchy` varchar(10) NOT NULL DEFAULT 'auto',
226  `bandwidth` char(1) NOT NULL DEFAULT 'a',
227  `sistandard` varchar(10) NOT NULL,
228  `tuner_type` smallint(2) unsigned NOT NULL,
229  `default_authority` varchar(32) NOT NULL DEFAULT '',
230  PRIMARY KEY (`transportid`)
231) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
232/*!40101 SET character_set_client = @saved_cs_client */;
233
234--
235-- Dumping data for table `channelscan_dtv_multiplex`
236--
237
238LOCK TABLES `channelscan_dtv_multiplex` WRITE;
239/*!40000 ALTER TABLE `channelscan_dtv_multiplex` DISABLE KEYS */;
240INSERT INTO `channelscan_dtv_multiplex` VALUES (1,1,0,177500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(2,1,0,191500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(3,1,0,219500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(4,1,0,226500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(5,1,0,536500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(6,2,0,177500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(7,2,0,191500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(8,2,0,219500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(9,2,0,226500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(10,2,0,536500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(39,6,18,177500000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','dvb',2,''),(38,6,17,177500000,'a',0,'auto','v','2/3','UNDEFINED','0.35','2/3','qam_64','8','1/16','n','7','mpeg',2,''),(37,6,16,536500000,'a',0,'auto','v','2/3','UNDEFINED','0.35','1/2','qam_64','8','1/8','n','7','dvb',2,''),(36,6,12,536625000,'a',0,'auto','v','2/3','UNDEFINED','0.35','1/2','qam_64','8','1/8','n','7','dvb',2,''),(35,6,11,536625000,'a',0,'auto','v','2/3','UNDEFINED','0.35','1/2','qam_64','8','1/8','n','7','dvb',2,''),(34,6,9,226500000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','dvb',2,''),(33,6,8,219500000,'a',0,'auto','v','3/4','UNDEFINED','0.35','1/2','qam_64','8','1/16','n','7','dvb',2,''),(32,6,7,191625000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','dvb',2,''),(31,6,6,536500000,'a',0,'auto','v','2/3','UNDEFINED','0.35','2/3','qam_64','8','1/8','n','7','mpeg',2,''),(30,6,5,536625000,'a',0,'auto','v','2/3','UNDEFINED','0.35','2/3','qam_64','8','1/8','n','7','mpeg',2,''),(29,6,4,219500000,'a',0,'auto','v','3/4','UNDEFINED','0.35','1/2','qam_64','8','1/16','n','7','mpeg',2,''),(28,6,3,191625000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','mpeg',2,''),(27,6,2,226500000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','mpeg',2,''),(40,6,24,191625000,'a',0,'auto','v','3/4','UNDEFINED','0.35','3/4','qam_64','8','1/16','n','7','dvb',2,''),(41,7,0,177500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(42,7,0,191500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(43,7,0,219500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(44,7,0,226500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(45,7,0,536500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(57,9,0,557500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(56,9,0,536500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(55,9,0,226500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(54,9,0,219500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(53,9,0,191500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(52,9,0,177500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(58,9,0,557500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(59,9,0,578500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,''),(60,9,0,578500000,'0',0,'auto','v','auto','UNDEFINED','0.35','auto','auto','8','auto','n','7','dvb',2,'');
241/*!40000 ALTER TABLE `channelscan_dtv_multiplex` ENABLE KEYS */;
242UNLOCK TABLES;
243/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
244
245/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
246/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
247/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
249/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
250/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
251/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
252
253-- Dump completed on 2010-09-23  7:41:04