1 | -- MySQL dump 10.10 |
---|
2 | -- |
---|
3 | -- Host: localhost Database: mythconverg |
---|
4 | -- ------------------------------------------------------ |
---|
5 | -- Server version 5.0.22 |
---|
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 `callsignnetworkmap` |
---|
20 | -- |
---|
21 | |
---|
22 | DROP TABLE IF EXISTS `callsignnetworkmap`; |
---|
23 | CREATE TABLE `callsignnetworkmap` ( |
---|
24 | `id` int(11) NOT NULL auto_increment, |
---|
25 | `callsign` varchar(20) NOT NULL default '', |
---|
26 | `network` varchar(20) NOT NULL default '', |
---|
27 | PRIMARY KEY (`id`), |
---|
28 | UNIQUE KEY `callsign` (`callsign`) |
---|
29 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
30 | |
---|
31 | -- |
---|
32 | -- Dumping data for table `callsignnetworkmap` |
---|
33 | -- |
---|
34 | |
---|
35 | |
---|
36 | /*!40000 ALTER TABLE `callsignnetworkmap` DISABLE KEYS */; |
---|
37 | LOCK TABLES `callsignnetworkmap` WRITE; |
---|
38 | UNLOCK TABLES; |
---|
39 | /*!40000 ALTER TABLE `callsignnetworkmap` ENABLE KEYS */; |
---|
40 | |
---|
41 | -- |
---|
42 | -- Table structure for table `capturecard` |
---|
43 | -- |
---|
44 | |
---|
45 | DROP TABLE IF EXISTS `capturecard`; |
---|
46 | CREATE TABLE `capturecard` ( |
---|
47 | `cardid` int(10) unsigned NOT NULL auto_increment, |
---|
48 | `videodevice` varchar(128) default NULL, |
---|
49 | `audiodevice` varchar(128) default NULL, |
---|
50 | `vbidevice` varchar(128) default NULL, |
---|
51 | `cardtype` varchar(32) default 'V4L', |
---|
52 | `defaultinput` varchar(32) default 'Television', |
---|
53 | `audioratelimit` int(11) default NULL, |
---|
54 | `hostname` varchar(255) default NULL, |
---|
55 | `dvb_swfilter` int(11) default '0', |
---|
56 | `dvb_recordts` int(11) default '1', |
---|
57 | `dvb_sat_type` int(11) NOT NULL default '0', |
---|
58 | `dvb_wait_for_seqstart` int(11) NOT NULL default '1', |
---|
59 | `skipbtaudio` tinyint(1) default '0', |
---|
60 | `dvb_on_demand` tinyint(4) NOT NULL default '0', |
---|
61 | `dvb_diseqc_type` smallint(6) default NULL, |
---|
62 | `firewire_port` int(10) unsigned NOT NULL default '0', |
---|
63 | `firewire_node` int(10) unsigned NOT NULL default '2', |
---|
64 | `firewire_speed` int(10) unsigned NOT NULL default '0', |
---|
65 | `firewire_model` varchar(32) default NULL, |
---|
66 | `firewire_connection` int(10) unsigned NOT NULL default '0', |
---|
67 | `dvb_hw_decoder` int(11) default '0', |
---|
68 | `dbox2_port` int(10) unsigned NOT NULL default '31338', |
---|
69 | `dbox2_httpport` int(10) unsigned NOT NULL default '80', |
---|
70 | `dbox2_host` varchar(32) default NULL, |
---|
71 | `signal_timeout` int(11) NOT NULL default '1000', |
---|
72 | `channel_timeout` int(11) NOT NULL default '3000', |
---|
73 | `parentid` int(10) NOT NULL default '0', |
---|
74 | `dvb_tuning_delay` int(10) unsigned NOT NULL default '0', |
---|
75 | `contrast` int(11) NOT NULL default '0', |
---|
76 | `brightness` int(11) NOT NULL default '0', |
---|
77 | `colour` int(11) NOT NULL default '0', |
---|
78 | `hue` int(11) NOT NULL default '0', |
---|
79 | `diseqcid` int(10) unsigned default NULL, |
---|
80 | PRIMARY KEY (`cardid`) |
---|
81 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
82 | |
---|
83 | -- |
---|
84 | -- Dumping data for table `capturecard` |
---|
85 | -- |
---|
86 | |
---|
87 | |
---|
88 | /*!40000 ALTER TABLE `capturecard` DISABLE KEYS */; |
---|
89 | LOCK TABLES `capturecard` WRITE; |
---|
90 | INSERT INTO `capturecard` VALUES (1,'0','','','DVB','DVBInput #1',NULL,'zenslack',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); |
---|
91 | UNLOCK TABLES; |
---|
92 | /*!40000 ALTER TABLE `capturecard` ENABLE KEYS */; |
---|
93 | |
---|
94 | -- |
---|
95 | -- Table structure for table `cardinput` |
---|
96 | -- |
---|
97 | |
---|
98 | DROP TABLE IF EXISTS `cardinput`; |
---|
99 | CREATE TABLE `cardinput` ( |
---|
100 | `cardinputid` int(10) unsigned NOT NULL auto_increment, |
---|
101 | `cardid` int(10) unsigned NOT NULL default '0', |
---|
102 | `sourceid` int(10) unsigned NOT NULL default '0', |
---|
103 | `inputname` varchar(32) NOT NULL default '', |
---|
104 | `externalcommand` varchar(128) default NULL, |
---|
105 | `preference` int(11) NOT NULL default '0', |
---|
106 | `shareable` char(1) default 'N', |
---|
107 | `tunechan` varchar(10) default NULL, |
---|
108 | `startchan` varchar(10) default NULL, |
---|
109 | `freetoaironly` tinyint(1) default '1', |
---|
110 | `diseqc_port` smallint(6) default NULL, |
---|
111 | `diseqc_pos` float default NULL, |
---|
112 | `lnb_lof_switch` int(11) default '11700000', |
---|
113 | `lnb_lof_hi` int(11) default '10600000', |
---|
114 | `lnb_lof_lo` int(11) default '9750000', |
---|
115 | `displayname` varchar(64) NOT NULL default '', |
---|
116 | `radioservices` tinyint(1) default '1', |
---|
117 | `childcardid` int(10) NOT NULL default '0', |
---|
118 | `dishnet_eit` tinyint(1) NOT NULL default '0', |
---|
119 | `recpriority` int(11) NOT NULL default '0', |
---|
120 | PRIMARY KEY (`cardinputid`) |
---|
121 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
122 | |
---|
123 | -- |
---|
124 | -- Dumping data for table `cardinput` |
---|
125 | -- |
---|
126 | |
---|
127 | |
---|
128 | /*!40000 ALTER TABLE `cardinput` DISABLE KEYS */; |
---|
129 | LOCK TABLES `cardinput` WRITE; |
---|
130 | INSERT INTO `cardinput` VALUES (1,1,1,'DVBInput',NULL,0,'N',NULL,'1',0,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0); |
---|
131 | UNLOCK TABLES; |
---|
132 | /*!40000 ALTER TABLE `cardinput` ENABLE KEYS */; |
---|
133 | |
---|
134 | -- |
---|
135 | -- Table structure for table `channel` |
---|
136 | -- |
---|
137 | |
---|
138 | DROP TABLE IF EXISTS `channel`; |
---|
139 | CREATE TABLE `channel` ( |
---|
140 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
141 | `channum` varchar(10) NOT NULL default '', |
---|
142 | `freqid` varchar(10) default NULL, |
---|
143 | `sourceid` int(10) unsigned default NULL, |
---|
144 | `callsign` varchar(20) NOT NULL default '', |
---|
145 | `name` varchar(64) NOT NULL default '', |
---|
146 | `icon` varchar(255) NOT NULL default 'none', |
---|
147 | `finetune` int(11) default NULL, |
---|
148 | `videofilters` varchar(255) NOT NULL default '', |
---|
149 | `xmltvid` varchar(64) NOT NULL default '', |
---|
150 | `recpriority` int(10) NOT NULL default '0', |
---|
151 | `contrast` int(11) default '32768', |
---|
152 | `brightness` int(11) default '32768', |
---|
153 | `colour` int(11) default '32768', |
---|
154 | `hue` int(11) default '32768', |
---|
155 | `tvformat` varchar(10) NOT NULL default 'Default', |
---|
156 | `commfree` tinyint(4) NOT NULL default '0', |
---|
157 | `visible` tinyint(1) NOT NULL default '1', |
---|
158 | `outputfilters` varchar(255) NOT NULL default '', |
---|
159 | `useonairguide` tinyint(1) default '0', |
---|
160 | `mplexid` smallint(6) default NULL, |
---|
161 | `serviceid` mediumint(8) unsigned default NULL, |
---|
162 | `atscsrcid` int(11) default NULL, |
---|
163 | `tmoffset` int(11) NOT NULL default '0', |
---|
164 | `atsc_major_chan` int(10) unsigned NOT NULL default '0', |
---|
165 | `atsc_minor_chan` int(10) unsigned NOT NULL default '0', |
---|
166 | PRIMARY KEY (`chanid`), |
---|
167 | KEY `channel_src` (`channum`,`sourceid`) |
---|
168 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
169 | |
---|
170 | -- |
---|
171 | -- Dumping data for table `channel` |
---|
172 | -- |
---|
173 | |
---|
174 | |
---|
175 | /*!40000 ALTER TABLE `channel` DISABLE KEYS */; |
---|
176 | LOCK TABLES `channel` WRITE; |
---|
177 | INSERT INTO `channel` VALUES (29130,'28130',NULL,1,'Test-R','Test-R','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',0,33,28130,NULL,0,0,0),(29107,'28107',NULL,1,'Bayerisches FS','Bayerisches FS','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28107,NULL,0,0,0),(29111,'28111',NULL,1,'WDR K̦ln','WDR K̦ln','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28111,NULL,0,0,0),(29109,'28109',NULL,1,'arte','arte','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28109,NULL,0,0,0),(29106,'1',NULL,1,'Das Erste','Das Erste','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28106,NULL,0,0,0),(29108,'28108',NULL,1,'hr-fernsehen','hr-fernsehen','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28108,NULL,0,0,0),(29112,'28112',NULL,1,'BR-alpha','BR-alpha','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28112,NULL,0,0,0),(29113,'28113',NULL,1,'ŚDWEST Ferns. BW','ŚDWEST Ferns. BW','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28113,NULL,0,0,0),(29114,'28114',NULL,1,'Phoenix','Phoenix','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,33,28114,NULL,0,0,0),(29007,'28007',NULL,1,'3sat','3sat','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28007,NULL,0,0,0),(29012,'28012',NULL,1,'DKULTUR','DKULTUR','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28012,NULL,0,0,0),(29013,'28013',NULL,1,'DLF','DLF','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28013,NULL,0,0,0),(29008,'28008',NULL,1,'KiKa','KiKa','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28008,NULL,0,0,0),(29006,'2',NULL,1,'ZDF','ZDF','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28006,NULL,0,0,0),(29014,'28014',NULL,1,'ZDFdokukanal','ZDFdokukanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28014,NULL,0,0,0),(29011,'28011',NULL,1,'ZDFinfokanal','ZDFinfokanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28011,NULL,0,0,0),(29016,'28016',NULL,1,'ZDFtheaterkanal','ZDFtheaterkanal','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,19,28016,NULL,0,0,0); |
---|
178 | UNLOCK TABLES; |
---|
179 | /*!40000 ALTER TABLE `channel` ENABLE KEYS */; |
---|
180 | |
---|
181 | -- |
---|
182 | -- Table structure for table `codecparams` |
---|
183 | -- |
---|
184 | |
---|
185 | DROP TABLE IF EXISTS `codecparams`; |
---|
186 | CREATE TABLE `codecparams` ( |
---|
187 | `profile` int(10) unsigned NOT NULL default '0', |
---|
188 | `name` varchar(128) NOT NULL default '', |
---|
189 | `value` varchar(128) default NULL, |
---|
190 | PRIMARY KEY (`profile`,`name`) |
---|
191 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
192 | |
---|
193 | -- |
---|
194 | -- Dumping data for table `codecparams` |
---|
195 | -- |
---|
196 | |
---|
197 | |
---|
198 | /*!40000 ALTER TABLE `codecparams` DISABLE KEYS */; |
---|
199 | LOCK TABLES `codecparams` WRITE; |
---|
200 | UNLOCK TABLES; |
---|
201 | /*!40000 ALTER TABLE `codecparams` ENABLE KEYS */; |
---|
202 | |
---|
203 | -- |
---|
204 | -- Table structure for table `credits` |
---|
205 | -- |
---|
206 | |
---|
207 | DROP TABLE IF EXISTS `credits`; |
---|
208 | CREATE TABLE `credits` ( |
---|
209 | `person` mediumint(8) unsigned NOT NULL default '0', |
---|
210 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
211 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
212 | `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '', |
---|
213 | UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), |
---|
214 | KEY `person` (`person`,`role`) |
---|
215 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
216 | |
---|
217 | -- |
---|
218 | -- Dumping data for table `credits` |
---|
219 | -- |
---|
220 | |
---|
221 | |
---|
222 | /*!40000 ALTER TABLE `credits` DISABLE KEYS */; |
---|
223 | LOCK TABLES `credits` WRITE; |
---|
224 | UNLOCK TABLES; |
---|
225 | /*!40000 ALTER TABLE `credits` ENABLE KEYS */; |
---|
226 | |
---|
227 | -- |
---|
228 | -- Table structure for table `customexample` |
---|
229 | -- |
---|
230 | |
---|
231 | DROP TABLE IF EXISTS `customexample`; |
---|
232 | CREATE TABLE `customexample` ( |
---|
233 | `rulename` varchar(64) NOT NULL, |
---|
234 | `fromclause` text NOT NULL, |
---|
235 | `whereclause` text NOT NULL, |
---|
236 | PRIMARY KEY (`rulename`) |
---|
237 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
238 | |
---|
239 | -- |
---|
240 | -- Dumping data for table `customexample` |
---|
241 | -- |
---|
242 | |
---|
243 | |
---|
244 | /*!40000 ALTER TABLE `customexample` DISABLE KEYS */; |
---|
245 | LOCK TABLES `customexample` WRITE; |
---|
246 | UNLOCK TABLES; |
---|
247 | /*!40000 ALTER TABLE `customexample` ENABLE KEYS */; |
---|
248 | |
---|
249 | -- |
---|
250 | -- Table structure for table `diseqc_config` |
---|
251 | -- |
---|
252 | |
---|
253 | DROP TABLE IF EXISTS `diseqc_config`; |
---|
254 | CREATE TABLE `diseqc_config` ( |
---|
255 | `cardinputid` int(10) unsigned NOT NULL, |
---|
256 | `diseqcid` int(10) unsigned NOT NULL, |
---|
257 | `value` varchar(16) NOT NULL default '', |
---|
258 | KEY `id` (`cardinputid`) |
---|
259 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
260 | |
---|
261 | -- |
---|
262 | -- Dumping data for table `diseqc_config` |
---|
263 | -- |
---|
264 | |
---|
265 | |
---|
266 | /*!40000 ALTER TABLE `diseqc_config` DISABLE KEYS */; |
---|
267 | LOCK TABLES `diseqc_config` WRITE; |
---|
268 | UNLOCK TABLES; |
---|
269 | /*!40000 ALTER TABLE `diseqc_config` ENABLE KEYS */; |
---|
270 | |
---|
271 | -- |
---|
272 | -- Table structure for table `diseqc_tree` |
---|
273 | -- |
---|
274 | |
---|
275 | DROP TABLE IF EXISTS `diseqc_tree`; |
---|
276 | CREATE TABLE `diseqc_tree` ( |
---|
277 | `diseqcid` int(10) unsigned NOT NULL auto_increment, |
---|
278 | `parentid` int(10) unsigned default NULL, |
---|
279 | `ordinal` tinyint(3) unsigned NOT NULL, |
---|
280 | `type` varchar(16) NOT NULL default '', |
---|
281 | `subtype` varchar(16) NOT NULL default '', |
---|
282 | `description` varchar(32) NOT NULL default '', |
---|
283 | `switch_ports` tinyint(3) unsigned NOT NULL default '0', |
---|
284 | `rotor_hi_speed` float NOT NULL default '0', |
---|
285 | `rotor_lo_speed` float NOT NULL default '0', |
---|
286 | `rotor_positions` varchar(255) NOT NULL default '', |
---|
287 | `lnb_lof_switch` int(10) NOT NULL default '0', |
---|
288 | `lnb_lof_hi` int(10) NOT NULL default '0', |
---|
289 | `lnb_lof_lo` int(10) NOT NULL default '0', |
---|
290 | PRIMARY KEY (`diseqcid`), |
---|
291 | KEY `parentid` (`parentid`) |
---|
292 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
293 | |
---|
294 | -- |
---|
295 | -- Dumping data for table `diseqc_tree` |
---|
296 | -- |
---|
297 | |
---|
298 | |
---|
299 | /*!40000 ALTER TABLE `diseqc_tree` DISABLE KEYS */; |
---|
300 | LOCK TABLES `diseqc_tree` WRITE; |
---|
301 | INSERT INTO `diseqc_tree` VALUES (1,NULL,0,'lnb','voltage_tone','LNB',0,0,0,'',11700000,10600000,9750000); |
---|
302 | UNLOCK TABLES; |
---|
303 | /*!40000 ALTER TABLE `diseqc_tree` ENABLE KEYS */; |
---|
304 | |
---|
305 | -- |
---|
306 | -- Table structure for table `dtv_multiplex` |
---|
307 | -- |
---|
308 | |
---|
309 | DROP TABLE IF EXISTS `dtv_multiplex`; |
---|
310 | CREATE TABLE `dtv_multiplex` ( |
---|
311 | `mplexid` smallint(6) NOT NULL auto_increment, |
---|
312 | `sourceid` smallint(6) default NULL, |
---|
313 | `transportid` int(11) default NULL, |
---|
314 | `networkid` int(11) default NULL, |
---|
315 | `frequency` int(11) default NULL, |
---|
316 | `inversion` char(1) default 'a', |
---|
317 | `symbolrate` int(11) default NULL, |
---|
318 | `fec` varchar(10) default 'auto', |
---|
319 | `polarity` char(1) default NULL, |
---|
320 | `modulation` varchar(10) default 'auto', |
---|
321 | `bandwidth` char(1) default 'a', |
---|
322 | `lp_code_rate` varchar(10) default 'auto', |
---|
323 | `transmission_mode` char(1) default 'a', |
---|
324 | `guard_interval` varchar(10) default 'auto', |
---|
325 | `visible` smallint(1) NOT NULL default '0', |
---|
326 | `constellation` varchar(10) default 'auto', |
---|
327 | `hierarchy` varchar(10) default 'auto', |
---|
328 | `hp_code_rate` varchar(10) default 'auto', |
---|
329 | `sistandard` varchar(10) default 'dvb', |
---|
330 | `serviceversion` smallint(6) default '33', |
---|
331 | `updatetimestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
---|
332 | PRIMARY KEY (`mplexid`) |
---|
333 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
334 | |
---|
335 | -- |
---|
336 | -- Dumping data for table `dtv_multiplex` |
---|
337 | -- |
---|
338 | |
---|
339 | |
---|
340 | /*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */; |
---|
341 | LOCK TABLES `dtv_multiplex` WRITE; |
---|
342 | INSERT INTO `dtv_multiplex` VALUES (1,1,1,133,12070500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(2,1,2,133,11797500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(3,1,3,133,11719500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(4,1,4,133,12031500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(5,1,5,133,12460500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(6,1,7,133,12148500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(7,1,17,133,11758500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(8,1,33,133,12480000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(9,1,1119,1,12721500,'a',22000000,'2/3','h','auto',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(10,1,1092,1,12246000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(11,1,1024,1,11567500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(12,1,1066,1,11739000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(13,1,1068,1,11778000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(14,1,1070,1,11817000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(15,1,1113,1,12633250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(16,1,1074,1,11895000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(17,1,1076,1,11934000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(18,1,1078,1,11973000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(19,1,1079,1,1359440,NULL,NULL,NULL,NULL,'auto',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',3,'2006-08-09 21:34:04'),(20,1,1080,1,12012000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(21,1,1082,1,12051000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(22,1,1086,1,12129000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:52'),(23,1,1089,1,12187500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(24,1,1059,1,10861750,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(25,1,1090,1,12207000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(26,1,1091,1,12226500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(27,1,1094,1,12285000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(28,1,1095,1,12304500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(29,1,1096,1,12324000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(30,1,1097,53,12343500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(31,1,1098,1,12363050,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(32,1,1099,1,12382500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(33,1,1101,1,11836500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',19,'2006-08-09 21:34:04'),(34,1,1201,1,12421500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(35,1,1100,1,12402000,'a',27500000,'3/4','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(36,1,1105,53,12515250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(37,1,1108,1,12551500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(38,1,1109,53,12574250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(39,1,1073,1,12109500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(40,1,1057,1,10832250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(41,1,1116,1,12669500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(42,1,1111,1,12603750,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(43,1,1008,1,11317500,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(44,1,1026,1,11597000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(45,1,1038,1,11038000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(46,1,1046,1,11156000,'a',22000000,'5/6','v','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(47,1,1279,1,11992500,'a',27500000,'3/4','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'),(48,1,1117,1,12692250,'a',22000000,'5/6','h','qpsk',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'dvb',33,'2006-08-09 21:32:53'); |
---|
343 | UNLOCK TABLES; |
---|
344 | /*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */; |
---|
345 | |
---|
346 | -- |
---|
347 | -- Table structure for table `dtv_privatetypes` |
---|
348 | -- |
---|
349 | |
---|
350 | DROP TABLE IF EXISTS `dtv_privatetypes`; |
---|
351 | CREATE TABLE `dtv_privatetypes` ( |
---|
352 | `sitype` varchar(4) NOT NULL default '', |
---|
353 | `networkid` int(11) NOT NULL default '0', |
---|
354 | `private_type` varchar(20) NOT NULL default '', |
---|
355 | `private_value` varchar(100) NOT NULL default '' |
---|
356 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
357 | |
---|
358 | -- |
---|
359 | -- Dumping data for table `dtv_privatetypes` |
---|
360 | -- |
---|
361 | |
---|
362 | |
---|
363 | /*!40000 ALTER TABLE `dtv_privatetypes` DISABLE KEYS */; |
---|
364 | LOCK TABLES `dtv_privatetypes` WRITE; |
---|
365 | INSERT INTO `dtv_privatetypes` VALUES ('dvb',9018,'channel_numbers','131'),('dvb',9018,'guide_fixup','2'),('dvb',256,'guide_fixup','1'),('dvb',257,'guide_fixup','1'),('dvb',256,'tv_types','1,150,134,133'),('dvb',257,'tv_types','1,150,134,133'),('dvb',4100,'sdt_mapping','1'),('dvb',4101,'sdt_mapping','1'),('dvb',4102,'sdt_mapping','1'),('dvb',4103,'sdt_mapping','1'),('dvb',4104,'sdt_mapping','1'),('dvb',4105,'sdt_mapping','1'),('dvb',4106,'sdt_mapping','1'),('dvb',4107,'sdt_mapping','1'),('dvb',4097,'sdt_mapping','1'),('dvb',4098,'sdt_mapping','1'),('dvb',4100,'tv_types','1,145,154'),('dvb',4101,'tv_types','1,145,154'),('dvb',4102,'tv_types','1,145,154'),('dvb',4103,'tv_types','1,145,154'),('dvb',4104,'tv_types','1,145,154'),('dvb',4105,'tv_types','1,145,154'),('dvb',4106,'tv_types','1,145,154'),('dvb',4107,'tv_types','1,145,154'),('dvb',4097,'tv_types','1,145,154'),('dvb',4098,'tv_types','1,145,154'),('dvb',4100,'guide_fixup','1'),('dvb',4101,'guide_fixup','1'),('dvb',4102,'guide_fixup','1'),('dvb',4103,'guide_fixup','1'),('dvb',4104,'guide_fixup','1'),('dvb',4105,'guide_fixup','1'),('dvb',4106,'guide_fixup','1'),('dvb',4107,'guide_fixup','1'),('dvb',4096,'guide_fixup','5'),('dvb',4097,'guide_fixup','1'),('dvb',4098,'guide_fixup','1'),('dvb',94,'tv_types','1,128'),('atsc',1793,'guide_fixup','3'),('dvb',40999,'guide_fixup','4'),('dvb',70,'force_guide_present','yes'),('dvb',70,'guide_ranges','80,80,96,96'),('dvb',4112,'channel_numbers','131'),('dvb',4115,'channel_numbers','131'),('dvb',4116,'channel_numbers','131'),('dvb',12802,'channel_numbers','131'),('dvb',12803,'channel_numbers','131'),('dvb',12829,'channel_numbers','131'),('dvb',40999,'parse_subtitle_list','1070,1308,1041,1306,1307,1030,1016,1131,1068,1069'),('dvb',4096,'guide_fixup','5'); |
---|
366 | UNLOCK TABLES; |
---|
367 | /*!40000 ALTER TABLE `dtv_privatetypes` ENABLE KEYS */; |
---|
368 | |
---|
369 | -- |
---|
370 | -- Table structure for table `eit_cache` |
---|
371 | -- |
---|
372 | |
---|
373 | DROP TABLE IF EXISTS `eit_cache`; |
---|
374 | CREATE TABLE `eit_cache` ( |
---|
375 | `chanid` int(10) NOT NULL, |
---|
376 | `eventid` smallint(5) unsigned NOT NULL, |
---|
377 | `tableid` tinyint(3) unsigned NOT NULL, |
---|
378 | `version` tinyint(3) unsigned NOT NULL, |
---|
379 | `endtime` int(10) unsigned NOT NULL, |
---|
380 | PRIMARY KEY (`chanid`,`eventid`) |
---|
381 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
382 | |
---|
383 | -- |
---|
384 | -- Dumping data for table `eit_cache` |
---|
385 | -- |
---|
386 | |
---|
387 | |
---|
388 | /*!40000 ALTER TABLE `eit_cache` DISABLE KEYS */; |
---|
389 | LOCK TABLES `eit_cache` WRITE; |
---|
390 | UNLOCK TABLES; |
---|
391 | /*!40000 ALTER TABLE `eit_cache` ENABLE KEYS */; |
---|
392 | |
---|
393 | -- |
---|
394 | -- Table structure for table `favorites` |
---|
395 | -- |
---|
396 | |
---|
397 | DROP TABLE IF EXISTS `favorites`; |
---|
398 | CREATE TABLE `favorites` ( |
---|
399 | `favid` int(11) unsigned NOT NULL auto_increment, |
---|
400 | `userid` int(11) unsigned NOT NULL default '0', |
---|
401 | `chanid` int(11) unsigned NOT NULL default '0', |
---|
402 | PRIMARY KEY (`favid`) |
---|
403 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
404 | |
---|
405 | -- |
---|
406 | -- Dumping data for table `favorites` |
---|
407 | -- |
---|
408 | |
---|
409 | |
---|
410 | /*!40000 ALTER TABLE `favorites` DISABLE KEYS */; |
---|
411 | LOCK TABLES `favorites` WRITE; |
---|
412 | UNLOCK TABLES; |
---|
413 | /*!40000 ALTER TABLE `favorites` ENABLE KEYS */; |
---|
414 | |
---|
415 | -- |
---|
416 | -- Table structure for table `housekeeping` |
---|
417 | -- |
---|
418 | |
---|
419 | DROP TABLE IF EXISTS `housekeeping`; |
---|
420 | CREATE TABLE `housekeeping` ( |
---|
421 | `tag` varchar(64) NOT NULL default '', |
---|
422 | `lastrun` datetime default NULL, |
---|
423 | PRIMARY KEY (`tag`) |
---|
424 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
425 | |
---|
426 | -- |
---|
427 | -- Dumping data for table `housekeeping` |
---|
428 | -- |
---|
429 | |
---|
430 | |
---|
431 | /*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */; |
---|
432 | LOCK TABLES `housekeeping` WRITE; |
---|
433 | UNLOCK TABLES; |
---|
434 | /*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */; |
---|
435 | |
---|
436 | -- |
---|
437 | -- Table structure for table `inuseprograms` |
---|
438 | -- |
---|
439 | |
---|
440 | DROP TABLE IF EXISTS `inuseprograms`; |
---|
441 | CREATE TABLE `inuseprograms` ( |
---|
442 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
443 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
444 | `recusage` varchar(128) NOT NULL default '', |
---|
445 | `lastupdatetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
446 | `hostname` varchar(255) NOT NULL default '', |
---|
447 | KEY `chanid` (`chanid`,`starttime`) |
---|
448 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
449 | |
---|
450 | -- |
---|
451 | -- Dumping data for table `inuseprograms` |
---|
452 | -- |
---|
453 | |
---|
454 | |
---|
455 | /*!40000 ALTER TABLE `inuseprograms` DISABLE KEYS */; |
---|
456 | LOCK TABLES `inuseprograms` WRITE; |
---|
457 | UNLOCK TABLES; |
---|
458 | /*!40000 ALTER TABLE `inuseprograms` ENABLE KEYS */; |
---|
459 | |
---|
460 | -- |
---|
461 | -- Table structure for table `jobqueue` |
---|
462 | -- |
---|
463 | |
---|
464 | DROP TABLE IF EXISTS `jobqueue`; |
---|
465 | CREATE TABLE `jobqueue` ( |
---|
466 | `id` int(11) NOT NULL auto_increment, |
---|
467 | `chanid` int(10) NOT NULL default '0', |
---|
468 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
469 | `inserttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
470 | `type` int(11) NOT NULL default '0', |
---|
471 | `cmds` int(11) NOT NULL default '0', |
---|
472 | `flags` int(11) NOT NULL default '0', |
---|
473 | `status` int(11) NOT NULL default '0', |
---|
474 | `statustime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
---|
475 | `hostname` varchar(255) NOT NULL default '', |
---|
476 | `args` blob NOT NULL, |
---|
477 | `comment` varchar(128) NOT NULL default '', |
---|
478 | PRIMARY KEY (`id`), |
---|
479 | UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`) |
---|
480 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
481 | |
---|
482 | -- |
---|
483 | -- Dumping data for table `jobqueue` |
---|
484 | -- |
---|
485 | |
---|
486 | |
---|
487 | /*!40000 ALTER TABLE `jobqueue` DISABLE KEYS */; |
---|
488 | LOCK TABLES `jobqueue` WRITE; |
---|
489 | UNLOCK TABLES; |
---|
490 | /*!40000 ALTER TABLE `jobqueue` ENABLE KEYS */; |
---|
491 | |
---|
492 | -- |
---|
493 | -- Table structure for table `jumppoints` |
---|
494 | -- |
---|
495 | |
---|
496 | DROP TABLE IF EXISTS `jumppoints`; |
---|
497 | CREATE TABLE `jumppoints` ( |
---|
498 | `destination` varchar(128) NOT NULL default '', |
---|
499 | `description` varchar(255) default NULL, |
---|
500 | `keylist` varchar(128) default NULL, |
---|
501 | `hostname` varchar(255) NOT NULL default '', |
---|
502 | PRIMARY KEY (`destination`,`hostname`) |
---|
503 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
504 | |
---|
505 | -- |
---|
506 | -- Dumping data for table `jumppoints` |
---|
507 | -- |
---|
508 | |
---|
509 | |
---|
510 | /*!40000 ALTER TABLE `jumppoints` DISABLE KEYS */; |
---|
511 | LOCK TABLES `jumppoints` WRITE; |
---|
512 | UNLOCK TABLES; |
---|
513 | /*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */; |
---|
514 | |
---|
515 | -- |
---|
516 | -- Table structure for table `keybindings` |
---|
517 | -- |
---|
518 | |
---|
519 | DROP TABLE IF EXISTS `keybindings`; |
---|
520 | CREATE TABLE `keybindings` ( |
---|
521 | `context` varchar(32) NOT NULL default '', |
---|
522 | `action` varchar(32) NOT NULL default '', |
---|
523 | `description` varchar(255) default NULL, |
---|
524 | `keylist` varchar(128) default NULL, |
---|
525 | `hostname` varchar(255) NOT NULL default '', |
---|
526 | PRIMARY KEY (`context`,`action`,`hostname`) |
---|
527 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
528 | |
---|
529 | -- |
---|
530 | -- Dumping data for table `keybindings` |
---|
531 | -- |
---|
532 | |
---|
533 | |
---|
534 | /*!40000 ALTER TABLE `keybindings` DISABLE KEYS */; |
---|
535 | LOCK TABLES `keybindings` WRITE; |
---|
536 | INSERT INTO `keybindings` VALUES ('Global','UP','Up Arrow','Up','zenslack'),('Global','DOWN','Down Arrow','Down','zenslack'),('Global','LEFT','Left Arrow','Left','zenslack'),('Global','RIGHT','Right Arrow','Right','zenslack'),('Global','SELECT','Select','Return,Enter,Space','zenslack'),('Global','ESCAPE','Escape','Esc','zenslack'),('Global','MENU','Pop-up menu','M','zenslack'),('Global','INFO','More information','I','zenslack'),('Global','PAGEUP','Page Up','PgUp','zenslack'),('Global','PAGEDOWN','Page Down','PgDown','zenslack'),('Global','PREVVIEW','Previous View','Home','zenslack'),('Global','NEXTVIEW','Next View','End','zenslack'),('Global','HELP','Help','F1','zenslack'),('Global','EJECT','Eject Removable Media','','zenslack'),('Global','0','0','0','zenslack'),('Global','1','1','1','zenslack'),('Global','2','2','2','zenslack'),('Global','3','3','3','zenslack'),('Global','4','4','4','zenslack'),('Global','5','5','5','zenslack'),('Global','6','6','6','zenslack'),('Global','7','7','7','zenslack'),('Global','8','8','8','zenslack'),('Global','9','9','9','zenslack'),('qt','DELETE','Delete','D','zenslack'),('qt','EDIT','Edit','E','zenslack'); |
---|
537 | UNLOCK TABLES; |
---|
538 | /*!40000 ALTER TABLE `keybindings` ENABLE KEYS */; |
---|
539 | |
---|
540 | -- |
---|
541 | -- Table structure for table `keyword` |
---|
542 | -- |
---|
543 | |
---|
544 | DROP TABLE IF EXISTS `keyword`; |
---|
545 | CREATE TABLE `keyword` ( |
---|
546 | `phrase` varchar(128) NOT NULL default '', |
---|
547 | `searchtype` int(10) unsigned NOT NULL default '3', |
---|
548 | UNIQUE KEY `phrase` (`phrase`,`searchtype`) |
---|
549 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
550 | |
---|
551 | -- |
---|
552 | -- Dumping data for table `keyword` |
---|
553 | -- |
---|
554 | |
---|
555 | |
---|
556 | /*!40000 ALTER TABLE `keyword` DISABLE KEYS */; |
---|
557 | LOCK TABLES `keyword` WRITE; |
---|
558 | UNLOCK TABLES; |
---|
559 | /*!40000 ALTER TABLE `keyword` ENABLE KEYS */; |
---|
560 | |
---|
561 | -- |
---|
562 | -- Table structure for table `mythlog` |
---|
563 | -- |
---|
564 | |
---|
565 | DROP TABLE IF EXISTS `mythlog`; |
---|
566 | CREATE TABLE `mythlog` ( |
---|
567 | `logid` int(10) unsigned NOT NULL auto_increment, |
---|
568 | `module` varchar(32) NOT NULL default '', |
---|
569 | `priority` int(11) NOT NULL default '0', |
---|
570 | `acknowledged` tinyint(1) default '0', |
---|
571 | `logdate` datetime default NULL, |
---|
572 | `host` varchar(128) default NULL, |
---|
573 | `message` varchar(255) NOT NULL default '', |
---|
574 | `details` text, |
---|
575 | PRIMARY KEY (`logid`) |
---|
576 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
577 | |
---|
578 | -- |
---|
579 | -- Dumping data for table `mythlog` |
---|
580 | -- |
---|
581 | |
---|
582 | |
---|
583 | /*!40000 ALTER TABLE `mythlog` DISABLE KEYS */; |
---|
584 | LOCK TABLES `mythlog` WRITE; |
---|
585 | UNLOCK TABLES; |
---|
586 | /*!40000 ALTER TABLE `mythlog` ENABLE KEYS */; |
---|
587 | |
---|
588 | -- |
---|
589 | -- Table structure for table `networkiconmap` |
---|
590 | -- |
---|
591 | |
---|
592 | DROP TABLE IF EXISTS `networkiconmap`; |
---|
593 | CREATE TABLE `networkiconmap` ( |
---|
594 | `id` int(11) NOT NULL auto_increment, |
---|
595 | `network` varchar(20) NOT NULL default '', |
---|
596 | `url` varchar(255) NOT NULL default '', |
---|
597 | PRIMARY KEY (`id`), |
---|
598 | UNIQUE KEY `network` (`network`) |
---|
599 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
600 | |
---|
601 | -- |
---|
602 | -- Dumping data for table `networkiconmap` |
---|
603 | -- |
---|
604 | |
---|
605 | |
---|
606 | /*!40000 ALTER TABLE `networkiconmap` DISABLE KEYS */; |
---|
607 | LOCK TABLES `networkiconmap` WRITE; |
---|
608 | UNLOCK TABLES; |
---|
609 | /*!40000 ALTER TABLE `networkiconmap` ENABLE KEYS */; |
---|
610 | |
---|
611 | -- |
---|
612 | -- Table structure for table `oldfind` |
---|
613 | -- |
---|
614 | |
---|
615 | DROP TABLE IF EXISTS `oldfind`; |
---|
616 | CREATE TABLE `oldfind` ( |
---|
617 | `recordid` int(11) NOT NULL default '0', |
---|
618 | `findid` int(11) NOT NULL default '0', |
---|
619 | PRIMARY KEY (`recordid`,`findid`) |
---|
620 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
621 | |
---|
622 | -- |
---|
623 | -- Dumping data for table `oldfind` |
---|
624 | -- |
---|
625 | |
---|
626 | |
---|
627 | /*!40000 ALTER TABLE `oldfind` DISABLE KEYS */; |
---|
628 | LOCK TABLES `oldfind` WRITE; |
---|
629 | UNLOCK TABLES; |
---|
630 | /*!40000 ALTER TABLE `oldfind` ENABLE KEYS */; |
---|
631 | |
---|
632 | -- |
---|
633 | -- Table structure for table `oldprogram` |
---|
634 | -- |
---|
635 | |
---|
636 | DROP TABLE IF EXISTS `oldprogram`; |
---|
637 | CREATE TABLE `oldprogram` ( |
---|
638 | `oldtitle` varchar(128) NOT NULL default '', |
---|
639 | `airdate` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
640 | PRIMARY KEY (`oldtitle`) |
---|
641 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
642 | |
---|
643 | -- |
---|
644 | -- Dumping data for table `oldprogram` |
---|
645 | -- |
---|
646 | |
---|
647 | |
---|
648 | /*!40000 ALTER TABLE `oldprogram` DISABLE KEYS */; |
---|
649 | LOCK TABLES `oldprogram` WRITE; |
---|
650 | UNLOCK TABLES; |
---|
651 | /*!40000 ALTER TABLE `oldprogram` ENABLE KEYS */; |
---|
652 | |
---|
653 | -- |
---|
654 | -- Table structure for table `oldrecorded` |
---|
655 | -- |
---|
656 | |
---|
657 | DROP TABLE IF EXISTS `oldrecorded`; |
---|
658 | CREATE TABLE `oldrecorded` ( |
---|
659 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
660 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
661 | `endtime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
662 | `title` varchar(128) NOT NULL default '', |
---|
663 | `subtitle` varchar(128) NOT NULL default '', |
---|
664 | `description` text NOT NULL, |
---|
665 | `category` varchar(64) NOT NULL default '', |
---|
666 | `seriesid` varchar(12) NOT NULL default '', |
---|
667 | `programid` varchar(20) NOT NULL default '', |
---|
668 | `findid` int(11) NOT NULL default '0', |
---|
669 | `recordid` int(11) NOT NULL default '0', |
---|
670 | `station` varchar(20) NOT NULL default '', |
---|
671 | `rectype` int(10) unsigned NOT NULL default '0', |
---|
672 | `duplicate` tinyint(1) NOT NULL default '0', |
---|
673 | `recstatus` int(11) NOT NULL default '0', |
---|
674 | `reactivate` smallint(6) NOT NULL default '0', |
---|
675 | `generic` tinyint(1) default '0', |
---|
676 | PRIMARY KEY (`station`,`starttime`,`title`), |
---|
677 | KEY `endtime` (`endtime`), |
---|
678 | KEY `title` (`title`), |
---|
679 | KEY `seriesid` (`seriesid`), |
---|
680 | KEY `programid` (`programid`), |
---|
681 | KEY `recordid` (`recordid`), |
---|
682 | KEY `recstatus` (`recstatus`,`programid`,`seriesid`), |
---|
683 | KEY `recstatus_2` (`recstatus`,`title`,`subtitle`) |
---|
684 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
685 | |
---|
686 | -- |
---|
687 | -- Dumping data for table `oldrecorded` |
---|
688 | -- |
---|
689 | |
---|
690 | |
---|
691 | /*!40000 ALTER TABLE `oldrecorded` DISABLE KEYS */; |
---|
692 | LOCK TABLES `oldrecorded` WRITE; |
---|
693 | UNLOCK TABLES; |
---|
694 | /*!40000 ALTER TABLE `oldrecorded` ENABLE KEYS */; |
---|
695 | |
---|
696 | -- |
---|
697 | -- Table structure for table `people` |
---|
698 | -- |
---|
699 | |
---|
700 | DROP TABLE IF EXISTS `people`; |
---|
701 | CREATE TABLE `people` ( |
---|
702 | `person` mediumint(8) unsigned NOT NULL auto_increment, |
---|
703 | `name` char(128) NOT NULL default '', |
---|
704 | PRIMARY KEY (`person`), |
---|
705 | UNIQUE KEY `name` (`name`(41)) |
---|
706 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
707 | |
---|
708 | -- |
---|
709 | -- Dumping data for table `people` |
---|
710 | -- |
---|
711 | |
---|
712 | |
---|
713 | /*!40000 ALTER TABLE `people` DISABLE KEYS */; |
---|
714 | LOCK TABLES `people` WRITE; |
---|
715 | UNLOCK TABLES; |
---|
716 | /*!40000 ALTER TABLE `people` ENABLE KEYS */; |
---|
717 | |
---|
718 | -- |
---|
719 | -- Table structure for table `pidcache` |
---|
720 | -- |
---|
721 | |
---|
722 | DROP TABLE IF EXISTS `pidcache`; |
---|
723 | CREATE TABLE `pidcache` ( |
---|
724 | `chanid` smallint(6) NOT NULL default '0', |
---|
725 | `pid` int(11) NOT NULL default '-1', |
---|
726 | `tableid` int(11) NOT NULL default '-1', |
---|
727 | KEY `chanid` (`chanid`) |
---|
728 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
729 | |
---|
730 | -- |
---|
731 | -- Dumping data for table `pidcache` |
---|
732 | -- |
---|
733 | |
---|
734 | |
---|
735 | /*!40000 ALTER TABLE `pidcache` DISABLE KEYS */; |
---|
736 | LOCK TABLES `pidcache` WRITE; |
---|
737 | UNLOCK TABLES; |
---|
738 | /*!40000 ALTER TABLE `pidcache` ENABLE KEYS */; |
---|
739 | |
---|
740 | -- |
---|
741 | -- Table structure for table `playgroup` |
---|
742 | -- |
---|
743 | |
---|
744 | DROP TABLE IF EXISTS `playgroup`; |
---|
745 | CREATE TABLE `playgroup` ( |
---|
746 | `name` varchar(32) NOT NULL default '', |
---|
747 | `titlematch` varchar(255) NOT NULL default '', |
---|
748 | `skipahead` int(11) NOT NULL default '0', |
---|
749 | `skipback` int(11) NOT NULL default '0', |
---|
750 | `timestretch` int(11) NOT NULL default '0', |
---|
751 | `jump` int(11) NOT NULL default '0', |
---|
752 | PRIMARY KEY (`name`) |
---|
753 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
754 | |
---|
755 | -- |
---|
756 | -- Dumping data for table `playgroup` |
---|
757 | -- |
---|
758 | |
---|
759 | |
---|
760 | /*!40000 ALTER TABLE `playgroup` DISABLE KEYS */; |
---|
761 | LOCK TABLES `playgroup` WRITE; |
---|
762 | INSERT INTO `playgroup` VALUES ('Default','',30,5,100,0); |
---|
763 | UNLOCK TABLES; |
---|
764 | /*!40000 ALTER TABLE `playgroup` ENABLE KEYS */; |
---|
765 | |
---|
766 | -- |
---|
767 | -- Table structure for table `profilegroups` |
---|
768 | -- |
---|
769 | |
---|
770 | DROP TABLE IF EXISTS `profilegroups`; |
---|
771 | CREATE TABLE `profilegroups` ( |
---|
772 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
773 | `name` varchar(128) default NULL, |
---|
774 | `cardtype` varchar(32) NOT NULL default 'V4L', |
---|
775 | `is_default` int(1) default '0', |
---|
776 | `hostname` varchar(255) default NULL, |
---|
777 | PRIMARY KEY (`id`), |
---|
778 | UNIQUE KEY `name` (`name`,`hostname`) |
---|
779 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
780 | |
---|
781 | -- |
---|
782 | -- Dumping data for table `profilegroups` |
---|
783 | -- |
---|
784 | |
---|
785 | |
---|
786 | /*!40000 ALTER TABLE `profilegroups` DISABLE KEYS */; |
---|
787 | LOCK TABLES `profilegroups` WRITE; |
---|
788 | INSERT INTO `profilegroups` VALUES (1,'Software Encoders (v4l based)','V4L',1,NULL),(2,'MPEG-2 Encoders (PVR-x50, PVR-500)','MPEG',1,NULL),(3,'Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc)','MJPEG',1,NULL),(4,'Hardware HDTV','HDTV',1,NULL),(5,'Hardware DVB Encoders','DVB',1,NULL),(6,'Transcoders','TRANSCODE',1,NULL),(7,'FireWire Input','FIREWIRE',1,NULL),(8,'USB Mpeg-4 Encoder (Plextor ConvertX, etc)','GO7007',1,NULL),(9,'DBOX2 Input','DBOX2',1,NULL),(10,'Freebox Input','Freebox',1,NULL),(11,'HDHomeRun Recorders','HDHOMERUN',1,NULL),(12,'CRC IP Recorders','CRC_IP',1,NULL); |
---|
789 | UNLOCK TABLES; |
---|
790 | /*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */; |
---|
791 | |
---|
792 | -- |
---|
793 | -- Table structure for table `program` |
---|
794 | -- |
---|
795 | |
---|
796 | DROP TABLE IF EXISTS `program`; |
---|
797 | CREATE TABLE `program` ( |
---|
798 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
799 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
800 | `endtime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
801 | `title` varchar(128) NOT NULL default '', |
---|
802 | `subtitle` varchar(128) NOT NULL default '', |
---|
803 | `description` text NOT NULL, |
---|
804 | `category` varchar(64) NOT NULL default '', |
---|
805 | `category_type` varchar(64) NOT NULL default '', |
---|
806 | `airdate` year(4) NOT NULL default '0000', |
---|
807 | `stars` float NOT NULL default '0', |
---|
808 | `previouslyshown` tinyint(4) NOT NULL default '0', |
---|
809 | `title_pronounce` varchar(128) NOT NULL default '', |
---|
810 | `stereo` tinyint(1) NOT NULL default '0', |
---|
811 | `subtitled` tinyint(1) NOT NULL default '0', |
---|
812 | `hdtv` tinyint(1) NOT NULL default '0', |
---|
813 | `closecaptioned` tinyint(1) NOT NULL default '0', |
---|
814 | `partnumber` int(11) NOT NULL default '0', |
---|
815 | `parttotal` int(11) NOT NULL default '0', |
---|
816 | `seriesid` varchar(12) NOT NULL default '', |
---|
817 | `originalairdate` date default NULL, |
---|
818 | `showtype` varchar(30) NOT NULL default '', |
---|
819 | `colorcode` varchar(20) NOT NULL default '', |
---|
820 | `syndicatedepisodenumber` varchar(20) NOT NULL default '', |
---|
821 | `programid` varchar(20) NOT NULL default '', |
---|
822 | `manualid` int(10) unsigned NOT NULL default '0', |
---|
823 | `generic` tinyint(1) default '0', |
---|
824 | `listingsource` int(11) NOT NULL default '0', |
---|
825 | `first` tinyint(1) NOT NULL default '0', |
---|
826 | `last` tinyint(1) NOT NULL default '0', |
---|
827 | PRIMARY KEY (`chanid`,`starttime`,`manualid`), |
---|
828 | KEY `endtime` (`endtime`), |
---|
829 | KEY `title` (`title`), |
---|
830 | KEY `title_pronounce` (`title_pronounce`), |
---|
831 | KEY `seriesid` (`seriesid`), |
---|
832 | KEY `programid` (`programid`), |
---|
833 | KEY `id_start_end` (`chanid`,`starttime`,`endtime`) |
---|
834 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
835 | |
---|
836 | -- |
---|
837 | -- Dumping data for table `program` |
---|
838 | -- |
---|
839 | |
---|
840 | |
---|
841 | /*!40000 ALTER TABLE `program` DISABLE KEYS */; |
---|
842 | LOCK TABLES `program` WRITE; |
---|
843 | UNLOCK TABLES; |
---|
844 | /*!40000 ALTER TABLE `program` ENABLE KEYS */; |
---|
845 | |
---|
846 | -- |
---|
847 | -- Table structure for table `programgenres` |
---|
848 | -- |
---|
849 | |
---|
850 | DROP TABLE IF EXISTS `programgenres`; |
---|
851 | CREATE TABLE `programgenres` ( |
---|
852 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
853 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
854 | `relevance` char(1) NOT NULL default '', |
---|
855 | `genre` char(30) default NULL, |
---|
856 | PRIMARY KEY (`chanid`,`starttime`,`relevance`), |
---|
857 | KEY `genre` (`genre`) |
---|
858 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
859 | |
---|
860 | -- |
---|
861 | -- Dumping data for table `programgenres` |
---|
862 | -- |
---|
863 | |
---|
864 | |
---|
865 | /*!40000 ALTER TABLE `programgenres` DISABLE KEYS */; |
---|
866 | LOCK TABLES `programgenres` WRITE; |
---|
867 | UNLOCK TABLES; |
---|
868 | /*!40000 ALTER TABLE `programgenres` ENABLE KEYS */; |
---|
869 | |
---|
870 | -- |
---|
871 | -- Table structure for table `programrating` |
---|
872 | -- |
---|
873 | |
---|
874 | DROP TABLE IF EXISTS `programrating`; |
---|
875 | CREATE TABLE `programrating` ( |
---|
876 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
877 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
878 | `system` char(8) NOT NULL default '', |
---|
879 | `rating` char(8) NOT NULL default '', |
---|
880 | UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), |
---|
881 | KEY `starttime` (`starttime`,`system`) |
---|
882 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
883 | |
---|
884 | -- |
---|
885 | -- Dumping data for table `programrating` |
---|
886 | -- |
---|
887 | |
---|
888 | |
---|
889 | /*!40000 ALTER TABLE `programrating` DISABLE KEYS */; |
---|
890 | LOCK TABLES `programrating` WRITE; |
---|
891 | UNLOCK TABLES; |
---|
892 | /*!40000 ALTER TABLE `programrating` ENABLE KEYS */; |
---|
893 | |
---|
894 | -- |
---|
895 | -- Table structure for table `recgrouppassword` |
---|
896 | -- |
---|
897 | |
---|
898 | DROP TABLE IF EXISTS `recgrouppassword`; |
---|
899 | CREATE TABLE `recgrouppassword` ( |
---|
900 | `recgroup` varchar(32) NOT NULL default '', |
---|
901 | `password` varchar(10) NOT NULL default '', |
---|
902 | PRIMARY KEY (`recgroup`), |
---|
903 | UNIQUE KEY `recgroup` (`recgroup`) |
---|
904 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
905 | |
---|
906 | -- |
---|
907 | -- Dumping data for table `recgrouppassword` |
---|
908 | -- |
---|
909 | |
---|
910 | |
---|
911 | /*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */; |
---|
912 | LOCK TABLES `recgrouppassword` WRITE; |
---|
913 | UNLOCK TABLES; |
---|
914 | /*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */; |
---|
915 | |
---|
916 | -- |
---|
917 | -- Table structure for table `record` |
---|
918 | -- |
---|
919 | |
---|
920 | DROP TABLE IF EXISTS `record`; |
---|
921 | CREATE TABLE `record` ( |
---|
922 | `recordid` int(10) unsigned NOT NULL auto_increment, |
---|
923 | `type` int(10) unsigned NOT NULL default '0', |
---|
924 | `chanid` int(10) unsigned default NULL, |
---|
925 | `starttime` time NOT NULL default '00:00:00', |
---|
926 | `startdate` date NOT NULL default '0000-00-00', |
---|
927 | `endtime` time NOT NULL default '00:00:00', |
---|
928 | `enddate` date NOT NULL default '0000-00-00', |
---|
929 | `title` varchar(128) NOT NULL default '', |
---|
930 | `subtitle` varchar(128) NOT NULL default '', |
---|
931 | `description` text NOT NULL, |
---|
932 | `category` varchar(64) NOT NULL default '', |
---|
933 | `profile` varchar(128) NOT NULL default 'Default', |
---|
934 | `recpriority` int(10) NOT NULL default '0', |
---|
935 | `autoexpire` int(11) NOT NULL default '0', |
---|
936 | `maxepisodes` int(11) NOT NULL default '0', |
---|
937 | `maxnewest` int(11) NOT NULL default '0', |
---|
938 | `startoffset` int(11) NOT NULL default '0', |
---|
939 | `endoffset` int(11) NOT NULL default '0', |
---|
940 | `recgroup` varchar(32) NOT NULL default 'Default', |
---|
941 | `dupmethod` int(11) NOT NULL default '6', |
---|
942 | `dupin` int(11) NOT NULL default '15', |
---|
943 | `station` varchar(20) NOT NULL default '', |
---|
944 | `seriesid` varchar(12) NOT NULL default '', |
---|
945 | `programid` varchar(20) NOT NULL default '', |
---|
946 | `search` int(10) unsigned NOT NULL default '0', |
---|
947 | `autotranscode` tinyint(1) NOT NULL default '0', |
---|
948 | `autocommflag` tinyint(1) NOT NULL default '0', |
---|
949 | `autouserjob1` tinyint(1) NOT NULL default '0', |
---|
950 | `autouserjob2` tinyint(1) NOT NULL default '0', |
---|
951 | `autouserjob3` tinyint(1) NOT NULL default '0', |
---|
952 | `autouserjob4` tinyint(1) NOT NULL default '0', |
---|
953 | `findday` tinyint(4) NOT NULL default '0', |
---|
954 | `findtime` time NOT NULL default '00:00:00', |
---|
955 | `findid` int(11) NOT NULL default '0', |
---|
956 | `inactive` tinyint(1) NOT NULL default '0', |
---|
957 | `parentid` int(11) NOT NULL default '0', |
---|
958 | `transcoder` int(11) NOT NULL default '0', |
---|
959 | `tsdefault` float NOT NULL default '1', |
---|
960 | `playgroup` varchar(32) NOT NULL default 'Default', |
---|
961 | `prefinput` int(10) NOT NULL default '0', |
---|
962 | PRIMARY KEY (`recordid`), |
---|
963 | KEY `chanid` (`chanid`,`starttime`), |
---|
964 | KEY `title` (`title`), |
---|
965 | KEY `seriesid` (`seriesid`), |
---|
966 | KEY `programid` (`programid`) |
---|
967 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
968 | |
---|
969 | -- |
---|
970 | -- Dumping data for table `record` |
---|
971 | -- |
---|
972 | |
---|
973 | |
---|
974 | /*!40000 ALTER TABLE `record` DISABLE KEYS */; |
---|
975 | LOCK TABLES `record` WRITE; |
---|
976 | UNLOCK TABLES; |
---|
977 | /*!40000 ALTER TABLE `record` ENABLE KEYS */; |
---|
978 | |
---|
979 | -- |
---|
980 | -- Table structure for table `recorded` |
---|
981 | -- |
---|
982 | |
---|
983 | DROP TABLE IF EXISTS `recorded`; |
---|
984 | CREATE TABLE `recorded` ( |
---|
985 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
986 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
987 | `endtime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
988 | `title` varchar(128) NOT NULL default '', |
---|
989 | `subtitle` varchar(128) NOT NULL default '', |
---|
990 | `description` text NOT NULL, |
---|
991 | `category` varchar(64) NOT NULL default '', |
---|
992 | `hostname` varchar(255) NOT NULL default '', |
---|
993 | `bookmark` tinyint(1) NOT NULL default '0', |
---|
994 | `editing` int(10) unsigned NOT NULL default '0', |
---|
995 | `cutlist` tinyint(1) NOT NULL default '0', |
---|
996 | `autoexpire` int(11) NOT NULL default '0', |
---|
997 | `commflagged` int(10) unsigned NOT NULL default '0', |
---|
998 | `recgroup` varchar(32) NOT NULL default 'Default', |
---|
999 | `recordid` int(11) default NULL, |
---|
1000 | `seriesid` varchar(12) NOT NULL default '', |
---|
1001 | `programid` varchar(20) NOT NULL default '', |
---|
1002 | `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
---|
1003 | `filesize` bigint(20) NOT NULL default '0', |
---|
1004 | `stars` float NOT NULL default '0', |
---|
1005 | `previouslyshown` tinyint(1) default '0', |
---|
1006 | `originalairdate` date default NULL, |
---|
1007 | `preserve` tinyint(1) NOT NULL default '0', |
---|
1008 | `findid` int(11) NOT NULL default '0', |
---|
1009 | `deletepending` tinyint(1) NOT NULL default '0', |
---|
1010 | `transcoder` int(11) NOT NULL default '0', |
---|
1011 | `timestretch` float NOT NULL default '1', |
---|
1012 | `recpriority` int(11) NOT NULL default '0', |
---|
1013 | `basename` varchar(128) NOT NULL default '', |
---|
1014 | `progstart` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1015 | `progend` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1016 | `playgroup` varchar(32) NOT NULL default 'Default', |
---|
1017 | `profile` varchar(32) NOT NULL default '', |
---|
1018 | `duplicate` tinyint(1) NOT NULL default '0', |
---|
1019 | `transcoded` tinyint(1) NOT NULL default '0', |
---|
1020 | PRIMARY KEY (`chanid`,`starttime`), |
---|
1021 | KEY `endtime` (`endtime`), |
---|
1022 | KEY `seriesid` (`seriesid`), |
---|
1023 | KEY `programid` (`programid`), |
---|
1024 | KEY `title` (`title`), |
---|
1025 | KEY `recordid` (`recordid`) |
---|
1026 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1027 | |
---|
1028 | -- |
---|
1029 | -- Dumping data for table `recorded` |
---|
1030 | -- |
---|
1031 | |
---|
1032 | |
---|
1033 | /*!40000 ALTER TABLE `recorded` DISABLE KEYS */; |
---|
1034 | LOCK TABLES `recorded` WRITE; |
---|
1035 | UNLOCK TABLES; |
---|
1036 | /*!40000 ALTER TABLE `recorded` ENABLE KEYS */; |
---|
1037 | |
---|
1038 | -- |
---|
1039 | -- Table structure for table `recordedcredits` |
---|
1040 | -- |
---|
1041 | |
---|
1042 | DROP TABLE IF EXISTS `recordedcredits`; |
---|
1043 | CREATE TABLE `recordedcredits` ( |
---|
1044 | `person` mediumint(8) unsigned NOT NULL default '0', |
---|
1045 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1046 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1047 | `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '', |
---|
1048 | UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), |
---|
1049 | KEY `person` (`person`,`role`) |
---|
1050 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1051 | |
---|
1052 | -- |
---|
1053 | -- Dumping data for table `recordedcredits` |
---|
1054 | -- |
---|
1055 | |
---|
1056 | |
---|
1057 | /*!40000 ALTER TABLE `recordedcredits` DISABLE KEYS */; |
---|
1058 | LOCK TABLES `recordedcredits` WRITE; |
---|
1059 | UNLOCK TABLES; |
---|
1060 | /*!40000 ALTER TABLE `recordedcredits` ENABLE KEYS */; |
---|
1061 | |
---|
1062 | -- |
---|
1063 | -- Table structure for table `recordedmarkup` |
---|
1064 | -- |
---|
1065 | |
---|
1066 | DROP TABLE IF EXISTS `recordedmarkup`; |
---|
1067 | CREATE TABLE `recordedmarkup` ( |
---|
1068 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1069 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1070 | `mark` bigint(20) NOT NULL default '0', |
---|
1071 | `offset` varchar(32) default NULL, |
---|
1072 | `type` int(11) NOT NULL default '0', |
---|
1073 | PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) |
---|
1074 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1075 | |
---|
1076 | -- |
---|
1077 | -- Dumping data for table `recordedmarkup` |
---|
1078 | -- |
---|
1079 | |
---|
1080 | |
---|
1081 | /*!40000 ALTER TABLE `recordedmarkup` DISABLE KEYS */; |
---|
1082 | LOCK TABLES `recordedmarkup` WRITE; |
---|
1083 | UNLOCK TABLES; |
---|
1084 | /*!40000 ALTER TABLE `recordedmarkup` ENABLE KEYS */; |
---|
1085 | |
---|
1086 | -- |
---|
1087 | -- Table structure for table `recordedprogram` |
---|
1088 | -- |
---|
1089 | |
---|
1090 | DROP TABLE IF EXISTS `recordedprogram`; |
---|
1091 | CREATE TABLE `recordedprogram` ( |
---|
1092 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1093 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1094 | `endtime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1095 | `title` varchar(128) NOT NULL default '', |
---|
1096 | `subtitle` varchar(128) NOT NULL default '', |
---|
1097 | `description` text NOT NULL, |
---|
1098 | `category` varchar(64) NOT NULL default '', |
---|
1099 | `category_type` varchar(64) NOT NULL default '', |
---|
1100 | `airdate` year(4) NOT NULL default '0000', |
---|
1101 | `stars` float unsigned NOT NULL default '0', |
---|
1102 | `previouslyshown` tinyint(4) NOT NULL default '0', |
---|
1103 | `title_pronounce` varchar(128) NOT NULL default '', |
---|
1104 | `stereo` tinyint(1) NOT NULL default '0', |
---|
1105 | `subtitled` tinyint(1) NOT NULL default '0', |
---|
1106 | `hdtv` tinyint(1) NOT NULL default '0', |
---|
1107 | `closecaptioned` tinyint(1) NOT NULL default '0', |
---|
1108 | `partnumber` int(11) NOT NULL default '0', |
---|
1109 | `parttotal` int(11) NOT NULL default '0', |
---|
1110 | `seriesid` varchar(12) NOT NULL default '', |
---|
1111 | `originalairdate` date default NULL, |
---|
1112 | `showtype` varchar(30) NOT NULL default '', |
---|
1113 | `colorcode` varchar(20) NOT NULL default '', |
---|
1114 | `syndicatedepisodenumber` varchar(20) NOT NULL default '', |
---|
1115 | `programid` varchar(20) NOT NULL default '', |
---|
1116 | `manualid` int(10) unsigned NOT NULL default '0', |
---|
1117 | `generic` tinyint(1) default '0', |
---|
1118 | `listingsource` int(11) NOT NULL default '0', |
---|
1119 | `first` tinyint(1) NOT NULL default '0', |
---|
1120 | `last` tinyint(1) NOT NULL default '0', |
---|
1121 | PRIMARY KEY (`chanid`,`starttime`,`manualid`), |
---|
1122 | KEY `endtime` (`endtime`), |
---|
1123 | KEY `title` (`title`), |
---|
1124 | KEY `title_pronounce` (`title_pronounce`), |
---|
1125 | KEY `seriesid` (`seriesid`), |
---|
1126 | KEY `programid` (`programid`), |
---|
1127 | KEY `id_start_end` (`chanid`,`starttime`,`endtime`) |
---|
1128 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1129 | |
---|
1130 | -- |
---|
1131 | -- Dumping data for table `recordedprogram` |
---|
1132 | -- |
---|
1133 | |
---|
1134 | |
---|
1135 | /*!40000 ALTER TABLE `recordedprogram` DISABLE KEYS */; |
---|
1136 | LOCK TABLES `recordedprogram` WRITE; |
---|
1137 | UNLOCK TABLES; |
---|
1138 | /*!40000 ALTER TABLE `recordedprogram` ENABLE KEYS */; |
---|
1139 | |
---|
1140 | -- |
---|
1141 | -- Table structure for table `recordedrating` |
---|
1142 | -- |
---|
1143 | |
---|
1144 | DROP TABLE IF EXISTS `recordedrating`; |
---|
1145 | CREATE TABLE `recordedrating` ( |
---|
1146 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1147 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1148 | `system` char(8) NOT NULL default '', |
---|
1149 | `rating` char(8) NOT NULL default '', |
---|
1150 | UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), |
---|
1151 | KEY `starttime` (`starttime`,`system`) |
---|
1152 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1153 | |
---|
1154 | -- |
---|
1155 | -- Dumping data for table `recordedrating` |
---|
1156 | -- |
---|
1157 | |
---|
1158 | |
---|
1159 | /*!40000 ALTER TABLE `recordedrating` DISABLE KEYS */; |
---|
1160 | LOCK TABLES `recordedrating` WRITE; |
---|
1161 | UNLOCK TABLES; |
---|
1162 | /*!40000 ALTER TABLE `recordedrating` ENABLE KEYS */; |
---|
1163 | |
---|
1164 | -- |
---|
1165 | -- Table structure for table `recordedseek` |
---|
1166 | -- |
---|
1167 | |
---|
1168 | DROP TABLE IF EXISTS `recordedseek`; |
---|
1169 | CREATE TABLE `recordedseek` ( |
---|
1170 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1171 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1172 | `mark` bigint(20) NOT NULL default '0', |
---|
1173 | `offset` varchar(32) default NULL, |
---|
1174 | `type` int(11) NOT NULL default '0', |
---|
1175 | PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) |
---|
1176 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1177 | |
---|
1178 | -- |
---|
1179 | -- Dumping data for table `recordedseek` |
---|
1180 | -- |
---|
1181 | |
---|
1182 | |
---|
1183 | /*!40000 ALTER TABLE `recordedseek` DISABLE KEYS */; |
---|
1184 | LOCK TABLES `recordedseek` WRITE; |
---|
1185 | UNLOCK TABLES; |
---|
1186 | /*!40000 ALTER TABLE `recordedseek` ENABLE KEYS */; |
---|
1187 | |
---|
1188 | -- |
---|
1189 | -- Table structure for table `recordingprofiles` |
---|
1190 | -- |
---|
1191 | |
---|
1192 | DROP TABLE IF EXISTS `recordingprofiles`; |
---|
1193 | CREATE TABLE `recordingprofiles` ( |
---|
1194 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
1195 | `name` varchar(128) default NULL, |
---|
1196 | `videocodec` varchar(128) default NULL, |
---|
1197 | `audiocodec` varchar(128) default NULL, |
---|
1198 | `profilegroup` int(10) unsigned NOT NULL default '0', |
---|
1199 | PRIMARY KEY (`id`) |
---|
1200 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1201 | |
---|
1202 | -- |
---|
1203 | -- Dumping data for table `recordingprofiles` |
---|
1204 | -- |
---|
1205 | |
---|
1206 | |
---|
1207 | /*!40000 ALTER TABLE `recordingprofiles` DISABLE KEYS */; |
---|
1208 | LOCK TABLES `recordingprofiles` WRITE; |
---|
1209 | INSERT INTO `recordingprofiles` VALUES (1,'Default',NULL,NULL,1),(2,'Live TV',NULL,NULL,1),(3,'High Quality',NULL,NULL,1),(4,'Low Quality',NULL,NULL,1),(5,'Default',NULL,NULL,2),(6,'Live TV',NULL,NULL,2),(7,'High Quality',NULL,NULL,2),(8,'Low Quality',NULL,NULL,2),(9,'Default',NULL,NULL,3),(10,'Live TV',NULL,NULL,3),(11,'High Quality',NULL,NULL,3),(12,'Low Quality',NULL,NULL,3),(13,'Default',NULL,NULL,4),(14,'Live TV',NULL,NULL,4),(15,'High Quality',NULL,NULL,4),(16,'Low Quality',NULL,NULL,4),(17,'Default',NULL,NULL,5),(18,'Live TV',NULL,NULL,5),(19,'High Quality',NULL,NULL,5),(20,'Low Quality',NULL,NULL,5),(21,'RTjpeg/MPEG4',NULL,NULL,6),(22,'MPEG2',NULL,NULL,6),(23,'Default',NULL,NULL,8),(24,'Live TV',NULL,NULL,8),(25,'High Quality',NULL,NULL,8),(26,'Low Quality',NULL,NULL,8),(27,'High Quality',NULL,NULL,6),(28,'Medium Quality',NULL,NULL,6),(29,'Low Quality',NULL,NULL,6),(30,'Default',NULL,NULL,10),(31,'Live TV',NULL,NULL,10),(32,'High Quality',NULL,NULL,10),(33,'Low Quality',NULL,NULL,10),(34,'Default',NULL,NULL,11),(35,'Live TV',NULL,NULL,11),(36,'High Quality',NULL,NULL,11),(37,'Low Quality',NULL,NULL,11),(38,'Default',NULL,NULL,12),(39,'Live TV',NULL,NULL,12),(40,'High Quality',NULL,NULL,12),(41,'Low Quality',NULL,NULL,12); |
---|
1210 | UNLOCK TABLES; |
---|
1211 | /*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */; |
---|
1212 | |
---|
1213 | -- |
---|
1214 | -- Table structure for table `recordmatch` |
---|
1215 | -- |
---|
1216 | |
---|
1217 | DROP TABLE IF EXISTS `recordmatch`; |
---|
1218 | CREATE TABLE `recordmatch` ( |
---|
1219 | `recordid` int(10) unsigned default NULL, |
---|
1220 | `chanid` int(10) unsigned default NULL, |
---|
1221 | `starttime` datetime default NULL, |
---|
1222 | `manualid` int(10) unsigned default NULL, |
---|
1223 | KEY `recordid` (`recordid`) |
---|
1224 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1225 | |
---|
1226 | -- |
---|
1227 | -- Dumping data for table `recordmatch` |
---|
1228 | -- |
---|
1229 | |
---|
1230 | |
---|
1231 | /*!40000 ALTER TABLE `recordmatch` DISABLE KEYS */; |
---|
1232 | LOCK TABLES `recordmatch` WRITE; |
---|
1233 | UNLOCK TABLES; |
---|
1234 | /*!40000 ALTER TABLE `recordmatch` ENABLE KEYS */; |
---|
1235 | |
---|
1236 | -- |
---|
1237 | -- Table structure for table `schemalock` |
---|
1238 | -- |
---|
1239 | |
---|
1240 | DROP TABLE IF EXISTS `schemalock`; |
---|
1241 | CREATE TABLE `schemalock` ( |
---|
1242 | `schemalock` int(1) default NULL |
---|
1243 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1244 | |
---|
1245 | -- |
---|
1246 | -- Dumping data for table `schemalock` |
---|
1247 | -- |
---|
1248 | |
---|
1249 | |
---|
1250 | /*!40000 ALTER TABLE `schemalock` DISABLE KEYS */; |
---|
1251 | LOCK TABLES `schemalock` WRITE; |
---|
1252 | UNLOCK TABLES; |
---|
1253 | /*!40000 ALTER TABLE `schemalock` ENABLE KEYS */; |
---|
1254 | |
---|
1255 | -- |
---|
1256 | -- Table structure for table `settings` |
---|
1257 | -- |
---|
1258 | |
---|
1259 | DROP TABLE IF EXISTS `settings`; |
---|
1260 | CREATE TABLE `settings` ( |
---|
1261 | `value` varchar(128) NOT NULL default '', |
---|
1262 | `data` text, |
---|
1263 | `hostname` varchar(255) default NULL, |
---|
1264 | KEY `value` (`value`,`hostname`) |
---|
1265 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1266 | |
---|
1267 | -- |
---|
1268 | -- Dumping data for table `settings` |
---|
1269 | -- |
---|
1270 | |
---|
1271 | |
---|
1272 | /*!40000 ALTER TABLE `settings` DISABLE KEYS */; |
---|
1273 | LOCK TABLES `settings` WRITE; |
---|
1274 | INSERT INTO `settings` VALUES ('mythfilldatabaseLastRunStart',NULL,NULL),('mythfilldatabaseLastRunEnd',NULL,NULL),('mythfilldatabaseLastRunStatus',NULL,NULL),('DataDirectMessage',NULL,NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1155',NULL),('DefaultTranscoder','0',NULL),('MythFillSuggestedRunTime','1970-01-01T00:00:00',NULL),('MythFillGrabberSuggestsTime','1',NULL),('Language','DE','zenslack'),('BackendServerIP','127.0.0.1','zenslack'),('BackendServerPort','6543','zenslack'),('BackendStatusPort','6544','zenslack'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('RecordFilePrefix','/video/store/','zenslack'),('TVFormat','PAL',NULL),('VbiFormat','PAL Teletext',NULL),('FreqTable','europe-west',NULL),('TimeOffset','None',NULL),('MasterBackendOverride','1',NULL),('DeletesFollowLinks','0',NULL),('EITTimeOffset','Auto',NULL),('EITTransportTimeout','5',NULL),('EITIgnoresSource','0',NULL),('EITCrawIdleStart','60',NULL),('startupCommand','',NULL),('blockSDWUwithoutClient','1',NULL),('idleTimeoutSecs','0',NULL),('idleWaitForRecordingTime','15',NULL),('StartupSecsBeforeRecording','120',NULL),('WakeupTimeFormat','hh:mm yyyy-MM-dd',NULL),('SetWakeuptimeCommand','',NULL),('ServerHaltCommand','sudo /sbin/halt -p',NULL),('preSDWUCheckCommand','',NULL),('WOLbackendReconnectWaitTime','0',NULL),('WOLbackendConnectRetry','5',NULL),('WOLbackendCommand','',NULL),('WOLslaveBackendsCommand','',NULL),('JobQueueMaxSimultaneousJobs','1','zenslack'),('JobQueueCheckFrequency','60','zenslack'),('JobQueueWindowStart','00:00','zenslack'),('JobQueueWindowEnd','23:59','zenslack'),('JobQueueCPU','0','zenslack'),('JobAllowCommFlag','1','zenslack'),('JobAllowTranscode','1','zenslack'),('JobAllowUserJob1','0','zenslack'),('JobAllowUserJob2','0','zenslack'),('JobAllowUserJob3','0','zenslack'),('JobAllowUserJob4','0','zenslack'),('JobsRunOnRecordHost','0',NULL),('AutoCommflagWhileRecording','0',NULL),('JobQueueCommFlagCommand','mythcommflag',NULL),('JobQueueTranscodeCommand','mythtranscode',NULL),('AutoTranscodeBeforeAutoCommflag','0',NULL),('SaveTranscoding','0',NULL),('UserJobDesc1','User Job #1',NULL),('UserJob1','',NULL),('UserJobDesc2','User Job #2',NULL),('UserJob2','',NULL),('UserJobDesc3','User Job #3',NULL),('UserJob3','',NULL),('UserJobDesc4','User Job #4',NULL),('UserJob4','',NULL); |
---|
1275 | UNLOCK TABLES; |
---|
1276 | /*!40000 ALTER TABLE `settings` ENABLE KEYS */; |
---|
1277 | |
---|
1278 | -- |
---|
1279 | -- Table structure for table `tvchain` |
---|
1280 | -- |
---|
1281 | |
---|
1282 | DROP TABLE IF EXISTS `tvchain`; |
---|
1283 | CREATE TABLE `tvchain` ( |
---|
1284 | `chanid` int(10) unsigned NOT NULL default '0', |
---|
1285 | `starttime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1286 | `chainid` varchar(128) NOT NULL default '', |
---|
1287 | `chainpos` int(10) NOT NULL default '0', |
---|
1288 | `discontinuity` tinyint(1) NOT NULL default '0', |
---|
1289 | `watching` int(10) NOT NULL default '0', |
---|
1290 | `hostprefix` varchar(128) NOT NULL default '', |
---|
1291 | `cardtype` varchar(32) NOT NULL default 'V4L', |
---|
1292 | `input` varchar(32) NOT NULL default '', |
---|
1293 | `channame` varchar(32) NOT NULL default '', |
---|
1294 | `endtime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1295 | PRIMARY KEY (`chanid`,`starttime`) |
---|
1296 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1297 | |
---|
1298 | -- |
---|
1299 | -- Dumping data for table `tvchain` |
---|
1300 | -- |
---|
1301 | |
---|
1302 | |
---|
1303 | /*!40000 ALTER TABLE `tvchain` DISABLE KEYS */; |
---|
1304 | LOCK TABLES `tvchain` WRITE; |
---|
1305 | UNLOCK TABLES; |
---|
1306 | /*!40000 ALTER TABLE `tvchain` ENABLE KEYS */; |
---|
1307 | |
---|
1308 | -- |
---|
1309 | -- Table structure for table `videobookmarks` |
---|
1310 | -- |
---|
1311 | |
---|
1312 | DROP TABLE IF EXISTS `videobookmarks`; |
---|
1313 | CREATE TABLE `videobookmarks` ( |
---|
1314 | `filename` varchar(255) NOT NULL default '', |
---|
1315 | `bookmark` varchar(128) default NULL, |
---|
1316 | PRIMARY KEY (`filename`) |
---|
1317 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1318 | |
---|
1319 | -- |
---|
1320 | -- Dumping data for table `videobookmarks` |
---|
1321 | -- |
---|
1322 | |
---|
1323 | |
---|
1324 | /*!40000 ALTER TABLE `videobookmarks` DISABLE KEYS */; |
---|
1325 | LOCK TABLES `videobookmarks` WRITE; |
---|
1326 | UNLOCK TABLES; |
---|
1327 | /*!40000 ALTER TABLE `videobookmarks` ENABLE KEYS */; |
---|
1328 | |
---|
1329 | -- |
---|
1330 | -- Table structure for table `videosource` |
---|
1331 | -- |
---|
1332 | |
---|
1333 | DROP TABLE IF EXISTS `videosource`; |
---|
1334 | CREATE TABLE `videosource` ( |
---|
1335 | `sourceid` int(10) unsigned NOT NULL auto_increment, |
---|
1336 | `name` varchar(128) NOT NULL default '', |
---|
1337 | `xmltvgrabber` varchar(128) default NULL, |
---|
1338 | `userid` varchar(128) NOT NULL default '', |
---|
1339 | `freqtable` varchar(16) NOT NULL default 'default', |
---|
1340 | `lineupid` varchar(64) default NULL, |
---|
1341 | `password` varchar(64) default NULL, |
---|
1342 | `useeit` smallint(6) NOT NULL default '0', |
---|
1343 | PRIMARY KEY (`sourceid`), |
---|
1344 | UNIQUE KEY `name` (`name`) |
---|
1345 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
1346 | |
---|
1347 | -- |
---|
1348 | -- Dumping data for table `videosource` |
---|
1349 | -- |
---|
1350 | |
---|
1351 | |
---|
1352 | /*!40000 ALTER TABLE `videosource` DISABLE KEYS */; |
---|
1353 | LOCK TABLES `videosource` WRITE; |
---|
1354 | INSERT INTO `videosource` VALUES (1,'dvb','eitonly','','default',NULL,NULL,1); |
---|
1355 | UNLOCK TABLES; |
---|
1356 | /*!40000 ALTER TABLE `videosource` ENABLE KEYS */; |
---|
1357 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
1358 | |
---|
1359 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
1360 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
1361 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
1362 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
1363 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
1364 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
1365 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
1366 | |
---|