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 | |
---|
22 | DROP TABLE IF EXISTS `channel`; |
---|
23 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
24 | /*!40101 SET character_set_client = utf8 */; |
---|
25 | CREATE 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 | |
---|
64 | LOCK TABLES `channel` WRITE; |
---|
65 | /*!40000 ALTER TABLE `channel` DISABLE KEYS */; |
---|
66 | INSERT INTO `channel` VALUES (1032,'32','',1,'SBS TWO','SBS TWO','/meric/mythtv/channel_icons/icons-frogman-blue/png/sbs-two.png',0,'','32',0,32768,32768,32768,0,'Default',1,'',0,6,786,0,0,0,'0000-00-00 00:00:00','',-1),(1009,'9','',1,'Nine Digital','Nine Digital','/meric/mythtv/channel_icons/icons-frogman-blue/png/nine.png',0,'','7',0,32768,32768,32768,0,'Default',1,'',0,3,1072,0,0,0,'0000-00-00 00:00:00','',-1),(1090,'90','',1,'Nine Digital HD','Nine Digital HD','/meric/mythtv/channel_icons/icons-frogman-blue/png/nine-hd.png',0,'','91',0,32768,32768,32768,0,'Default',1,'',0,3,1073,0,0,0,'2010-09-05 21:30:02','',-1),(1099,'99','',1,'GO!','GO!','/meric/mythtv/channel_icons/icons-frogman-blue/png/go.png',0,'','2390',0,32768,32768,32768,0,'Default',1,'',0,3,1074,0,0,0,'2010-09-22 18:25:02','',-1),(1001,'1','',1,'ONE HD','ONE HD','/meric/mythtv/channel_icons/icons-frogman-blue/png/one-hd.png',0,'','94',0,32768,32768,32768,0,'Default',1,'',0,4,1585,0,0,0,'0000-00-00 00:00:00','',-1),(1010,'10','',1,'TEN Digital','TEN Digital','/meric/mythtv/channel_icons/icons-frogman-blue/png/ten.png',0,'','8',0,32768,32768,32768,0,'Default',1,'',0,4,1589,0,0,0,'2010-05-30 20:13:57','',-1),(1011,'11','11',1,'ONE HD','ONE HD','',0,'','94',0,32768,32768,32768,32768,'Default',0,'',1,4,1591,0,0,0,'0000-00-00 00:00:00','',-1),(1012,'12','',1,'ONE Digital','ONE Digital','/meric/mythtv/channel_icons/icons-frogman-blue/png/one.png',0,'','1697',0,32768,32768,32768,0,'Default',1,'',0,4,1592,0,0,0,'0000-00-00 00:00:00','',-1),(1002,'2','',1,'ABC1','ABC1','/meric/mythtv/channel_icons/icons-frogman-blue/png/abc.png',0,'','9',0,32768,32768,32768,0,'Default',1,'',0,2,561,0,0,0,'2010-09-22 20:30:02','',-2),(1022,'22','',1,'ABC2','ABC2','/meric/mythtv/channel_icons/icons-frogman-blue/png/abc2.png',0,'','36',0,32768,32768,32768,0,'Default',1,'',0,2,562,0,0,0,'0000-00-00 00:00:00','',-2),(1021,'21','12',1,'ABC1','ABC1','',0,'','9',0,32768,32768,32768,32768,'Default',0,'',1,2,563,0,0,0,'0000-00-00 00:00:00','',-2),(1023,'23','',1,'ABC3','ABC3','',0,'','2417',0,32768,32768,32768,0,'Default',1,'',0,2,564,0,0,0,'0000-00-00 00:00:00','',-2),(1003,'3','',1,'SBS ONE','SBS ONE','/meric/mythtv/channel_icons/icons-frogman-blue/png/sbs.png',0,'','10',0,32768,32768,32768,0,'Default',1,'',0,6,785,0,0,0,'0000-00-00 00:00:00','',-1),(1071,'71','5',1,'7 Digital 1','7 Digital 1','',0,'','',0,32768,32768,32768,32768,'Default',0,'',1,17,1329,0,0,0,'0000-00-00 00:00:00','',-1),(1024,'24','',1,'ABC News 24','ABC News 24','',0,'','90',0,32768,32768,32768,0,'',1,'',0,2,560,0,0,0,'0000-00-00 00:00:00','',-2),(2330,'72','',1,'7TWO','7TWO','',0,'','2405',0,32768,32768,32768,0,'Default',1,'',0,17,1330,0,0,0,'0000-00-00 00:00:00','',-1),(1070,'70','',1,'7 HD Digital','7 HD Digital','/meric/mythtv/channel_icons/icons-frogman-blue/png/seven-hd.png',0,'','93',0,32768,32768,32768,0,'Default',1,'',0,17,1332,0,0,0,'2010-04-30 19:25:02','',-1),(1007,'7','',1,'7 Digital','7 Digital','/meric/mythtv/channel_icons/icons-frogman-blue/png/seven.png',0,'','6',0,32768,32768,32768,0,'Default',1,'',0,17,1328,0,0,0,'0000-00-00 00:00:00','',-1),(1033,'33','29',1,'SBS 3','SBS 3','',0,'','',0,32768,32768,32768,32768,'Default',0,'',1,6,787,0,0,0,'0000-00-00 00:00:00','',-1),(1034,'34','29',1,'SBS 4','SBS 4','',0,'','',0,32768,32768,32768,32768,'Default',0,'',1,6,788,0,0,0,'0000-00-00 00:00:00','',-1),(1030,'30','',1,'SBS HD','SBS HD','/meric/mythtv/channel_icons/icons-frogman-blue/png/sbs-hd.png',0,'','92',0,32768,32768,32768,0,'Default',1,'',0,6,789,0,0,0,'0000-00-00 00:00:00','',-1),(1073,'73','5',1,'7 Digital 3','7 Digital 3','',0,'','',0,32768,32768,32768,32768,'Default',0,'',1,17,1331,0,0,0,'0000-00-00 00:00:00','',-1); |
---|
67 | /*!40000 ALTER TABLE `channel` ENABLE KEYS */; |
---|
68 | UNLOCK TABLES; |
---|
69 | |
---|
70 | -- |
---|
71 | -- Table structure for table `dtv_multiplex` |
---|
72 | -- |
---|
73 | |
---|
74 | DROP TABLE IF EXISTS `dtv_multiplex`; |
---|
75 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
76 | /*!40101 SET character_set_client = utf8 */; |
---|
77 | CREATE 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=25 DEFAULT CHARSET=utf8; |
---|
104 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
105 | |
---|
106 | -- |
---|
107 | -- Dumping data for table `dtv_multiplex` |
---|
108 | -- |
---|
109 | |
---|
110 | LOCK TABLES `dtv_multiplex` WRITE; |
---|
111 | /*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */; |
---|
112 | INSERT 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',''),(5,1,NULL,NULL,536625000,'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',''),(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',''),(7,1,1072,12829,191625000,'a',NULL,NULL,NULL,NULL,'7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'dvb',15,'2009-02-12 22:54:22',''),(8,1,1539,4116,219500000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/16',0,'qam_64','n','3/4','1',NULL,'dvb',5,'2009-02-12 22:54:32',''),(9,1,561,4112,226500000,'a',NULL,NULL,NULL,NULL,'7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'dvb',10,'2009-08-07 07:36:17',''),(10,1,768,12802,571500000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(11,1,784,12802,536625000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',0,'2009-02-12 22:54:35',''),(12,1,800,12802,536625000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(13,1,816,12802,585625000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(14,1,832,12802,564500000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(15,1,848,12802,543500000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(16,1,864,12802,536500000,'a',NULL,NULL,NULL,NULL,'7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(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',''),(18,1,1283,4115,177500000,'a',NULL,NULL,NULL,NULL,'7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'dvb',14,'2009-08-07 07:35:59',''),(19,1,880,12802,0,'a',NULL,'auto',NULL,'auto','7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(20,1,896,12802,205500000,'a',NULL,'auto',NULL,'auto','7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(21,1,912,12802,0,'a',NULL,'auto',NULL,'auto','7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(22,1,928,12802,0,'a',NULL,'auto',NULL,'auto','7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(23,1,944,12802,0,'a',NULL,'auto',NULL,'auto','7','1/2','8','1/8',0,'qam_64','n','2/3','1',NULL,'dvb',33,'2009-01-10 01:20:49',''),(24,1,1072,4114,191625000,'a',NULL,'auto',NULL,'auto','7','3/4','8','1/16',0,'qam_64','n','3/4','1',NULL,'dvb',2,'2009-08-07 07:36:06',''); |
---|
113 | /*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */; |
---|
114 | UNLOCK TABLES; |
---|
115 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
116 | |
---|
117 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
118 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
119 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
120 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
121 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
122 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
123 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
124 | |
---|
125 | -- Dump completed on 2010-09-23 7:35:36 |
---|