1 | -- phpMyAdmin SQL Dump |
---|
2 | -- version 2.8.2 |
---|
3 | -- http://www.phpmyadmin.net |
---|
4 | -- |
---|
5 | -- Host: localhost |
---|
6 | -- Erstellungszeit: 09. August 2006 um 16:08 |
---|
7 | -- Server Version: 4.1.21 |
---|
8 | -- PHP-Version: 5.1.4-pl4-gentoo |
---|
9 | -- |
---|
10 | -- Datenbank: `mythconverg` |
---|
11 | -- |
---|
12 | |
---|
13 | -- -------------------------------------------------------- |
---|
14 | |
---|
15 | -- |
---|
16 | -- Tabellenstruktur fÃŒr Tabelle `capturecard` |
---|
17 | -- |
---|
18 | |
---|
19 | CREATE TABLE `capturecard` ( |
---|
20 | `cardid` int(10) unsigned NOT NULL auto_increment, |
---|
21 | `videodevice` varchar(128) default NULL, |
---|
22 | `audiodevice` varchar(128) default NULL, |
---|
23 | `vbidevice` varchar(128) default NULL, |
---|
24 | `cardtype` varchar(32) default 'V4L', |
---|
25 | `defaultinput` varchar(32) default 'Television', |
---|
26 | `audioratelimit` int(11) default NULL, |
---|
27 | `hostname` varchar(255) default NULL, |
---|
28 | `dvb_swfilter` int(11) default '0', |
---|
29 | `dvb_recordts` int(11) default '1', |
---|
30 | `dvb_sat_type` int(11) NOT NULL default '0', |
---|
31 | `dvb_wait_for_seqstart` int(11) NOT NULL default '1', |
---|
32 | `skipbtaudio` tinyint(1) default '0', |
---|
33 | `dvb_on_demand` tinyint(4) NOT NULL default '0', |
---|
34 | `dvb_diseqc_type` smallint(6) default NULL, |
---|
35 | `firewire_port` int(10) unsigned NOT NULL default '0', |
---|
36 | `firewire_node` int(10) unsigned NOT NULL default '2', |
---|
37 | `firewire_speed` int(10) unsigned NOT NULL default '0', |
---|
38 | `firewire_model` varchar(32) default NULL, |
---|
39 | `firewire_connection` int(10) unsigned NOT NULL default '0', |
---|
40 | `dvb_hw_decoder` int(11) default '0', |
---|
41 | `dbox2_port` int(10) unsigned NOT NULL default '31338', |
---|
42 | `dbox2_httpport` int(10) unsigned NOT NULL default '80', |
---|
43 | `dbox2_host` varchar(32) default NULL, |
---|
44 | `signal_timeout` int(11) NOT NULL default '1000', |
---|
45 | `channel_timeout` int(11) NOT NULL default '3000', |
---|
46 | `parentid` int(10) NOT NULL default '0', |
---|
47 | `dvb_tuning_delay` int(10) unsigned NOT NULL default '0', |
---|
48 | `contrast` int(11) NOT NULL default '0', |
---|
49 | `brightness` int(11) NOT NULL default '0', |
---|
50 | `colour` int(11) NOT NULL default '0', |
---|
51 | `hue` int(11) NOT NULL default '0', |
---|
52 | `diseqcid` int(10) unsigned default NULL, |
---|
53 | PRIMARY KEY (`cardid`) |
---|
54 | ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
---|
55 | |
---|
56 | -- |
---|
57 | -- Daten fÃŒr Tabelle `capturecard` |
---|
58 | -- |
---|
59 | |
---|
60 | INSERT INTO `capturecard` VALUES (1, '0', '', '', 'DVB', 'DVBInput #1', NULL, 'Novoli', 0, 1, 0, 1, 0, 0, NULL, 0, 2, 0, NULL, 0, 0, 31338, 80, NULL, 60000, 62500, 0, 0, 0, 0, 0, 0, 1); |
---|
61 | |
---|
62 | -- -------------------------------------------------------- |
---|
63 | |
---|
64 | -- |
---|
65 | -- Tabellenstruktur fÃŒr Tabelle `cardinput` |
---|
66 | -- |
---|
67 | |
---|
68 | CREATE TABLE `cardinput` ( |
---|
69 | `cardinputid` int(10) unsigned NOT NULL auto_increment, |
---|
70 | `cardid` int(10) unsigned NOT NULL default '0', |
---|
71 | `sourceid` int(10) unsigned NOT NULL default '0', |
---|
72 | `inputname` varchar(32) NOT NULL default '', |
---|
73 | `externalcommand` varchar(128) default NULL, |
---|
74 | `preference` int(11) NOT NULL default '0', |
---|
75 | `shareable` char(1) default 'N', |
---|
76 | `tunechan` varchar(10) default NULL, |
---|
77 | `startchan` varchar(10) default NULL, |
---|
78 | `freetoaironly` tinyint(1) default '1', |
---|
79 | `diseqc_port` smallint(6) default NULL, |
---|
80 | `diseqc_pos` float default NULL, |
---|
81 | `lnb_lof_switch` int(11) default '11700000', |
---|
82 | `lnb_lof_hi` int(11) default '10600000', |
---|
83 | `lnb_lof_lo` int(11) default '9750000', |
---|
84 | `displayname` varchar(64) NOT NULL default '', |
---|
85 | `radioservices` tinyint(1) default '1', |
---|
86 | `childcardid` int(10) NOT NULL default '0', |
---|
87 | `dishnet_eit` tinyint(1) NOT NULL default '0', |
---|
88 | `recpriority` int(11) NOT NULL default '0', |
---|
89 | PRIMARY KEY (`cardinputid`) |
---|
90 | ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
---|
91 | |
---|
92 | -- |
---|
93 | -- Daten fÃŒr Tabelle `cardinput` |
---|
94 | -- |
---|
95 | |
---|
96 | INSERT INTO `cardinput` VALUES (1, 1, 1, 'DVBInput', NULL, 0, 'N', NULL, '501', 1, NULL, NULL, 11700000, 10600000, 9750000, 'DVB-EIT', 0, 0, 0, 0); |
---|
97 | |
---|
98 | -- -------------------------------------------------------- |
---|
99 | |
---|
100 | -- |
---|
101 | -- Tabellenstruktur fÃŒr Tabelle `channel` |
---|
102 | -- |
---|
103 | |
---|
104 | CREATE TABLE `channel` ( |
---|
105 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
106 | `channum` varchar(10) NOT NULL default '', |
---|
107 | `freqid` varchar(10) default NULL, |
---|
108 | `sourceid` int(10) unsigned default NULL, |
---|
109 | `callsign` varchar(20) NOT NULL default '', |
---|
110 | `name` varchar(64) NOT NULL default '', |
---|
111 | `icon` varchar(255) NOT NULL default 'none', |
---|
112 | `finetune` int(11) default NULL, |
---|
113 | `videofilters` varchar(255) NOT NULL default '', |
---|
114 | `xmltvid` varchar(64) NOT NULL default '', |
---|
115 | `recpriority` int(10) NOT NULL default '0', |
---|
116 | `contrast` int(11) default '32768', |
---|
117 | `brightness` int(11) default '32768', |
---|
118 | `colour` int(11) default '32768', |
---|
119 | `hue` int(11) default '32768', |
---|
120 | `tvformat` varchar(10) NOT NULL default 'Default', |
---|
121 | `commfree` tinyint(4) NOT NULL default '0', |
---|
122 | `visible` tinyint(1) NOT NULL default '1', |
---|
123 | `outputfilters` varchar(255) NOT NULL default '', |
---|
124 | `useonairguide` tinyint(1) default '0', |
---|
125 | `mplexid` smallint(6) default NULL, |
---|
126 | `serviceid` mediumint(8) unsigned default NULL, |
---|
127 | `atscsrcid` int(11) default NULL, |
---|
128 | `tmoffset` int(11) NOT NULL default '0', |
---|
129 | `atsc_major_chan` int(10) unsigned NOT NULL default '0', |
---|
130 | `atsc_minor_chan` int(10) unsigned NOT NULL default '0', |
---|
131 | PRIMARY KEY (`chanid`), |
---|
132 | KEY `channel_src` (`channum`,`sourceid`) |
---|
133 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
134 | |
---|
135 | -- |
---|
136 | -- Daten fÃŒr Tabelle `channel` |
---|
137 | -- |
---|
138 | |
---|
139 | INSERT INTO `channel` VALUES (1501, '501', NULL, 1, 'RTL TELE Letzebuerg', 'RTL TELE Letzebuerg', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 1, 3994, NULL, 0, 0, 0); |
---|
140 | INSERT INTO `channel` VALUES (1502, '502', NULL, 1, 'Astra Vision', 'Astra Vision', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 1, 3997, NULL, 0, 0, 0); |
---|
141 | INSERT INTO `channel` VALUES (1503, '503', NULL, 1, 'QVC Deutschland', 'QVC Deutschland', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 1, 12100, NULL, 0, 0, 0); |
---|
142 | INSERT INTO `channel` VALUES (1504, '504', NULL, 1, 'Radio Bremen TV', 'Radio Bremen TV', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 2, 28485, NULL, 0, 0, 0); |
---|
143 | INSERT INTO `channel` VALUES (1505, '505', NULL, 1, 'SR SÃDWEST Ferns.', 'SR SÃDWEST Ferns.', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 2, 28486, NULL, 0, 0, 0); |
---|
144 | INSERT INTO `channel` VALUES (1506, '506', NULL, 1, 'ASTRA HD', 'ASTRA HD', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 3, 21101, NULL, 0, 0, 0); |
---|
145 | INSERT INTO `channel` VALUES (1507, '507', NULL, 1, 'DAS VIERTE', 'DAS VIERTE', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 4, 1793, NULL, 0, 0, 0); |
---|
146 | INSERT INTO `channel` VALUES (1508, '508', NULL, 1, 'SAT.1', 'SAT.1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 46, NULL, 0, 0, 0); |
---|
147 | INSERT INTO `channel` VALUES (1509, '509', NULL, 1, 'N24', 'N24', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 47, NULL, 0, 0, 0); |
---|
148 | INSERT INTO `channel` VALUES (1510, '510', NULL, 1, 'TELE 5', 'TELE 5', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 51, NULL, 0, 0, 0); |
---|
149 | INSERT INTO `channel` VALUES (1511, '511', NULL, 1, 'AstroTV', 'AstroTV', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 661, NULL, 0, 0, 0); |
---|
150 | INSERT INTO `channel` VALUES (1512, '512', NULL, 1, '9Live', '9Live', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 897, NULL, 0, 0, 0); |
---|
151 | INSERT INTO `channel` VALUES (1513, '513', NULL, 1, 'ProSieben', 'ProSieben', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 898, NULL, 0, 0, 0); |
---|
152 | INSERT INTO `channel` VALUES (1514, '514', NULL, 1, 'KABEL1', 'KABEL1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 899, NULL, 0, 0, 0); |
---|
153 | INSERT INTO `channel` VALUES (1515, '515', NULL, 1, 'DSF', 'DSF', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 5, 900, NULL, 0, 0, 0); |
---|
154 | INSERT INTO `channel` VALUES (1516, '516', NULL, 1, 'RAI 1', 'RAI 1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 6, 9015, NULL, 0, 0, 0); |
---|
155 | INSERT INTO `channel` VALUES (1517, '517', NULL, 1, 'ARTE', 'ARTE', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 6, 9019, NULL, 0, 0, 0); |
---|
156 | INSERT INTO `channel` VALUES (1518, '518', NULL, 1, 'MTV Germany', 'MTV Germany', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 7, 28673, NULL, 0, 0, 0); |
---|
157 | INSERT INTO `channel` VALUES (1519, '519', NULL, 1, 'VIVA', 'VIVA', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 7, 28676, NULL, 0, 0, 0); |
---|
158 | INSERT INTO `channel` VALUES (1520, '520', NULL, 1, 'VIVA PLUS', 'VIVA PLUS', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 7, 28677, NULL, 0, 0, 0); |
---|
159 | INSERT INTO `channel` VALUES (1521, '521', NULL, 1, 'NICK', 'NICK', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 7, 28680, NULL, 0, 0, 0); |
---|
160 | INSERT INTO `channel` VALUES (1522, '522', NULL, 1, 'ZDF', 'ZDF', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28006, NULL, 0, 0, 0); |
---|
161 | INSERT INTO `channel` VALUES (1523, '523', NULL, 1, 'ZDFinfokanal', 'ZDFinfokanal', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28011, NULL, 0, 0, 0); |
---|
162 | INSERT INTO `channel` VALUES (1524, '524', NULL, 1, 'ZDFdokukanal', 'ZDFdokukanal', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28014, NULL, 0, 0, 0); |
---|
163 | INSERT INTO `channel` VALUES (1525, '525', NULL, 1, 'ZDFtheaterkanal', 'ZDFtheaterkanal', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28016, NULL, 0, 0, 0); |
---|
164 | INSERT INTO `channel` VALUES (1526, '526', NULL, 1, '3sat', '3sat', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28007, NULL, 0, 0, 0); |
---|
165 | INSERT INTO `channel` VALUES (1527, '527', NULL, 1, 'KiKa', 'KiKa', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 8, 28008, NULL, 0, 0, 0); |
---|
166 | INSERT INTO `channel` VALUES (1528, '528', NULL, 1, 'RTL Television', 'RTL Television', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12003, NULL, 0, 0, 0); |
---|
167 | INSERT INTO `channel` VALUES (1529, '529', NULL, 1, 'RTL2', 'RTL2', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12020, NULL, 0, 0, 0); |
---|
168 | INSERT INTO `channel` VALUES (1530, '530', NULL, 1, 'Super RTL', 'Super RTL', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12040, NULL, 0, 0, 0); |
---|
169 | INSERT INTO `channel` VALUES (1531, '531', NULL, 1, 'VOX', 'VOX', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12060, NULL, 0, 0, 0); |
---|
170 | INSERT INTO `channel` VALUES (1532, '532', NULL, 1, 'n-tv', 'n-tv', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12090, NULL, 0, 0, 0); |
---|
171 | INSERT INTO `channel` VALUES (1533, '533', NULL, 1, 'RTL Shop', 'RTL Shop', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 9, 12080, NULL, 0, 0, 0); |
---|
172 | INSERT INTO `channel` VALUES (1534, '534', NULL, 1, 'Eurosport', 'Eurosport', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 10, 31200, NULL, 0, 0, 0); |
---|
173 | INSERT INTO `channel` VALUES (1535, '535', NULL, 1, 'EuroNews', 'EuroNews', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 10, 31220, NULL, 0, 0, 0); |
---|
174 | INSERT INTO `channel` VALUES (1536, '536', NULL, 1, 'TERRA NOVA', 'TERRA NOVA', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 11, 17033, NULL, 0, 0, 0); |
---|
175 | INSERT INTO `channel` VALUES (1537, '537', NULL, 1, 'NATIONAL GEO HD', 'NATIONAL GEO HD', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 12, 9103, NULL, 0, 0, 0); |
---|
176 | INSERT INTO `channel` VALUES (1538, '538', NULL, 1, 'Das Erste', 'Das Erste', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28106, NULL, 0, 0, 0); |
---|
177 | INSERT INTO `channel` VALUES (1539, '539', NULL, 1, 'Bayerisches FS', 'Bayerisches FS', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28107, NULL, 0, 0, 0); |
---|
178 | INSERT INTO `channel` VALUES (1540, '540', NULL, 1, 'hr-fernsehen', 'hr-fernsehen', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28108, NULL, 0, 0, 0); |
---|
179 | INSERT INTO `channel` VALUES (1541, '541', NULL, 1, 'WDR Köln', 'WDR Köln', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28111, NULL, 0, 0, 0); |
---|
180 | INSERT INTO `channel` VALUES (1542, '542', NULL, 1, 'BR-alpha', 'BR-alpha', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28112, NULL, 0, 0, 0); |
---|
181 | INSERT INTO `channel` VALUES (1543, '543', NULL, 1, 'SÃDWEST Ferns. BW', 'SÃDWEST Ferns. BW', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28113, NULL, 0, 0, 0); |
---|
182 | INSERT INTO `channel` VALUES (1544, '544', NULL, 1, 'Phoenix', 'Phoenix', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 13, 28114, NULL, 0, 0, 0); |
---|
183 | INSERT INTO `channel` VALUES (1545, '545', NULL, 1, 'SexySat', 'SexySat', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 14, 12621, NULL, 0, 0, 0); |
---|
184 | INSERT INTO `channel` VALUES (1546, '546', NULL, 1, 'EinsExtra', 'EinsExtra', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28201, NULL, 0, 0, 0); |
---|
185 | INSERT INTO `channel` VALUES (1547, '547', NULL, 1, 'EinsFestival', 'EinsFestival', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28202, NULL, 0, 0, 0); |
---|
186 | INSERT INTO `channel` VALUES (1548, '548', NULL, 1, 'EinsPlus', 'EinsPlus', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28203, NULL, 0, 0, 0); |
---|
187 | INSERT INTO `channel` VALUES (1549, '549', NULL, 1, 'MDR FERNSEHEN', 'MDR FERNSEHEN', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28204, NULL, 0, 0, 0); |
---|
188 | INSERT INTO `channel` VALUES (1550, '550', NULL, 1, 'rbb Berlin', 'rbb Berlin', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28206, NULL, 0, 0, 0); |
---|
189 | INSERT INTO `channel` VALUES (1551, '551', NULL, 1, 'NDR FS NDS', 'NDR FS NDS', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28226, NULL, 0, 0, 0); |
---|
190 | INSERT INTO `channel` VALUES (1552, '552', NULL, 1, 'MDR THÃRINGEN', 'MDR THÃRINGEN', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28230, NULL, 0, 0, 0); |
---|
191 | INSERT INTO `channel` VALUES (1553, '553', NULL, 1, 'SÃDWEST Ferns. RP', 'SÃDWEST Ferns. RP', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 15, 28231, NULL, 0, 0, 0); |
---|
192 | |
---|
193 | -- -------------------------------------------------------- |
---|
194 | |
---|
195 | -- |
---|
196 | -- Tabellenstruktur fÃŒr Tabelle `dtv_multiplex` |
---|
197 | -- |
---|
198 | |
---|
199 | CREATE TABLE `dtv_multiplex` ( |
---|
200 | `mplexid` smallint(6) NOT NULL auto_increment, |
---|
201 | `sourceid` smallint(6) default NULL, |
---|
202 | `transportid` int(11) default NULL, |
---|
203 | `networkid` int(11) default NULL, |
---|
204 | `frequency` int(11) default NULL, |
---|
205 | `inversion` char(1) default 'a', |
---|
206 | `symbolrate` int(11) default NULL, |
---|
207 | `fec` varchar(10) default 'auto', |
---|
208 | `polarity` char(1) default NULL, |
---|
209 | `modulation` varchar(10) default 'auto', |
---|
210 | `bandwidth` char(1) default 'a', |
---|
211 | `lp_code_rate` varchar(10) default 'auto', |
---|
212 | `transmission_mode` char(1) default 'a', |
---|
213 | `guard_interval` varchar(10) default 'auto', |
---|
214 | `visible` smallint(1) NOT NULL default '0', |
---|
215 | `constellation` varchar(10) default 'auto', |
---|
216 | `hierarchy` varchar(10) default 'auto', |
---|
217 | `hp_code_rate` varchar(10) default 'auto', |
---|
218 | `sistandard` varchar(10) default 'dvb', |
---|
219 | `serviceversion` smallint(6) default '33', |
---|
220 | `updatetimestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
---|
221 | PRIMARY KEY (`mplexid`) |
---|
222 | ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; |
---|
223 | |
---|
224 | -- |
---|
225 | -- Daten fÃŒr Tabelle `dtv_multiplex` |
---|
226 | -- |
---|
227 | |
---|
228 | INSERT INTO `dtv_multiplex` VALUES (1, 1, NULL, NULL, 12551000, 'a', 22000000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
229 | INSERT INTO `dtv_multiplex` VALUES (2, 1, NULL, NULL, 12265000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
230 | INSERT INTO `dtv_multiplex` VALUES (3, 1, NULL, NULL, 12168000, 'a', 27500000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
231 | INSERT INTO `dtv_multiplex` VALUES (4, 1, NULL, NULL, 12460000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
232 | INSERT INTO `dtv_multiplex` VALUES (5, 1, NULL, NULL, 12480000, 'a', 27500000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
233 | INSERT INTO `dtv_multiplex` VALUES (6, 1, NULL, NULL, 11567000, 'a', 22000000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
234 | INSERT INTO `dtv_multiplex` VALUES (7, 1, NULL, NULL, 11973000, 'a', 27500000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
235 | INSERT INTO `dtv_multiplex` VALUES (8, 1, NULL, NULL, 11953000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
236 | INSERT INTO `dtv_multiplex` VALUES (9, 1, NULL, NULL, 12187000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
237 | INSERT INTO `dtv_multiplex` VALUES (10, 1, NULL, NULL, 12226000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
238 | INSERT INTO `dtv_multiplex` VALUES (11, 1, NULL, NULL, 12285000, 'a', 27500000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
239 | INSERT INTO `dtv_multiplex` VALUES (12, 1, NULL, NULL, 12363000, 'a', 27500000, 'auto', 'v', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
240 | INSERT INTO `dtv_multiplex` VALUES (13, 1, NULL, NULL, 11836000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
241 | INSERT INTO `dtv_multiplex` VALUES (14, 1, NULL, NULL, 12574000, 'a', 22000000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|
242 | INSERT INTO `dtv_multiplex` VALUES (15, 1, NULL, NULL, 12109000, 'a', 27500000, 'auto', 'h', 'auto', 'a', 'auto', 'a', 'auto', 0, 'auto', 'a', 'auto', 'dvb', 33, '2006-08-09 15:23:15'); |
---|