~ubuntu-branches/ubuntu/lucid/mythtv/lucid : revision 86

1

--

2

--

3

--

4

--

5

--

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

--

20

21

DROP TABLE IF EXISTS `archiveitems`;

22

SET @saved_cs_client = @@character_set_client;

23

SET character_set_client = utf8;

24

CREATE TABLE `archiveitems` (

25

`intid` int(10) unsigned NOT NULL auto_increment,

26

`type` set('Recording','Video','File') default NULL,

27

`title` varchar(128) default NULL,

28

`subtitle` varchar(128) default NULL,

29

`description` text,

30

`startdate` varchar(30) default NULL,

31

`starttime` varchar(30) default NULL,

32

`size` int(10) unsigned NOT NULL,

33

`filename` text NOT NULL,

34

`hascutlist` tinyint(1) NOT NULL default '0',

35

`cutlist` text,

36

PRIMARY KEY (`intid`),

37

KEY `title` (`title`)

38

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

39

SET character_set_client = @saved_cs_client;

40

41

--

42

--

43

44

LOCK TABLES `archiveitems` WRITE;

45

/*!40000 ALTER TABLE `archiveitems` DISABLE KEYS */;

46

/*!40000 ALTER TABLE `archiveitems` ENABLE KEYS */;

47

UNLOCK TABLES;

48

49

--

50

--

51

52

DROP TABLE IF EXISTS `callsignnetworkmap`;

53

SET @saved_cs_client = @@character_set_client;

54

SET character_set_client = utf8;

55

CREATE TABLE `callsignnetworkmap` (

56

`id` int(11) NOT NULL auto_increment,

57

`callsign` varchar(20) NOT NULL default '',

58

`network` varchar(20) NOT NULL default '',

59

PRIMARY KEY (`id`),

60

UNIQUE KEY `callsign` (`callsign`)

61

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

62

SET character_set_client = @saved_cs_client;

63

64

--

65

--

66

67

LOCK TABLES `callsignnetworkmap` WRITE;

68

/*!40000 ALTER TABLE `callsignnetworkmap` DISABLE KEYS */;

69

/*!40000 ALTER TABLE `callsignnetworkmap` ENABLE KEYS */;

70

UNLOCK TABLES;

71

72

--

73

--

74

75

DROP TABLE IF EXISTS `capturecard`;

76

SET @saved_cs_client = @@character_set_client;

77

SET character_set_client = utf8;

78

CREATE TABLE `capturecard` (

79

`cardid` int(10) unsigned NOT NULL auto_increment,

80

`videodevice` varchar(128) default NULL,

81

`audiodevice` varchar(128) default NULL,

82

`vbidevice` varchar(128) default NULL,

83

`cardtype` varchar(32) default 'V4L',

84

`defaultinput` varchar(32) default 'Television',

85

`audioratelimit` int(11) default NULL,

86

`hostname` varchar(255) default NULL,

87

`dvb_swfilter` int(11) default '0',

88

`dvb_sat_type` int(11) NOT NULL default '0',

89

`dvb_wait_for_seqstart` int(11) NOT NULL default '1',

90

`skipbtaudio` tinyint(1) default '0',

91

`dvb_on_demand` tinyint(4) NOT NULL default '0',

92

`dvb_diseqc_type` smallint(6) default NULL,

93

`firewire_port` int(10) unsigned NOT NULL default '0',

94

`firewire_node` int(10) unsigned NOT NULL default '2',

95

`firewire_speed` int(10) unsigned NOT NULL default '0',

96

`firewire_model` varchar(32) default NULL,

97

`firewire_connection` int(10) unsigned NOT NULL default '0',

98

`dbox2_port` int(10) unsigned NOT NULL default '31338',

99

`dbox2_httpport` int(10) unsigned NOT NULL default '80',

100

`dbox2_host` varchar(32) default NULL,

101

`signal_timeout` int(11) NOT NULL default '1000',

102

`channel_timeout` int(11) NOT NULL default '3000',

103

`dvb_tuning_delay` int(10) unsigned NOT NULL default '0',

104

`contrast` int(11) NOT NULL default '0',

105

`brightness` int(11) NOT NULL default '0',

106

`colour` int(11) NOT NULL default '0',

107

`hue` int(11) NOT NULL default '0',

108

`diseqcid` int(10) unsigned default NULL,

109

`dvb_eitscan` tinyint(1) NOT NULL default '1',

110

PRIMARY KEY (`cardid`)

111

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

112

SET character_set_client = @saved_cs_client;

113

114

--

115

--

116

117

LOCK TABLES `capturecard` WRITE;

118

/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */;

119

/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */;

120

UNLOCK TABLES;

121

122

--

123

--

124

125

DROP TABLE IF EXISTS `cardinput`;

126

SET @saved_cs_client = @@character_set_client;

127

SET character_set_client = utf8;

128

CREATE TABLE `cardinput` (

129

`cardinputid` int(10) unsigned NOT NULL auto_increment,

130

`cardid` int(10) unsigned NOT NULL default '0',

131

`sourceid` int(10) unsigned NOT NULL default '0',

132

`inputname` varchar(32) NOT NULL default '',

133

`externalcommand` varchar(128) default NULL,

134

`preference` int(11) NOT NULL default '0',

135

`shareable` char(1) default 'N',

136

`tunechan` varchar(10) default NULL,

137

`startchan` varchar(10) default NULL,

138

`freetoaironly` tinyint(1) default '1',

139

`diseqc_port` smallint(6) default NULL,

140

`diseqc_pos` float default NULL,

141

`lnb_lof_switch` int(11) default '11700000',

142

`lnb_lof_hi` int(11) default '10600000',

143

`lnb_lof_lo` int(11) default '9750000',

144

`displayname` varchar(64) NOT NULL default '',

145

`radioservices` tinyint(1) default '1',

146

`dishnet_eit` tinyint(1) NOT NULL default '0',

147

`recpriority` int(11) NOT NULL default '0',

148

`quicktune` tinyint(4) NOT NULL default '0',

149

PRIMARY KEY (`cardinputid`)

150

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

151

SET character_set_client = @saved_cs_client;

152

153

--

154

--

155

156

LOCK TABLES `cardinput` WRITE;

157

/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;

158

/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;

159

UNLOCK TABLES;

160

161

--

162

--

163

164

DROP TABLE IF EXISTS `channel`;

165

SET @saved_cs_client = @@character_set_client;

166

SET character_set_client = utf8;

167

CREATE TABLE `channel` (

168

`chanid` int(10) unsigned NOT NULL default '0',

169

`channum` varchar(10) NOT NULL default '',

170

`freqid` varchar(10) default NULL,

171

`sourceid` int(10) unsigned default NULL,

172

`callsign` varchar(20) NOT NULL default '',

173

`name` varchar(64) NOT NULL default '',

174

`icon` varchar(255) NOT NULL default 'none',

175

`finetune` int(11) default NULL,

176

`videofilters` varchar(255) NOT NULL default '',

177

`xmltvid` varchar(64) NOT NULL default '',

178

`recpriority` int(10) NOT NULL default '0',

179

`contrast` int(11) default '32768',

180

`brightness` int(11) default '32768',

181

`colour` int(11) default '32768',

182

`hue` int(11) default '32768',

183

`tvformat` varchar(10) NOT NULL default 'Default',

184

`commfree` tinyint(4) NOT NULL default '0',

185

`visible` tinyint(1) NOT NULL default '1',

186

`outputfilters` varchar(255) NOT NULL default '',

187

`useonairguide` tinyint(1) default '0',

188

`mplexid` smallint(6) default NULL,

189

`serviceid` mediumint(8) unsigned default NULL,

190

`atscsrcid` int(11) default NULL,

191

`tmoffset` int(11) NOT NULL default '0',

192

`atsc_major_chan` int(10) unsigned NOT NULL default '0',

193

`atsc_minor_chan` int(10) unsigned NOT NULL default '0',

194

`last_record` datetime NOT NULL,

195

`default_authority` varchar(32) NOT NULL default '',

196

`commmethod` int(11) NOT NULL default '-1',

197

PRIMARY KEY (`chanid`),

198

KEY `channel_src` (`channum`,`sourceid`),

199

KEY `sourceid` (`sourceid`,`xmltvid`,`chanid`),

200

KEY `visible` (`visible`)

201

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

202

SET character_set_client = @saved_cs_client;

203

204

--

205

--

206

207

LOCK TABLES `channel` WRITE;

208

/*!40000 ALTER TABLE `channel` DISABLE KEYS */;

209

/*!40000 ALTER TABLE `channel` ENABLE KEYS */;

210

UNLOCK TABLES;

211

212

--

213

--

214

215

DROP TABLE IF EXISTS `codecparams`;

216

SET @saved_cs_client = @@character_set_client;

217

SET character_set_client = utf8;

218

CREATE TABLE `codecparams` (

219

`profile` int(10) unsigned NOT NULL default '0',

220

`name` varchar(128) NOT NULL default '',

221

`value` varchar(128) default NULL,

222

PRIMARY KEY (`profile`,`name`)

223

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

224

SET character_set_client = @saved_cs_client;

225

226

--

227

--

228

229

LOCK TABLES `codecparams` WRITE;

230

/*!40000 ALTER TABLE `codecparams` DISABLE KEYS */;

231

/*!40000 ALTER TABLE `codecparams` ENABLE KEYS */;

232

UNLOCK TABLES;

233

234

--

235

--

236

237

DROP TABLE IF EXISTS `credits`;

238

SET @saved_cs_client = @@character_set_client;

239

SET character_set_client = utf8;

240

CREATE TABLE `credits` (

241

`person` mediumint(8) unsigned NOT NULL default '0',

242

`chanid` int(10) unsigned NOT NULL default '0',

243

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

244

`role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',

245

UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),

246

KEY `person` (`person`,`role`)

247

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

248

SET character_set_client = @saved_cs_client;

249

250

--

251

--

252

253

LOCK TABLES `credits` WRITE;

254

/*!40000 ALTER TABLE `credits` DISABLE KEYS */;

255

/*!40000 ALTER TABLE `credits` ENABLE KEYS */;

256

UNLOCK TABLES;

257

258

--

259

--

260

261

DROP TABLE IF EXISTS `customexample`;

262

SET @saved_cs_client = @@character_set_client;

263

SET character_set_client = utf8;

264

CREATE TABLE `customexample` (

265

`rulename` varchar(64) NOT NULL,

266

`fromclause` text NOT NULL,

267

`whereclause` text NOT NULL,

268

`search` tinyint(4) NOT NULL default '0',

269

PRIMARY KEY (`rulename`)

270

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

271

SET character_set_client = @saved_cs_client;

272

273

--

274

--

275

276

LOCK TABLES `customexample` WRITE;

277

/*!40000 ALTER TABLE `customexample` DISABLE KEYS */;

278

INSERT INTO `customexample` VALUES ('New Flix','','program.category_type = \'movie\' AND program.airdate >= \n YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR)) \nAND program.stars > 0.5 ',1);

279

/*!40000 ALTER TABLE `customexample` ENABLE KEYS */;

280

UNLOCK TABLES;

281

282

--

283

--

284

285

DROP TABLE IF EXISTS `diseqc_config`;

286

SET @saved_cs_client = @@character_set_client;

287

SET character_set_client = utf8;

288

CREATE TABLE `diseqc_config` (

289

`cardinputid` int(10) unsigned NOT NULL,

290

`diseqcid` int(10) unsigned NOT NULL,

291

`value` varchar(16) NOT NULL default '',

292

KEY `id` (`cardinputid`)

293

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

294

SET character_set_client = @saved_cs_client;

295

296

--

297

--

298

299

LOCK TABLES `diseqc_config` WRITE;

300

/*!40000 ALTER TABLE `diseqc_config` DISABLE KEYS */;

301

/*!40000 ALTER TABLE `diseqc_config` ENABLE KEYS */;

302

UNLOCK TABLES;

303

304

--

305

--

306

307

DROP TABLE IF EXISTS `diseqc_tree`;

308

SET @saved_cs_client = @@character_set_client;

309

SET character_set_client = utf8;

310

CREATE TABLE `diseqc_tree` (

311

`diseqcid` int(10) unsigned NOT NULL auto_increment,

312

`parentid` int(10) unsigned default NULL,

313

`ordinal` tinyint(3) unsigned NOT NULL,

314

`type` varchar(16) NOT NULL default '',

315

`subtype` varchar(16) NOT NULL default '',

316

`description` varchar(32) NOT NULL default '',

317

`switch_ports` tinyint(3) unsigned NOT NULL default '0',

318

`rotor_hi_speed` float NOT NULL default '0',

319

`rotor_lo_speed` float NOT NULL default '0',

320

`rotor_positions` varchar(255) NOT NULL default '',

321

`lnb_lof_switch` int(10) NOT NULL default '0',

322

`lnb_lof_hi` int(10) NOT NULL default '0',

323

`lnb_lof_lo` int(10) NOT NULL default '0',

324

`cmd_repeat` int(11) NOT NULL default '1',

325

`lnb_pol_inv` tinyint(4) NOT NULL default '0',

326

PRIMARY KEY (`diseqcid`),

327

KEY `parentid` (`parentid`)

328

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

329

SET character_set_client = @saved_cs_client;

330

331

--

332

--

333

334

LOCK TABLES `diseqc_tree` WRITE;

335

/*!40000 ALTER TABLE `diseqc_tree` DISABLE KEYS */;

336

/*!40000 ALTER TABLE `diseqc_tree` ENABLE KEYS */;

337

UNLOCK TABLES;

338

339

--

340

--

341

342

DROP TABLE IF EXISTS `displayprofilegroups`;

343

SET @saved_cs_client = @@character_set_client;

344

SET character_set_client = utf8;

345

CREATE TABLE `displayprofilegroups` (

346

`name` varchar(128) NOT NULL,

347

`hostname` varchar(255) NOT NULL,

348

`profilegroupid` int(10) unsigned NOT NULL auto_increment,

349

PRIMARY KEY (`name`,`hostname`),

350

UNIQUE KEY `profilegroupid` (`profilegroupid`)

351

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

352

SET character_set_client = @saved_cs_client;

353

354

--

355

--

356

357

LOCK TABLES `displayprofilegroups` WRITE;

358

/*!40000 ALTER TABLE `displayprofilegroups` DISABLE KEYS */;

359

/*!40000 ALTER TABLE `displayprofilegroups` ENABLE KEYS */;

360

UNLOCK TABLES;

361

362

--

363

--

364

365

DROP TABLE IF EXISTS `displayprofiles`;

366

SET @saved_cs_client = @@character_set_client;

367

SET character_set_client = utf8;

368

CREATE TABLE `displayprofiles` (

369

`profilegroupid` int(10) unsigned NOT NULL,

370

`profileid` int(10) unsigned NOT NULL auto_increment,

371

`value` varchar(128) NOT NULL,

372

`data` varchar(255) NOT NULL default '',

373

KEY `profilegroupid` (`profilegroupid`),

374

KEY `profileid` (`profileid`,`value`),

375

KEY `profileid_2` (`profileid`)

376

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

377

SET character_set_client = @saved_cs_client;

378

379

--

380

--

381

382

LOCK TABLES `displayprofiles` WRITE;

383

/*!40000 ALTER TABLE `displayprofiles` DISABLE KEYS */;

384

/*!40000 ALTER TABLE `displayprofiles` ENABLE KEYS */;

385

UNLOCK TABLES;

386

387

--

388

--

389

390

DROP TABLE IF EXISTS `dtv_multiplex`;

391

SET @saved_cs_client = @@character_set_client;

392

SET character_set_client = utf8;

393

CREATE TABLE `dtv_multiplex` (

394

`mplexid` smallint(6) NOT NULL auto_increment,

395

`sourceid` smallint(6) default NULL,

396

`transportid` int(11) default NULL,

397

`networkid` int(11) default NULL,

398

`frequency` int(11) default NULL,

399

`inversion` char(1) default 'a',

400

`symbolrate` int(11) default NULL,

401

`fec` varchar(10) default 'auto',

402

`polarity` char(1) default NULL,

403

`modulation` varchar(10) default 'auto',

404

`bandwidth` char(1) default 'a',

405

`lp_code_rate` varchar(10) default 'auto',

406

`transmission_mode` char(1) default 'a',

407

`guard_interval` varchar(10) default 'auto',

408

`visible` smallint(1) NOT NULL default '0',

409

`constellation` varchar(10) default 'auto',

410

`hierarchy` varchar(10) default 'auto',

411

`hp_code_rate` varchar(10) default 'auto',

412

`sistandard` varchar(10) default 'dvb',

413

`serviceversion` smallint(6) default '33',

414

`updatetimestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

415

PRIMARY KEY (`mplexid`)

416

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

417

SET character_set_client = @saved_cs_client;

418

419

--

420

--

421

422

LOCK TABLES `dtv_multiplex` WRITE;

423

/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */;

424

/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */;

425

UNLOCK TABLES;

426

427

--

428

--

429

430

DROP TABLE IF EXISTS `dtv_privatetypes`;

431

SET @saved_cs_client = @@character_set_client;

432

SET character_set_client = utf8;

433

CREATE TABLE `dtv_privatetypes` (

434

`sitype` varchar(4) NOT NULL default '',

435

`networkid` int(11) NOT NULL default '0',

436

`private_type` varchar(20) NOT NULL default '',

437

`private_value` varchar(100) NOT NULL default ''

438

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

439

SET character_set_client = @saved_cs_client;

440

441

--

442

--

443

444

LOCK TABLES `dtv_privatetypes` WRITE;

445

/*!40000 ALTER TABLE `dtv_privatetypes` DISABLE KEYS */;

446

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');

447

/*!40000 ALTER TABLE `dtv_privatetypes` ENABLE KEYS */;

448

UNLOCK TABLES;

449

450

--

451

--

452

453

DROP TABLE IF EXISTS `dvdbookmark`;

454

SET @saved_cs_client = @@character_set_client;

455

SET character_set_client = utf8;

456

CREATE TABLE `dvdbookmark` (

457

`serialid` varchar(16) NOT NULL default '',

458

`name` varchar(32) default NULL,

459

`title` smallint(6) NOT NULL default '0',

460

`audionum` tinyint(4) NOT NULL default '-1',

461

`subtitlenum` tinyint(4) NOT NULL default '-1',

462

`framenum` bigint(20) NOT NULL default '0',

463

`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

464

PRIMARY KEY (`serialid`)

465

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

466

SET character_set_client = @saved_cs_client;

467

468

--

469

--

470

471

LOCK TABLES `dvdbookmark` WRITE;

472

/*!40000 ALTER TABLE `dvdbookmark` DISABLE KEYS */;

473

/*!40000 ALTER TABLE `dvdbookmark` ENABLE KEYS */;

474

UNLOCK TABLES;

475

476

--

477

--

478

479

DROP TABLE IF EXISTS `dvdinput`;

480

SET @saved_cs_client = @@character_set_client;

481

SET character_set_client = utf8;

482

CREATE TABLE `dvdinput` (

483

`intid` int(10) unsigned NOT NULL,

484

`hsize` int(10) unsigned default NULL,

485

`vsize` int(10) unsigned default NULL,

486

`ar_num` int(10) unsigned default NULL,

487

`ar_denom` int(10) unsigned default NULL,

488

`fr_code` int(10) unsigned default NULL,

489

`letterbox` tinyint(1) default NULL,

490

`v_format` varchar(16) default NULL,

491

PRIMARY KEY (`intid`)

492

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

493

SET character_set_client = @saved_cs_client;

494

495

--

496

--

497

498

LOCK TABLES `dvdinput` WRITE;

499

/*!40000 ALTER TABLE `dvdinput` DISABLE KEYS */;

500

INSERT INTO `dvdinput` VALUES (1,720,480,16,9,1,1,'ntsc'),(2,720,480,16,9,1,0,'ntsc'),(3,720,480,4,3,1,1,'ntsc'),(4,720,480,4,3,1,0,'ntsc'),(5,720,576,16,9,3,1,'pal'),(6,720,576,16,9,3,0,'pal'),(7,720,576,4,3,3,1,'pal'),(8,720,576,4,3,3,0,'pal');

501

/*!40000 ALTER TABLE `dvdinput` ENABLE KEYS */;

502

UNLOCK TABLES;

503

504

--

505

--

506

507

DROP TABLE IF EXISTS `dvdtranscode`;

508

SET @saved_cs_client = @@character_set_client;

509

SET character_set_client = utf8;

510

CREATE TABLE `dvdtranscode` (

511

`intid` int(11) NOT NULL auto_increment,

512

`input` int(10) unsigned default NULL,

513

`name` varchar(128) NOT NULL,

514

`sync_mode` int(10) unsigned default NULL,

515

`use_yv12` tinyint(1) default NULL,

516

`cliptop` int(11) default NULL,

517

`clipbottom` int(11) default NULL,

518

`clipleft` int(11) default NULL,

519

`clipright` int(11) default NULL,

520

`f_resize_h` int(11) default NULL,

521

`f_resize_w` int(11) default NULL,

522

`hq_resize_h` int(11) default NULL,

523

`hq_resize_w` int(11) default NULL,

524

`grow_h` int(11) default NULL,

525

`grow_w` int(11) default NULL,

526

`clip2top` int(11) default NULL,

527

`clip2bottom` int(11) default NULL,

528

`clip2left` int(11) default NULL,

529

`clip2right` int(11) default NULL,

530

`codec` varchar(128) NOT NULL,

531

`codec_param` varchar(128) default NULL,

532

`bitrate` int(11) default NULL,

533

`a_sample_r` int(11) default NULL,

534

`a_bitrate` int(11) default NULL,

535

`two_pass` tinyint(1) default NULL,

536

`tc_param` varchar(128) default NULL,

537

PRIMARY KEY (`intid`)

538

) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

539

SET character_set_client = @saved_cs_client;

540

541

--

542

--

543

544

LOCK TABLES `dvdtranscode` WRITE;

545

/*!40000 ALTER TABLE `dvdtranscode` DISABLE KEYS */;

546

INSERT INTO `dvdtranscode` VALUES (1,1,'Good',2,1,16,16,0,0,2,0,0,0,0,0,32,32,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(2,2,'Excellent',2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),(3,2,'Good',2,1,0,0,8,8,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(4,2,'Medium',2,1,0,0,8,8,5,5,0,0,0,0,0,0,0,0,'divx5',NULL,1200,NULL,NULL,0,NULL),(5,3,'Good',2,1,0,0,0,0,0,0,0,0,2,0,80,80,8,8,'divx5',NULL,0,NULL,NULL,0,NULL),(6,4,'Excellent',2,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),(7,4,'Good',2,1,0,0,8,8,0,2,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(8,5,'Good',1,1,16,16,0,0,5,0,0,0,0,0,40,40,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(9,6,'Good',1,1,0,0,16,16,5,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(10,7,'Good',1,1,0,0,0,0,1,0,0,0,0,0,76,76,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(11,8,'Good',1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL);

547

/*!40000 ALTER TABLE `dvdtranscode` ENABLE KEYS */;

548

UNLOCK TABLES;

549

550

--

551

--

552

553

DROP TABLE IF EXISTS `eit_cache`;

554

SET @saved_cs_client = @@character_set_client;

555

SET character_set_client = utf8;

556

CREATE TABLE `eit_cache` (

557

`chanid` int(10) NOT NULL,

558

`eventid` int(10) unsigned NOT NULL default '0',

559

`tableid` tinyint(3) unsigned NOT NULL,

560

`version` tinyint(3) unsigned NOT NULL,

561

`endtime` int(10) unsigned NOT NULL,

562

`status` tinyint(4) NOT NULL default '0',

563

PRIMARY KEY (`chanid`,`eventid`,`status`)

564

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

565

SET character_set_client = @saved_cs_client;

566

567

--

568

--

569

570

LOCK TABLES `eit_cache` WRITE;

571

/*!40000 ALTER TABLE `eit_cache` DISABLE KEYS */;

572

/*!40000 ALTER TABLE `eit_cache` ENABLE KEYS */;

573

UNLOCK TABLES;

574

575

--

576

--

577

578

DROP TABLE IF EXISTS `favorites`;

579

SET @saved_cs_client = @@character_set_client;

580

SET character_set_client = utf8;

581

CREATE TABLE `favorites` (

582

`favid` int(11) unsigned NOT NULL auto_increment,

583

`userid` int(11) unsigned NOT NULL default '0',

584

`chanid` int(11) unsigned NOT NULL default '0',

585

PRIMARY KEY (`favid`)

586

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

587

SET character_set_client = @saved_cs_client;

588

589

--

590

--

591

592

LOCK TABLES `favorites` WRITE;

593

/*!40000 ALTER TABLE `favorites` DISABLE KEYS */;

594

/*!40000 ALTER TABLE `favorites` ENABLE KEYS */;

595

UNLOCK TABLES;

596

597

--

598

--

599

600

DROP TABLE IF EXISTS `filemarkup`;

601

SET @saved_cs_client = @@character_set_client;

602

SET character_set_client = utf8;

603

CREATE TABLE `filemarkup` (

604

`filename` text NOT NULL,

605

`mark` bigint(20) NOT NULL,

606

`offset` varchar(32) default NULL,

607

`type` int(11) NOT NULL

608

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

609

SET character_set_client = @saved_cs_client;

610

611

--

612

--

613

614

LOCK TABLES `filemarkup` WRITE;

615

/*!40000 ALTER TABLE `filemarkup` DISABLE KEYS */;

616

/*!40000 ALTER TABLE `filemarkup` ENABLE KEYS */;

617

UNLOCK TABLES;

618

619

--

620

--

621

622

DROP TABLE IF EXISTS `gallerymetadata`;

623

SET @saved_cs_client = @@character_set_client;

624

SET character_set_client = utf8;

625

CREATE TABLE `gallerymetadata` (

626

`image` varchar(255) NOT NULL,

627

`angle` int(11) NOT NULL,

628

PRIMARY KEY (`image`)

629

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

630

SET character_set_client = @saved_cs_client;

631

632

--

633

--

634

635

LOCK TABLES `gallerymetadata` WRITE;

636

/*!40000 ALTER TABLE `gallerymetadata` DISABLE KEYS */;

637

/*!40000 ALTER TABLE `gallerymetadata` ENABLE KEYS */;

638

UNLOCK TABLES;

639

640

--

641

--

642

643

DROP TABLE IF EXISTS `gamemetadata`;

644

SET @saved_cs_client = @@character_set_client;

645

SET character_set_client = utf8;

646

CREATE TABLE `gamemetadata` (

647

`system` varchar(128) NOT NULL default '',

648

`romname` varchar(128) NOT NULL default '',

649

`gamename` varchar(128) NOT NULL default '',

650

`genre` varchar(128) NOT NULL default '',

651

`year` varchar(10) NOT NULL default '',

652

`publisher` varchar(128) NOT NULL default '',

653

`favorite` tinyint(1) default NULL,

654

`rompath` varchar(255) NOT NULL default '',

655

`gametype` varchar(64) NOT NULL default '',

656

`diskcount` tinyint(1) NOT NULL default '1',

657

`country` varchar(128) NOT NULL default '',

658

`crc_value` varchar(64) NOT NULL default '',

659

`display` tinyint(1) NOT NULL default '1',

660

`version` varchar(64) NOT NULL default '',

661

KEY `system` (`system`),

662

KEY `year` (`year`),

663

KEY `romname` (`romname`),

664

KEY `gamename` (`gamename`),

665

KEY `genre` (`genre`)

666

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

667

SET character_set_client = @saved_cs_client;

668

669

--

670

--

671

672

LOCK TABLES `gamemetadata` WRITE;

673

/*!40000 ALTER TABLE `gamemetadata` DISABLE KEYS */;

674

/*!40000 ALTER TABLE `gamemetadata` ENABLE KEYS */;

675

UNLOCK TABLES;

676

677

--

678

--

679

680

DROP TABLE IF EXISTS `gameplayers`;

681

SET @saved_cs_client = @@character_set_client;

682

SET character_set_client = utf8;

683

CREATE TABLE `gameplayers` (

684

`gameplayerid` int(10) unsigned NOT NULL auto_increment,

685

`playername` varchar(64) NOT NULL default '',

686

`workingpath` varchar(255) NOT NULL default '',

687

`rompath` varchar(255) NOT NULL default '',

688

`screenshots` varchar(255) NOT NULL default '',

689

`commandline` text NOT NULL,

690

`gametype` varchar(64) NOT NULL default '',

691

`extensions` varchar(128) NOT NULL default '',

692

`spandisks` tinyint(1) NOT NULL default '0',

693

PRIMARY KEY (`gameplayerid`),

694

UNIQUE KEY `playername` (`playername`)

695

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

696

SET character_set_client = @saved_cs_client;

697

698

--

699

--

700

701

LOCK TABLES `gameplayers` WRITE;

702

/*!40000 ALTER TABLE `gameplayers` DISABLE KEYS */;

703

/*!40000 ALTER TABLE `gameplayers` ENABLE KEYS */;

704

UNLOCK TABLES;

705

706

--

707

--

708

709

DROP TABLE IF EXISTS `housekeeping`;

710

SET @saved_cs_client = @@character_set_client;

711

SET character_set_client = utf8;

712

CREATE TABLE `housekeeping` (

713

`tag` varchar(64) NOT NULL default '',

714

`lastrun` datetime default NULL,

715

PRIMARY KEY (`tag`)

716

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

717

SET character_set_client = @saved_cs_client;

718

719

--

720

--

721

722

LOCK TABLES `housekeeping` WRITE;

723

/*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */;

724

INSERT INTO `housekeeping` VALUES ('DailyCleanup','2007-06-27 20:33:37'),('JobQueueRecover-OLDHOSTNAME','2007-06-27 20:33:37'),('BackupDB','2008-04-12 22:16:29');

725

/*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */;

726

UNLOCK TABLES;

727

728

--

729

--

730

731

DROP TABLE IF EXISTS `inputgroup`;

732

SET @saved_cs_client = @@character_set_client;

733

SET character_set_client = utf8;

734

CREATE TABLE `inputgroup` (

735

`cardinputid` int(10) unsigned NOT NULL,

736

`inputgroupid` int(10) unsigned NOT NULL,

737

`inputgroupname` varchar(32) NOT NULL

738

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

739

SET character_set_client = @saved_cs_client;

740

741

--

742

--

743

744

LOCK TABLES `inputgroup` WRITE;

745

/*!40000 ALTER TABLE `inputgroup` DISABLE KEYS */;

746

/*!40000 ALTER TABLE `inputgroup` ENABLE KEYS */;

747

UNLOCK TABLES;

748

749

--

750

--

751

752

DROP TABLE IF EXISTS `inuseprograms`;

753

SET @saved_cs_client = @@character_set_client;

754

SET character_set_client = utf8;

755

CREATE TABLE `inuseprograms` (

756

`chanid` int(10) unsigned NOT NULL default '0',

757

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

758

`recusage` varchar(128) NOT NULL default '',

759

`lastupdatetime` datetime NOT NULL default '0000-00-00 00:00:00',

760

`hostname` varchar(255) NOT NULL default '',

761

`rechost` varchar(64) NOT NULL,

762

`recdir` varchar(255) NOT NULL default '',

763

KEY `chanid` (`chanid`,`starttime`),

764

KEY `recusage` (`recusage`,`lastupdatetime`)

765

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

766

SET character_set_client = @saved_cs_client;

767

768

--

769

--

770

771

LOCK TABLES `inuseprograms` WRITE;

772

/*!40000 ALTER TABLE `inuseprograms` DISABLE KEYS */;

773

/*!40000 ALTER TABLE `inuseprograms` ENABLE KEYS */;

774

UNLOCK TABLES;

775

776

--

777

--

778

779

DROP TABLE IF EXISTS `jobqueue`;

780

SET @saved_cs_client = @@character_set_client;

781

SET character_set_client = utf8;

782

CREATE TABLE `jobqueue` (

783

`id` int(11) NOT NULL auto_increment,

784

`chanid` int(10) NOT NULL default '0',

785

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

786

`inserttime` datetime NOT NULL default '0000-00-00 00:00:00',

787

`type` int(11) NOT NULL default '0',

788

`cmds` int(11) NOT NULL default '0',

789

`flags` int(11) NOT NULL default '0',

790

`status` int(11) NOT NULL default '0',

791

`statustime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

792

`hostname` varchar(255) NOT NULL default '',

793

`args` blob NOT NULL,

794

`comment` varchar(128) NOT NULL default '',

795

`schedruntime` datetime NOT NULL default '2007-01-01 00:00:00',

796

PRIMARY KEY (`id`),

797

UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)

798

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

799

SET character_set_client = @saved_cs_client;

800

801

--

802

--

803

804

LOCK TABLES `jobqueue` WRITE;

805

/*!40000 ALTER TABLE `jobqueue` DISABLE KEYS */;

806

/*!40000 ALTER TABLE `jobqueue` ENABLE KEYS */;

807

UNLOCK TABLES;

808

809

--

810

--

811

812

DROP TABLE IF EXISTS `jumppoints`;

813

SET @saved_cs_client = @@character_set_client;

814

SET character_set_client = utf8;

815

CREATE TABLE `jumppoints` (

816

`destination` varchar(128) NOT NULL default '',

817

`description` varchar(255) default NULL,

818

`keylist` varchar(128) default NULL,

819

`hostname` varchar(255) NOT NULL default '',

820

PRIMARY KEY (`destination`,`hostname`)

821

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

822

SET character_set_client = @saved_cs_client;

823

824

--

825

--

826

827

LOCK TABLES `jumppoints` WRITE;

828

/*!40000 ALTER TABLE `jumppoints` DISABLE KEYS */;

829

INSERT INTO `jumppoints` VALUES ('Reload Theme',NULL,'','OLDHOSTNAME'),('Main Menu',NULL,'','OLDHOSTNAME'),('Program Guide',NULL,'','OLDHOSTNAME'),('Program Finder',NULL,'','OLDHOSTNAME'),('Manage Recordings / Fix Conflicts',NULL,'','OLDHOSTNAME'),('Program Recording Priorities',NULL,'','OLDHOSTNAME'),('Channel Recording Priorities',NULL,'','OLDHOSTNAME'),('TV Recording Playback',NULL,'','OLDHOSTNAME'),('TV Recording Deletion',NULL,'','OLDHOSTNAME'),('Live TV',NULL,'','OLDHOSTNAME'),('Live TV In Guide',NULL,'','OLDHOSTNAME'),('Manual Record Scheduling',NULL,'','OLDHOSTNAME'),('Status Screen',NULL,'','OLDHOSTNAME'),('Previously Recorded',NULL,'','OLDHOSTNAME'),('Play DVD',NULL,'','OLDHOSTNAME'),('Play VCD',NULL,'','OLDHOSTNAME'),('Rip DVD',NULL,'','OLDHOSTNAME'),('Netflix Browser',NULL,'','OLDHOSTNAME'),('Netflix Queue',NULL,'','OLDHOSTNAME'),('Netflix History',NULL,'','OLDHOSTNAME'),('MythGallery',NULL,'','OLDHOSTNAME'),('MythGame',NULL,'','OLDHOSTNAME'),('Play music',NULL,'','OLDHOSTNAME'),('Select music playlists',NULL,'','OLDHOSTNAME'),('Rip CD',NULL,'','OLDHOSTNAME'),('Scan music',NULL,'','OLDHOSTNAME'),('MythNews',NULL,'','OLDHOSTNAME'),('MythVideo',NULL,'','OLDHOSTNAME'),('Video Manager',NULL,'','OLDHOSTNAME'),('Video Browser',NULL,'','OLDHOSTNAME'),('Video Listings',NULL,'','OLDHOSTNAME'),('Video Gallery',NULL,'','OLDHOSTNAME'),('MythWeather',NULL,'','OLDHOSTNAME');

830

/*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */;

831

UNLOCK TABLES;

832

833

--

834

--

835

836

DROP TABLE IF EXISTS `keybindings`;

837

SET @saved_cs_client = @@character_set_client;

838

SET character_set_client = utf8;

839

CREATE TABLE `keybindings` (

840

`context` varchar(32) NOT NULL default '',

841

`action` varchar(32) NOT NULL default '',

842

`description` varchar(255) default NULL,

843

`keylist` varchar(128) default NULL,

844

`hostname` varchar(255) NOT NULL default '',

845

PRIMARY KEY (`context`,`action`,`hostname`)

846

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

847

SET character_set_client = @saved_cs_client;

848

849

--

850

--

851

852

LOCK TABLES `keybindings` WRITE;

853

/*!40000 ALTER TABLE `keybindings` DISABLE KEYS */;

854

INSERT INTO `keybindings` VALUES ('Global','UP','Up Arrow','Up','OLDHOSTNAME'),('Global','DOWN','Down Arrow','Down','OLDHOSTNAME'),('Global','LEFT','Left Arrow','Left','OLDHOSTNAME'),('Global','RIGHT','Right Arrow','Right','OLDHOSTNAME'),('Global','SELECT','Select','Return,Enter,Space','OLDHOSTNAME'),('Global','ESCAPE','Escape','Esc','OLDHOSTNAME'),('Global','MENU','Pop-up menu','M','OLDHOSTNAME'),('Global','INFO','More information','I','OLDHOSTNAME'),('Global','PAGEUP','Page Up','PgUp','OLDHOSTNAME'),('Global','PAGEDOWN','Page Down','PgDown','OLDHOSTNAME'),('Global','PREVVIEW','Previous View','Home','OLDHOSTNAME'),('Global','NEXTVIEW','Next View','End','OLDHOSTNAME'),('Global','HELP','Help','F1','OLDHOSTNAME'),('Global','EJECT','Eject Removable Media','','OLDHOSTNAME'),('Global','0','0','0','OLDHOSTNAME'),('Global','1','1','1','OLDHOSTNAME'),('Global','2','2','2','OLDHOSTNAME'),('Global','3','3','3','OLDHOSTNAME'),('Global','4','4','4','OLDHOSTNAME'),('Global','5','5','5','OLDHOSTNAME'),('Global','6','6','6','OLDHOSTNAME'),('Global','7','7','7','OLDHOSTNAME'),('Global','8','8','8','OLDHOSTNAME'),('Global','9','9','9','OLDHOSTNAME'),('qt','DELETE','Delete','D','OLDHOSTNAME'),('qt','EDIT','Edit','E','OLDHOSTNAME'),('TV Frontend','PAGEUP','Page Up','3','OLDHOSTNAME'),('TV Frontend','PAGEDOWN','Page Down','9','OLDHOSTNAME'),('TV Frontend','DELETE','Delete Program','D','OLDHOSTNAME'),('TV Frontend','PLAYBACK','Play Program','P','OLDHOSTNAME'),('TV Frontend','TOGGLERECORD','Toggle recording status of current program','R','OLDHOSTNAME'),('TV Frontend','DAYLEFT','Page the program guide back one day','Home,7','OLDHOSTNAME'),('TV Frontend','DAYRIGHT','Page the program guide forward one day','End,1','OLDHOSTNAME'),('TV Frontend','PAGELEFT','Page the program guide left',',,<','OLDHOSTNAME'),('TV Frontend','PAGERIGHT','Page the program guide right','>,.','OLDHOSTNAME'),('TV Frontend','TOGGLEFAV','Toggle the current channel as a favorite','?','OLDHOSTNAME'),('TV Frontend','NEXTFAV','Toggle showing all channels or just favorites in the program guide.','/','OLDHOSTNAME'),('TV Frontend','CHANUPDATE','Switch channels without exiting guide in Live TV mode.','X','OLDHOSTNAME'),('TV Frontend','RANKINC','Increase program or channel rank','Right','OLDHOSTNAME'),('TV Frontend','RANKDEC','Decrease program or channel rank','Left','OLDHOSTNAME'),('TV Frontend','UPCOMING','List upcoming episodes','O','OLDHOSTNAME'),('TV Frontend','DETAILS','Show program details','U','OLDHOSTNAME'),('TV Frontend','VIEWCARD','Switch Capture Card view','Y','OLDHOSTNAME'),('TV Frontend','CUSTOMEDIT','Edit Custom Record Rule','E','OLDHOSTNAME'),('TV Playback','CLEAROSD','Clear OSD','Backspace','OLDHOSTNAME'),('TV Playback','PAUSE','Pause','P','OLDHOSTNAME'),('TV Playback','DELETE','Delete Program','D','OLDHOSTNAME'),('TV Playback','SEEKFFWD','Fast Forward','Right','OLDHOSTNAME'),('TV Playback','SEEKRWND','Rewind','Left','OLDHOSTNAME'),('TV Playback','ARBSEEK','Arbitrary Seek','*','OLDHOSTNAME'),('TV Playback','CHANNELUP','Channel up','Up','OLDHOSTNAME'),('TV Playback','CHANNELDOWN','Channel down','Down','OLDHOSTNAME'),('TV Playback','NEXTFAV','Switch to the next favorite channel','/','OLDHOSTNAME'),('TV Playback','PREVCHAN','Switch to the previous channel','H','OLDHOSTNAME'),('TV Playback','JUMPFFWD','Jump ahead','PgDown','OLDHOSTNAME'),('TV Playback','JUMPRWND','Jump back','PgUp','OLDHOSTNAME'),('TV Playback','JUMPBKMRK','Jump to bookmark','K','OLDHOSTNAME'),('TV Playback','FFWDSTICKY','Fast Forward (Sticky) or Forward one frame while paused','>,.','OLDHOSTNAME'),('TV Playback','RWNDSTICKY','Rewind (Sticky) or Rewind one frame while paused',',,<','OLDHOSTNAME'),('TV Playback','SKIPCOMMERCIAL','Skip Commercial','Z,End','OLDHOSTNAME'),('TV Playback','SKIPCOMMBACK','Skip Commercial (Reverse)','Q,Home','OLDHOSTNAME'),('TV Playback','JUMPSTART','Jump to the start of the recording.','Ctrl+B','OLDHOSTNAME'),('TV Playback','TOGGLEBROWSE','Toggle channel browse mode','O','OLDHOSTNAME'),('TV Playback','TOGGLERECORD','Toggle recording status of current program','R','OLDHOSTNAME'),('TV Playback','TOGGLEFAV','Toggle the current channel as a favorite','?','OLDHOSTNAME'),('TV Playback','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','OLDHOSTNAME'),('TV Playback','VOLUMEUP','Volume up','],},F11,Volume Up','OLDHOSTNAME'),('TV Playback','MUTE','Mute','|,\\,F9,Volume Mute','OLDHOSTNAME'),('TV Playback','TOGGLEPIPMODE','Toggle Picture-in-Picture mode','V','OLDHOSTNAME'),('TV Playback','TOGGLEPIPWINDOW','Toggle active PiP window','B','OLDHOSTNAME'),('TV Playback','SWAPPIP','Swap PiP/Main','N','OLDHOSTNAME'),('TV Playback','TOGGLECC','Toggle any captions','T','OLDHOSTNAME'),('TV Playback','TOGGLETTC','Toggle Teletext Captions','','OLDHOSTNAME'),('TV Playback','TOGGLESUBTITLE','Toggle Subtitles','','OLDHOSTNAME'),('TV Playback','TOGGLECC608','Toggle VBI CC','','OLDHOSTNAME'),('TV Playback','TOGGLECC708','Toggle ATSC CC','','OLDHOSTNAME'),('TV Playback','TOGGLETTM','Toggle Teletext Menu','','OLDHOSTNAME'),('TV Playback','SELECTAUDIO_0','Play audio track 1','','OLDHOSTNAME'),('TV Playback','SELECTAUDIO_1','Play audio track 2','','OLDHOSTNAME'),('TV Playback','SELECTSUBTITLE_0','Display subtitle 1','','OLDHOSTNAME'),('TV Playback','SELECTSUBTITLE_1','Display subtitle 2','','OLDHOSTNAME'),('TV Playback','SELECTCC608_0','Display VBI CC1','','OLDHOSTNAME'),('TV Playback','SELECTCC608_1','Display VBI CC2','','OLDHOSTNAME'),('TV Playback','SELECTCC608_2','Display VBI CC3','','OLDHOSTNAME'),('TV Playback','SELECTCC608_3','Display VBI CC4','','OLDHOSTNAME'),('TV Playback','SELECTCC708_0','Display ATSC CC1','','OLDHOSTNAME'),('TV Playback','SELECTCC708_1','Display ATSC CC2','','OLDHOSTNAME'),('TV Playback','SELECTCC708_2','Display ATSC CC3','','OLDHOSTNAME'),('TV Playback','SELECTCC708_3','Display ATSC CC4','','OLDHOSTNAME'),('TV Playback','NEXTAUDIO','Next audio track','+','OLDHOSTNAME'),('TV Playback','PREVAUDIO','Previous audio track','-','OLDHOSTNAME'),('TV Playback','NEXTSUBTITLE','Next subtitle track','','OLDHOSTNAME'),('TV Playback','PREVSUBTITLE','Previous subtitle track','','OLDHOSTNAME'),('TV Playback','NEXTCC608','Next VBI CC track','','OLDHOSTNAME'),('TV Playback','PREVCC608','Previous VBI CC track','','OLDHOSTNAME'),('TV Playback','NEXTCC708','Next ATSC CC track','','OLDHOSTNAME'),('TV Playback','PREVCC708','Previous ATSC CC track','','OLDHOSTNAME'),('TV Playback','NEXTCC','Next of any captions','','OLDHOSTNAME'),('TV Playback','NEXTSCAN','Next video scan overidemode','','OLDHOSTNAME'),('TV Playback','QUEUETRANSCODE','Queue the current recording for transcoding','X','OLDHOSTNAME'),('TV Playback','SPEEDINC','Increase the playback speed','U','OLDHOSTNAME'),('TV Playback','SPEEDDEC','Decrease the playback speed','J','OLDHOSTNAME'),('TV Playback','ADJUSTSTRETCH','Turn on time stretch control','A','OLDHOSTNAME'),('TV Playback','STRETCHINC','Increase time stretch speed','','OLDHOSTNAME'),('TV Playback','STRETCHDEC','Decrease time stretch speed','','OLDHOSTNAME'),('TV Playback','TOGGLESTRETCH','Toggle time stretch speed','','OLDHOSTNAME'),('TV Playback','TOGGLEAUDIOSYNC','Turn on audio sync adjustment controls','','OLDHOSTNAME'),('TV Playback','TOGGLEPICCONTROLS','Playback picture adjustments','F','OLDHOSTNAME'),('TV Playback','TOGGLECHANCONTROLS','Recording picture adjustments for this channel','Ctrl+G','OLDHOSTNAME'),('TV Playback','TOGGLERECCONTROLS','Recording picture adjustments for this recorder','G','OLDHOSTNAME'),('TV Playback','TOGGLEEDIT','Start Edit Mode','E','OLDHOSTNAME'),('TV Playback','CYCLECOMMSKIPMODE','Cycle Commercial Skip mode','','OLDHOSTNAME'),('TV Playback','GUIDE','Show the Program Guide','S','OLDHOSTNAME'),('TV Playback','FINDER','Show the Program Finder','#','OLDHOSTNAME'),('TV Playback','TOGGLESLEEP','Toggle the Sleep Timer','F8','OLDHOSTNAME'),('TV Playback','PLAY','Play','Ctrl+P','OLDHOSTNAME'),('TV Playback','JUMPPREV','Jump to previously played recording','','OLDHOSTNAME'),('TV Playback','JUMPREC','Display menu of recorded programs to jump to','','OLDHOSTNAME'),('TV Playback','JUMPTODVDROOTMENU','Jump to the DVD Root Menu','','OLDHOSTNAME'),('TV Editing','CLEARMAP','Clear editing cut points','C,Q,Home','OLDHOSTNAME'),('TV Editing','INVERTMAP','Invert Begin/End cut points','I','OLDHOSTNAME'),('TV Editing','LOADCOMMSKIP','Load cut list from commercial skips','Z,End','OLDHOSTNAME'),('TV Editing','NEXTCUT','Jump to the next cut point','PgDown','OLDHOSTNAME'),('TV Editing','PREVCUT','Jump to the previous cut point','PgUp','OLDHOSTNAME'),('TV Editing','BIGJUMPREW','Jump back 10x the normal amount',',,<','OLDHOSTNAME'),('TV Editing','BIGJUMPFWD','Jump forward 10x the normal amount','>,.','OLDHOSTNAME'),('TV Editing','TOGGLEEDIT','Exit out of Edit Mode','E','OLDHOSTNAME'),('Teletext Menu','NEXTPAGE','Next Page','Down','OLDHOSTNAME'),('Teletext Menu','PREVPAGE','Previous Page','Up','OLDHOSTNAME'),('Teletext Menu','NEXTSUBPAGE','Next Subpage','Right','OLDHOSTNAME'),('Teletext Menu','PREVSUBPAGE','Previous Subpage','Left','OLDHOSTNAME'),('Teletext Menu','TOGGLETT','Toggle Teletext','T','OLDHOSTNAME'),('Teletext Menu','MENURED','Menu Red','F2','OLDHOSTNAME'),('Teletext Menu','MENUGREEN','Menu Green','F3','OLDHOSTNAME'),('Teletext Menu','MENUYELLOW','Menu Yellow','F4','OLDHOSTNAME'),('Teletext Menu','MENUBLUE','Menu Blue','F5','OLDHOSTNAME'),('Teletext Menu','MENUWHITE','Menu White','F6','OLDHOSTNAME'),('Teletext Menu','TOGGLEBACKGROUND','Toggle Background','F7','OLDHOSTNAME'),('Teletext Menu','REVEAL','Reveal hidden Text','F8','OLDHOSTNAME'),('TV Playback','MENURED','Menu Red','F2','OLDHOSTNAME'),('TV Playback','MENUGREEN','Menu Green','F3','OLDHOSTNAME'),('TV Playback','MENUYELLOW','Menu Yellow','F4','OLDHOSTNAME'),('TV Playback','MENUBLUE','Menu Blue','F5','OLDHOSTNAME'),('TV Playback','TEXTEXIT','Menu Exit','F6','OLDHOSTNAME'),('TV Playback','MENUTEXT','Menu Text','F7','OLDHOSTNAME'),('TV Playback','MENUEPG','Menu EPG','F12','OLDHOSTNAME'),('Archive','TOGGLECUT','Toggle use cut list state for selected program','C','OLDHOSTNAME'),('NetFlix','MOVETOTOP','Moves movie to top of queue','1','OLDHOSTNAME'),('NetFlix','REMOVE','Removes movie from queue','D','OLDHOSTNAME'),('Gallery','PLAY','Start/Stop Slideshow','P','OLDHOSTNAME'),('Gallery','HOME','Go to the first image in thumbnail view','Home','OLDHOSTNAME'),('Gallery','END','Go to the last image in thumbnail view','End','OLDHOSTNAME'),('Gallery','MENU','Toggle activating menu in thumbnail view','M','OLDHOSTNAME'),('Gallery','SLIDESHOW','Start Slideshow in thumbnail view','S','OLDHOSTNAME'),('Gallery','RANDOMSHOW','Start Random Slideshow in thumbnail view','R','OLDHOSTNAME'),('Gallery','ROTRIGHT','Rotate image right 90 degrees','],3','OLDHOSTNAME'),('Gallery','ROTLEFT','Rotate image left 90 degrees','[,1','OLDHOSTNAME'),('Gallery','ZOOMOUT','Zoom image out','7','OLDHOSTNAME'),('Gallery','ZOOMIN','Zoom image in','9','OLDHOSTNAME'),('Gallery','SCROLLUP','Scroll image up','2','OLDHOSTNAME'),('Gallery','SCROLLLEFT','Scroll image left','4','OLDHOSTNAME'),('Gallery','SCROLLRIGHT','Scroll image right','6','OLDHOSTNAME'),('Gallery','SCROLLDOWN','Scroll image down','8','OLDHOSTNAME'),('Gallery','RECENTER','Recenter image','5','OLDHOSTNAME'),('Gallery','FULLSIZE','Full-size (un-zoom) image','0','OLDHOSTNAME'),('Gallery','UPLEFT','Go to the upper-left corner of the image','PgUp','OLDHOSTNAME'),('Gallery','LOWRIGHT','Go to the lower-right corner of the image','PgDown','OLDHOSTNAME'),('Gallery','INFO','Toggle Showing Information about Image','I','OLDHOSTNAME'),('Gallery','DELETE','Delete marked images or current image if none are marked','D','OLDHOSTNAME'),('Gallery','MARK','Mark image','T','OLDHOSTNAME'),('Game','TOGGLEFAV','Toggle the current game as a favorite','?,/','OLDHOSTNAME'),('Game','INCSEARCH','Show incremental search dialog','Ctrl+S','OLDHOSTNAME'),('Game','INCSEARCHNEXT','Incremental search find next match','Ctrl+N','OLDHOSTNAME'),('Music','DELETE','Delete track from playlist','D','OLDHOSTNAME'),('Music','NEXTTRACK','Move to the next track','>,.,Z,End','OLDHOSTNAME'),('Music','PREVTRACK','Move to the previous track',',,<,Q,Home','OLDHOSTNAME'),('Music','FFWD','Fast forward','PgDown','OLDHOSTNAME'),('Music','RWND','Rewind','PgUp','OLDHOSTNAME'),('Music','PAUSE','Pause/Start playback','P','OLDHOSTNAME'),('Music','STOP','Stop playback','O','OLDHOSTNAME'),('Music','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','OLDHOSTNAME'),('Music','VOLUMEUP','Volume up','],},F11,Volume Up','OLDHOSTNAME'),('Music','MUTE','Mute','|,\\,F9,Volume Mute','OLDHOSTNAME'),('Music','CYCLEVIS','Cycle visualizer mode','6','OLDHOSTNAME'),('Music','BLANKSCR','Blank screen','5','OLDHOSTNAME'),('Music','THMBUP','Increase rating','9','OLDHOSTNAME'),('Music','THMBDOWN','Decrease rating','7','OLDHOSTNAME'),('Music','REFRESH','Refresh music tree','8','OLDHOSTNAME'),('Music','FILTER','Filter All My Music','F','OLDHOSTNAME'),('Music','INCSEARCH','Show incremental search dialog','Ctrl+S','OLDHOSTNAME'),('Music','INCSEARCHNEXT','Incremental search find next match','Ctrl+N','OLDHOSTNAME'),('News','RETRIEVENEWS','Update news items','I','OLDHOSTNAME'),('News','FORCERETRIEVE','Force update news items','M','OLDHOSTNAME'),('News','CANCEL','Cancel news item updating','C','OLDHOSTNAME'),('Phone','0','0','0','OLDHOSTNAME'),('Phone','1','1','1','OLDHOSTNAME'),('Phone','2','2','2','OLDHOSTNAME'),('Phone','3','3','3','OLDHOSTNAME'),('Phone','4','4','4','OLDHOSTNAME'),('Phone','5','5','5','OLDHOSTNAME'),('Phone','6','6','6','OLDHOSTNAME'),('Phone','7','7','7','OLDHOSTNAME'),('Phone','8','8','8','OLDHOSTNAME'),('Phone','9','9','9','OLDHOSTNAME'),('Phone','HASH','HASH','#','OLDHOSTNAME'),('Phone','STAR','STAR','*','OLDHOSTNAME'),('Phone','Up','Up','Up','OLDHOSTNAME'),('Phone','Down','Down','Down','OLDHOSTNAME'),('Phone','Left','Left','Left','OLDHOSTNAME'),('Phone','Right','Right','Right','OLDHOSTNAME'),('Phone','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','OLDHOSTNAME'),('Phone','VOLUMEUP','Volume up','],},F11,Volume Up','OLDHOSTNAME'),('Phone','ZOOMIN','Zoom the video window in','>,.,Z,End','OLDHOSTNAME'),('Phone','ZOOMOUT','Zoom the video window out',',,<,Q,Home','OLDHOSTNAME'),('Phone','FULLSCRN','Show received video full-screen','P','OLDHOSTNAME'),('Phone','HANGUP','Hangup an active call','O','OLDHOSTNAME'),('Phone','MUTE','Mute','|,\\,F9,Volume Mute','OLDHOSTNAME'),('Phone','LOOPBACK','Loopback Video','L','OLDHOSTNAME'),('Video','FILTER','Open video filter dialog','F','OLDHOSTNAME'),('Video','DELETE','Delete video','D','OLDHOSTNAME'),('Video','BROWSE','Change browsable in video manager','B','OLDHOSTNAME'),('Video','INCPARENT','Increase Parental Level','],},F11','OLDHOSTNAME'),('Video','DECPARENT','Decrease Parental Level','[,{,F10','OLDHOSTNAME'),('Video','HOME','Go to the first video','Home','OLDHOSTNAME'),('Video','END','Go to the last video','End','OLDHOSTNAME'),('Weather','PAUSE','Pause current page','P','OLDHOSTNAME');

855

/*!40000 ALTER TABLE `keybindings` ENABLE KEYS */;

856

UNLOCK TABLES;

857

858

--

859

--

860

861

DROP TABLE IF EXISTS `keyword`;

862

SET @saved_cs_client = @@character_set_client;

863

SET character_set_client = utf8;

864

CREATE TABLE `keyword` (

865

`phrase` varchar(128) NOT NULL default '',

866

`searchtype` int(10) unsigned NOT NULL default '3',

867

UNIQUE KEY `phrase` (`phrase`,`searchtype`)

868

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

869

SET character_set_client = @saved_cs_client;

870

871

--

872

--

873

874

LOCK TABLES `keyword` WRITE;

875

/*!40000 ALTER TABLE `keyword` DISABLE KEYS */;

876

/*!40000 ALTER TABLE `keyword` ENABLE KEYS */;

877

UNLOCK TABLES;

878

879

--

880

--

881

882

DROP TABLE IF EXISTS `music_albums`;

883

SET @saved_cs_client = @@character_set_client;

884

SET character_set_client = utf8;

885

CREATE TABLE `music_albums` (

886

`album_id` int(11) unsigned NOT NULL auto_increment,

887

`artist_id` int(11) unsigned NOT NULL default '0',

888

`album_name` varchar(255) NOT NULL default '',

889

`year` smallint(6) NOT NULL default '0',

890

`compilation` tinyint(1) unsigned NOT NULL default '0',

891

PRIMARY KEY (`album_id`),

892

KEY `idx_album_name` (`album_name`)

893

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

894

SET character_set_client = @saved_cs_client;

895

896

--

897

--

898

899

LOCK TABLES `music_albums` WRITE;

900

/*!40000 ALTER TABLE `music_albums` DISABLE KEYS */;

901

/*!40000 ALTER TABLE `music_albums` ENABLE KEYS */;

902

UNLOCK TABLES;

903

904

--

905

--

906

907

DROP TABLE IF EXISTS `music_artists`;

908

SET @saved_cs_client = @@character_set_client;

909

SET character_set_client = utf8;

910

CREATE TABLE `music_artists` (

911

`artist_id` int(11) unsigned NOT NULL auto_increment,

912

`artist_name` varchar(255) NOT NULL default '',

913

PRIMARY KEY (`artist_id`),

914

KEY `idx_artist_name` (`artist_name`)

915

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

916

SET character_set_client = @saved_cs_client;

917

918

--

919

--

920

921

LOCK TABLES `music_artists` WRITE;

922

/*!40000 ALTER TABLE `music_artists` DISABLE KEYS */;

923

/*!40000 ALTER TABLE `music_artists` ENABLE KEYS */;

924

UNLOCK TABLES;

925

926

--

927

--

928

929

DROP TABLE IF EXISTS `music_genres`;

930

SET @saved_cs_client = @@character_set_client;

931

SET character_set_client = utf8;

932

CREATE TABLE `music_genres` (

933

`genre_id` int(11) unsigned NOT NULL auto_increment,

934

`genre` varchar(25) NOT NULL default '',

935

PRIMARY KEY (`genre_id`),

936

KEY `idx_genre` (`genre`)

937

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

938

SET character_set_client = @saved_cs_client;

939

940

--

941

--

942

943

LOCK TABLES `music_genres` WRITE;

944

/*!40000 ALTER TABLE `music_genres` DISABLE KEYS */;

945

/*!40000 ALTER TABLE `music_genres` ENABLE KEYS */;

946

UNLOCK TABLES;

947

948

--

949

--

950

951

DROP TABLE IF EXISTS `music_playlists`;

952

SET @saved_cs_client = @@character_set_client;

953

SET character_set_client = utf8;

954

CREATE TABLE `music_playlists` (

955

`playlist_id` int(11) unsigned NOT NULL auto_increment,

956

`playlist_name` varchar(255) NOT NULL default '',

957

`playlist_songs` text NOT NULL,

958

`last_accessed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

959

`length` int(11) unsigned NOT NULL default '0',

960

`songcount` smallint(8) unsigned NOT NULL default '0',

961

`hostname` varchar(255) NOT NULL default '',

962

PRIMARY KEY (`playlist_id`)

963

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

964

SET character_set_client = @saved_cs_client;

965

966

--

967

--

968

969

LOCK TABLES `music_playlists` WRITE;

970

/*!40000 ALTER TABLE `music_playlists` DISABLE KEYS */;

971

/*!40000 ALTER TABLE `music_playlists` ENABLE KEYS */;

972

UNLOCK TABLES;

973

974

--

975

--

976

977

DROP TABLE IF EXISTS `music_smartplaylist_categories`;

978

SET @saved_cs_client = @@character_set_client;

979

SET character_set_client = utf8;

980

CREATE TABLE `music_smartplaylist_categories` (

981

`categoryid` int(10) unsigned NOT NULL auto_increment,

982

`name` varchar(128) NOT NULL,

983

PRIMARY KEY (`categoryid`),

984

KEY `name` (`name`)

985

) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

986

SET character_set_client = @saved_cs_client;

987

988

--

989

--

990

991

LOCK TABLES `music_smartplaylist_categories` WRITE;

992

/*!40000 ALTER TABLE `music_smartplaylist_categories` DISABLE KEYS */;

993

INSERT INTO `music_smartplaylist_categories` VALUES (1,'Decades'),(2,'Favourite Tracks'),(3,'New Tracks');

994

/*!40000 ALTER TABLE `music_smartplaylist_categories` ENABLE KEYS */;

995

UNLOCK TABLES;

996

997

--

998

--

999

1000

DROP TABLE IF EXISTS `music_smartplaylist_items`;

1001

SET @saved_cs_client = @@character_set_client;

1002

SET character_set_client = utf8;

1003

CREATE TABLE `music_smartplaylist_items` (

1004

`smartplaylistitemid` int(10) unsigned NOT NULL auto_increment,

1005

`smartplaylistid` int(10) unsigned NOT NULL,

1006

`field` varchar(50) NOT NULL,

1007

`operator` varchar(20) NOT NULL,

1008

`value1` varchar(255) NOT NULL,

1009

`value2` varchar(255) NOT NULL,

1010

PRIMARY KEY (`smartplaylistitemid`),

1011

KEY `smartplaylistid` (`smartplaylistid`)

1012

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

1013

SET character_set_client = @saved_cs_client;

1014

1015

--

1016

--

1017

1018

LOCK TABLES `music_smartplaylist_items` WRITE;

1019

/*!40000 ALTER TABLE `music_smartplaylist_items` DISABLE KEYS */;

1020

INSERT INTO `music_smartplaylist_items` VALUES (1,1,'Year','is between','1960','1969'),(2,2,'Year','is between','1970','1979'),(3,3,'Year','is between','1980','1989'),(4,4,'Year','is between','1990','1999'),(5,5,'Year','is between','2000','2009'),(6,6,'Rating','is greater than','7','0'),(7,7,'Play Count','is greater than','0','0'),(8,8,'Play Count','is equal to','0','0');

1021

/*!40000 ALTER TABLE `music_smartplaylist_items` ENABLE KEYS */;

1022

UNLOCK TABLES;

1023

1024

--

1025

--

1026

1027

DROP TABLE IF EXISTS `music_smartplaylists`;

1028

SET @saved_cs_client = @@character_set_client;

1029

SET character_set_client = utf8;

1030

CREATE TABLE `music_smartplaylists` (

1031

`smartplaylistid` int(10) unsigned NOT NULL auto_increment,

1032

`name` varchar(128) NOT NULL,

1033

`categoryid` int(10) unsigned NOT NULL,

1034

`matchtype` set('All','Any') NOT NULL default 'All',

1035

`orderby` varchar(128) NOT NULL default '',

1036

`limitto` int(10) unsigned NOT NULL default '0',

1037

PRIMARY KEY (`smartplaylistid`),

1038

KEY `name` (`name`),

1039

KEY `categoryid` (`categoryid`)

1040

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

1041

SET character_set_client = @saved_cs_client;

1042

1043

--

1044

--

1045

1046

LOCK TABLES `music_smartplaylists` WRITE;

1047

/*!40000 ALTER TABLE `music_smartplaylists` DISABLE KEYS */;

1048

INSERT INTO `music_smartplaylists` VALUES (1,'1960\'s',1,'All','Artist (A)',0),(2,'1970\'s',1,'All','Artist (A)',0),(3,'1980\'s',1,'All','Artist (A)',0),(4,'1990\'s',1,'All','Artist (A)',0),(5,'2000\'s',1,'All','Artist (A)',0),(6,'Favorite Tracks',2,'All','Artist (A), Album (A)',0),(7,'100 Most Played Tracks',2,'All','Play Count (D)',100),(8,'Never Played Tracks',3,'All','Artist (A), Album (A)',0);

1049

/*!40000 ALTER TABLE `music_smartplaylists` ENABLE KEYS */;

1050

UNLOCK TABLES;

1051

1052

--

1053

--

1054

1055

DROP TABLE IF EXISTS `music_songs`;

1056

SET @saved_cs_client = @@character_set_client;

1057

SET character_set_client = utf8;

1058

CREATE TABLE `music_songs` (

1059

`song_id` int(11) unsigned NOT NULL auto_increment,

1060

`filename` text NOT NULL,

1061

`name` varchar(255) NOT NULL default '',

1062

`track` smallint(6) unsigned NOT NULL default '0',

1063

`artist_id` int(11) unsigned NOT NULL default '0',

1064

`album_id` int(11) unsigned NOT NULL default '0',

1065

`genre_id` int(11) unsigned NOT NULL default '0',

1066

`year` smallint(6) NOT NULL default '0',

1067

`length` int(11) unsigned NOT NULL default '0',

1068

`numplays` int(11) unsigned NOT NULL default '0',

1069

`rating` tinyint(4) unsigned NOT NULL default '0',

1070

`lastplay` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

1071

`date_entered` datetime default NULL,

1072

`date_modified` datetime default NULL,

1073

`format` varchar(4) NOT NULL default '0',

1074

`mythdigest` varchar(255) default NULL,

1075

`size` bigint(20) unsigned default NULL,

1076

`description` varchar(255) default NULL,

1077

`comment` varchar(255) default NULL,

1078

`disc_count` smallint(5) unsigned default '0',

1079

`disc_number` smallint(5) unsigned default '0',

1080

`track_count` smallint(5) unsigned default '0',

1081

`start_time` int(10) unsigned default '0',

1082

`stop_time` int(10) unsigned default NULL,

1083

`eq_preset` varchar(255) default NULL,

1084

`relative_volume` tinyint(4) default '0',

1085

`sample_rate` int(10) unsigned default '0',

1086

`bitrate` int(10) unsigned default '0',

1087

`bpm` smallint(5) unsigned default NULL,

1088

PRIMARY KEY (`song_id`),

1089

KEY `idx_name` (`name`),

1090

KEY `idx_mythdigest` (`mythdigest`)

1091

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1092

SET character_set_client = @saved_cs_client;

1093

1094

--

1095

--

1096

1097

LOCK TABLES `music_songs` WRITE;

1098

/*!40000 ALTER TABLE `music_songs` DISABLE KEYS */;

1099

/*!40000 ALTER TABLE `music_songs` ENABLE KEYS */;

1100

UNLOCK TABLES;

1101

1102

--

1103

--

1104

1105

DROP TABLE IF EXISTS `music_stats`;

1106

SET @saved_cs_client = @@character_set_client;

1107

SET character_set_client = utf8;

1108

CREATE TABLE `music_stats` (

1109

`num_artists` smallint(5) unsigned NOT NULL default '0',

1110

`num_albums` smallint(5) unsigned NOT NULL default '0',

1111

`num_songs` mediumint(8) unsigned NOT NULL default '0',

1112

`num_genres` tinyint(3) unsigned NOT NULL default '0',

1113

`total_time` varchar(12) NOT NULL default '0',

1114

`total_size` varchar(10) NOT NULL default '0'

1115

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1116

SET character_set_client = @saved_cs_client;

1117

1118

--

1119

--

1120

1121

LOCK TABLES `music_stats` WRITE;

1122

/*!40000 ALTER TABLE `music_stats` DISABLE KEYS */;

1123

/*!40000 ALTER TABLE `music_stats` ENABLE KEYS */;

1124

UNLOCK TABLES;

1125

1126

--

1127

--

1128

1129

DROP TABLE IF EXISTS `musicmetadata`;

1130

SET @saved_cs_client = @@character_set_client;

1131

SET character_set_client = utf8;

1132

CREATE TABLE `musicmetadata` (

1133

`intid` int(10) unsigned NOT NULL auto_increment,

1134

`artist` varchar(128) NOT NULL,

1135

`compilation_artist` varchar(128) NOT NULL,

1136

`album` varchar(128) NOT NULL,

1137

`title` varchar(128) NOT NULL,

1138

`genre` varchar(128) NOT NULL,

1139

`year` int(10) unsigned NOT NULL,

1140

`tracknum` int(10) unsigned NOT NULL,

1141

`length` int(10) unsigned NOT NULL,

1142

`filename` text NOT NULL,

1143

`rating` int(10) unsigned NOT NULL default '5',

1144

`lastplay` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

1145

`playcount` int(10) unsigned NOT NULL default '0',

1146

`mythdigest` varchar(255) default NULL,

1147

`size` bigint(20) unsigned default NULL,

1148

`date_added` datetime default NULL,

1149

`date_modified` datetime default NULL,

1150

`format` varchar(4) default NULL,

1151

`description` varchar(255) default NULL,

1152

`comment` varchar(255) default NULL,

1153

`compilation` tinyint(4) default '0',

1154

`composer` varchar(255) default NULL,

1155

`disc_count` smallint(5) unsigned default '0',

1156

`disc_number` smallint(5) unsigned default '0',

1157

`track_count` smallint(5) unsigned default '0',

1158

`start_time` int(10) unsigned default '0',

1159

`stop_time` int(10) unsigned default NULL,

1160

`eq_preset` varchar(255) default NULL,

1161

`relative_volume` tinyint(4) default '0',

1162

`sample_rate` int(10) unsigned default NULL,

1163

`bpm` smallint(5) unsigned default NULL,

1164

PRIMARY KEY (`intid`),

1165

KEY `artist` (`artist`),

1166

KEY `album` (`album`),

1167

KEY `title` (`title`),

1168

KEY `genre` (`genre`),

1169

KEY `mythdigest` (`mythdigest`),

1170

KEY `compilation_artist` (`compilation_artist`)

1171

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1172

SET character_set_client = @saved_cs_client;

1173

1174

--

1175

--

1176

1177

LOCK TABLES `musicmetadata` WRITE;

1178

/*!40000 ALTER TABLE `musicmetadata` DISABLE KEYS */;

1179

/*!40000 ALTER TABLE `musicmetadata` ENABLE KEYS */;

1180

UNLOCK TABLES;

1181

1182

--

1183

--

1184

1185

DROP TABLE IF EXISTS `musicplaylist`;

1186

SET @saved_cs_client = @@character_set_client;

1187

SET character_set_client = utf8;

1188

CREATE TABLE `musicplaylist` (

1189

`playlistid` int(10) unsigned NOT NULL auto_increment,

1190

`name` varchar(128) NOT NULL,

1191

`hostname` varchar(255) default NULL,

1192

`songlist` text NOT NULL,

1193

PRIMARY KEY (`playlistid`)

1194

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1195

SET character_set_client = @saved_cs_client;

1196

1197

--

1198

--

1199

1200

LOCK TABLES `musicplaylist` WRITE;

1201

/*!40000 ALTER TABLE `musicplaylist` DISABLE KEYS */;

1202

/*!40000 ALTER TABLE `musicplaylist` ENABLE KEYS */;

1203

UNLOCK TABLES;

1204

1205

--

1206

--

1207

1208

DROP TABLE IF EXISTS `mythlog`;

1209

SET @saved_cs_client = @@character_set_client;

1210

SET character_set_client = utf8;

1211

CREATE TABLE `mythlog` (

1212

`logid` int(10) unsigned NOT NULL auto_increment,

1213

`module` varchar(32) NOT NULL default '',

1214

`priority` int(11) NOT NULL default '0',

1215

`acknowledged` tinyint(1) default '0',

1216

`logdate` datetime default NULL,

1217

`host` varchar(128) default NULL,

1218

`message` varchar(255) NOT NULL default '',

1219

`details` text,

1220

PRIMARY KEY (`logid`),

1221

KEY `module` (`module`)

1222

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1223

SET character_set_client = @saved_cs_client;

1224

1225

--

1226

--

1227

1228

LOCK TABLES `mythlog` WRITE;

1229

/*!40000 ALTER TABLE `mythlog` DISABLE KEYS */;

1230

/*!40000 ALTER TABLE `mythlog` ENABLE KEYS */;

1231

UNLOCK TABLES;

1232

1233

--

1234

--

1235

1236

DROP TABLE IF EXISTS `networkiconmap`;

1237

SET @saved_cs_client = @@character_set_client;

1238

SET character_set_client = utf8;

1239

CREATE TABLE `networkiconmap` (

1240

`id` int(11) NOT NULL auto_increment,

1241

`network` varchar(20) NOT NULL default '',

1242

`url` varchar(255) NOT NULL default '',

1243

PRIMARY KEY (`id`),

1244

UNIQUE KEY `network` (`network`)

1245

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1246

SET character_set_client = @saved_cs_client;

1247

1248

--

1249

--

1250

1251

LOCK TABLES `networkiconmap` WRITE;

1252

/*!40000 ALTER TABLE `networkiconmap` DISABLE KEYS */;

1253

/*!40000 ALTER TABLE `networkiconmap` ENABLE KEYS */;

1254

UNLOCK TABLES;

1255

1256

--

1257

--

1258

1259

DROP TABLE IF EXISTS `oldfind`;

1260

SET @saved_cs_client = @@character_set_client;

1261

SET character_set_client = utf8;

1262

CREATE TABLE `oldfind` (

1263

`recordid` int(11) NOT NULL default '0',

1264

`findid` int(11) NOT NULL default '0',

1265

PRIMARY KEY (`recordid`,`findid`)

1266

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1267

SET character_set_client = @saved_cs_client;

1268

1269

--

1270

--

1271

1272

LOCK TABLES `oldfind` WRITE;

1273

/*!40000 ALTER TABLE `oldfind` DISABLE KEYS */;

1274

/*!40000 ALTER TABLE `oldfind` ENABLE KEYS */;

1275

UNLOCK TABLES;

1276

1277

--

1278

--

1279

1280

DROP TABLE IF EXISTS `oldprogram`;

1281

SET @saved_cs_client = @@character_set_client;

1282

SET character_set_client = utf8;

1283

CREATE TABLE `oldprogram` (

1284

`oldtitle` varchar(128) NOT NULL default '',

1285

`airdate` datetime NOT NULL default '0000-00-00 00:00:00',

1286

PRIMARY KEY (`oldtitle`)

1287

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1288

SET character_set_client = @saved_cs_client;

1289

1290

--

1291

--

1292

1293

LOCK TABLES `oldprogram` WRITE;

1294

/*!40000 ALTER TABLE `oldprogram` DISABLE KEYS */;

1295

/*!40000 ALTER TABLE `oldprogram` ENABLE KEYS */;

1296

UNLOCK TABLES;

1297

1298

--

1299

--

1300

1301

DROP TABLE IF EXISTS `oldrecorded`;

1302

SET @saved_cs_client = @@character_set_client;

1303

SET character_set_client = utf8;

1304

CREATE TABLE `oldrecorded` (

1305

`chanid` int(10) unsigned NOT NULL default '0',

1306

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1307

`endtime` datetime NOT NULL default '0000-00-00 00:00:00',

1308

`title` varchar(128) NOT NULL default '',

1309

`subtitle` varchar(128) NOT NULL default '',

1310

`description` text NOT NULL,

1311

`category` varchar(64) NOT NULL default '',

1312

`seriesid` varchar(40) NOT NULL default '',

1313

`programid` varchar(40) NOT NULL default '',

1314

`findid` int(11) NOT NULL default '0',

1315

`recordid` int(11) NOT NULL default '0',

1316

`station` varchar(20) NOT NULL default '',

1317

`rectype` int(10) unsigned NOT NULL default '0',

1318

`duplicate` tinyint(1) NOT NULL default '0',

1319

`recstatus` int(11) NOT NULL default '0',

1320

`reactivate` smallint(6) NOT NULL default '0',

1321

`generic` tinyint(1) default '0',

1322

PRIMARY KEY (`station`,`starttime`,`title`),

1323

KEY `endtime` (`endtime`),

1324

KEY `title` (`title`),

1325

KEY `seriesid` (`seriesid`),

1326

KEY `programid` (`programid`),

1327

KEY `recordid` (`recordid`),

1328

KEY `recstatus` (`recstatus`,`programid`,`seriesid`),

1329

KEY `recstatus_2` (`recstatus`,`title`,`subtitle`)

1330

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1331

SET character_set_client = @saved_cs_client;

1332

1333

--

1334

--

1335

1336

LOCK TABLES `oldrecorded` WRITE;

1337

/*!40000 ALTER TABLE `oldrecorded` DISABLE KEYS */;

1338

/*!40000 ALTER TABLE `oldrecorded` ENABLE KEYS */;

1339

UNLOCK TABLES;

1340

1341

--

1342

--

1343

1344

DROP TABLE IF EXISTS `people`;

1345

SET @saved_cs_client = @@character_set_client;

1346

SET character_set_client = utf8;

1347

CREATE TABLE `people` (

1348

`person` mediumint(8) unsigned NOT NULL auto_increment,

1349

`name` char(128) NOT NULL default '',

1350

PRIMARY KEY (`person`),

1351

UNIQUE KEY `name` (`name`(41))

1352

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1353

SET character_set_client = @saved_cs_client;

1354

1355

--

1356

--

1357

1358

LOCK TABLES `people` WRITE;

1359

/*!40000 ALTER TABLE `people` DISABLE KEYS */;

1360

/*!40000 ALTER TABLE `people` ENABLE KEYS */;

1361

UNLOCK TABLES;

1362

1363

--

1364

--

1365

1366

DROP TABLE IF EXISTS `phonecallhistory`;

1367

SET @saved_cs_client = @@character_set_client;

1368

SET character_set_client = utf8;

1369

CREATE TABLE `phonecallhistory` (

1370

`recid` int(10) unsigned NOT NULL auto_increment,

1371

`displayname` text NOT NULL,

1372

`url` text NOT NULL,

1373

`timestamp` text NOT NULL,

1374

`duration` int(10) unsigned NOT NULL,

1375

`directionin` int(10) unsigned NOT NULL,

1376

`directoryref` int(10) unsigned default NULL,

1377

PRIMARY KEY (`recid`)

1378

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1379

SET character_set_client = @saved_cs_client;

1380

1381

--

1382

--

1383

1384

LOCK TABLES `phonecallhistory` WRITE;

1385

/*!40000 ALTER TABLE `phonecallhistory` DISABLE KEYS */;

1386

/*!40000 ALTER TABLE `phonecallhistory` ENABLE KEYS */;

1387

UNLOCK TABLES;

1388

1389

--

1390

--

1391

1392

DROP TABLE IF EXISTS `phonedirectory`;

1393

SET @saved_cs_client = @@character_set_client;

1394

SET character_set_client = utf8;

1395

CREATE TABLE `phonedirectory` (

1396

`intid` int(10) unsigned NOT NULL auto_increment,

1397

`nickname` text NOT NULL,

1398

`firstname` text,

1399

`surname` text,

1400

`url` text NOT NULL,

1401

`directory` text NOT NULL,

1402

`photofile` text,

1403

`speeddial` int(10) unsigned NOT NULL,

1404

`onhomelan` int(10) unsigned default '0',

1405

PRIMARY KEY (`intid`)

1406

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

1407

SET character_set_client = @saved_cs_client;

1408

1409

--

1410

--

1411

1412

LOCK TABLES `phonedirectory` WRITE;

1413

/*!40000 ALTER TABLE `phonedirectory` DISABLE KEYS */;

1414

INSERT INTO `phonedirectory` VALUES (1,'Me(OLDHOSTNAME)','Local Myth Host','OLDHOSTNAME','','My MythTVs','',1,1);

1415

/*!40000 ALTER TABLE `phonedirectory` ENABLE KEYS */;

1416

UNLOCK TABLES;

1417

1418

--

1419

--

1420

1421

DROP TABLE IF EXISTS `pidcache`;

1422

SET @saved_cs_client = @@character_set_client;

1423

SET character_set_client = utf8;

1424

CREATE TABLE `pidcache` (

1425

`chanid` smallint(6) NOT NULL default '0',

1426

`pid` int(11) NOT NULL default '-1',

1427

`tableid` int(11) NOT NULL default '-1',

1428

KEY `chanid` (`chanid`)

1429

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1430

SET character_set_client = @saved_cs_client;

1431

1432

--

1433

--

1434

1435

LOCK TABLES `pidcache` WRITE;

1436

/*!40000 ALTER TABLE `pidcache` DISABLE KEYS */;

1437

/*!40000 ALTER TABLE `pidcache` ENABLE KEYS */;

1438

UNLOCK TABLES;

1439

1440

--

1441

--

1442

1443

DROP TABLE IF EXISTS `playgroup`;

1444

SET @saved_cs_client = @@character_set_client;

1445

SET character_set_client = utf8;

1446

CREATE TABLE `playgroup` (

1447

`name` varchar(32) NOT NULL default '',

1448

`titlematch` varchar(255) NOT NULL default '',

1449

`skipahead` int(11) NOT NULL default '0',

1450

`skipback` int(11) NOT NULL default '0',

1451

`timestretch` int(11) NOT NULL default '0',

1452

`jump` int(11) NOT NULL default '0',

1453

PRIMARY KEY (`name`)

1454

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1455

SET character_set_client = @saved_cs_client;

1456

1457

--

1458

--

1459

1460

LOCK TABLES `playgroup` WRITE;

1461

/*!40000 ALTER TABLE `playgroup` DISABLE KEYS */;

1462

INSERT INTO `playgroup` VALUES ('Default','',30,5,100,0);

1463

/*!40000 ALTER TABLE `playgroup` ENABLE KEYS */;

1464

UNLOCK TABLES;

1465

1466

--

1467

--

1468

1469

DROP TABLE IF EXISTS `powerpriority`;

1470

SET @saved_cs_client = @@character_set_client;

1471

SET character_set_client = utf8;

1472

CREATE TABLE `powerpriority` (

1473

`priorityname` varchar(64) NOT NULL,

1474

`recpriority` int(10) NOT NULL default '0',

1475

`selectclause` text NOT NULL,

1476

PRIMARY KEY (`priorityname`)

1477

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1478

SET character_set_client = @saved_cs_client;

1479

1480

--

1481

--

1482

1483

LOCK TABLES `powerpriority` WRITE;

1484

/*!40000 ALTER TABLE `powerpriority` DISABLE KEYS */;

1485

/*!40000 ALTER TABLE `powerpriority` ENABLE KEYS */;

1486

UNLOCK TABLES;

1487

1488

--

1489

--

1490

1491

DROP TABLE IF EXISTS `profilegroups`;

1492

SET @saved_cs_client = @@character_set_client;

1493

SET character_set_client = utf8;

1494

CREATE TABLE `profilegroups` (

1495

`id` int(10) unsigned NOT NULL auto_increment,

1496

`name` varchar(128) default NULL,

1497

`cardtype` varchar(32) NOT NULL default 'V4L',

1498

`is_default` int(1) default '0',

1499

`hostname` varchar(255) default NULL,

1500

PRIMARY KEY (`id`),

1501

UNIQUE KEY `name` (`name`,`hostname`),

1502

KEY `cardtype` (`cardtype`)

1503

) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

1504

SET character_set_client = @saved_cs_client;

1505

1506

--

1507

--

1508

1509

LOCK TABLES `profilegroups` WRITE;

1510

/*!40000 ALTER TABLE `profilegroups` DISABLE KEYS */;

1511

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);

1512

/*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */;

1513

UNLOCK TABLES;

1514

1515

--

1516

--

1517

1518

DROP TABLE IF EXISTS `program`;

1519

SET @saved_cs_client = @@character_set_client;

1520

SET character_set_client = utf8;

1521

CREATE TABLE `program` (

1522

`chanid` int(10) unsigned NOT NULL default '0',

1523

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1524

`endtime` datetime NOT NULL default '0000-00-00 00:00:00',

1525

`title` varchar(128) NOT NULL default '',

1526

`subtitle` varchar(128) NOT NULL default '',

1527

`description` text NOT NULL,

1528

`category` varchar(64) NOT NULL default '',

1529

`category_type` varchar(64) NOT NULL default '',

1530

`airdate` year(4) NOT NULL default '0000',

1531

`stars` float NOT NULL default '0',

1532

`previouslyshown` tinyint(4) NOT NULL default '0',

1533

`title_pronounce` varchar(128) NOT NULL default '',

1534

`stereo` tinyint(1) NOT NULL default '0',

1535

`subtitled` tinyint(1) NOT NULL default '0',

1536

`hdtv` tinyint(1) NOT NULL default '0',

1537

`closecaptioned` tinyint(1) NOT NULL default '0',

1538

`partnumber` int(11) NOT NULL default '0',

1539

`parttotal` int(11) NOT NULL default '0',

1540

`seriesid` varchar(40) NOT NULL default '',

1541

`originalairdate` date default NULL,

1542

`showtype` varchar(30) NOT NULL default '',

1543

`colorcode` varchar(20) NOT NULL default '',

1544

`syndicatedepisodenumber` varchar(20) NOT NULL default '',

1545

`programid` varchar(40) NOT NULL default '',

1546

`manualid` int(10) unsigned NOT NULL default '0',

1547

`generic` tinyint(1) default '0',

1548

`listingsource` int(11) NOT NULL default '0',

1549

`first` tinyint(1) NOT NULL default '0',

1550

`last` tinyint(1) NOT NULL default '0',

1551

`audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL,

1552

`subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL,

1553

`videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL,

1554

PRIMARY KEY (`chanid`,`starttime`,`manualid`),

1555

KEY `endtime` (`endtime`),

1556

KEY `title` (`title`),

1557

KEY `title_pronounce` (`title_pronounce`),

1558

KEY `seriesid` (`seriesid`),

1559

KEY `id_start_end` (`chanid`,`starttime`,`endtime`),

1560

KEY `program_manualid` (`manualid`),

1561

KEY `previouslyshown` (`previouslyshown`),

1562

KEY `programid` (`programid`,`starttime`),

1563

KEY `starttime` (`starttime`)

1564

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1565

SET character_set_client = @saved_cs_client;

1566

1567

--

1568

--

1569

1570

LOCK TABLES `program` WRITE;

1571

/*!40000 ALTER TABLE `program` DISABLE KEYS */;

1572

/*!40000 ALTER TABLE `program` ENABLE KEYS */;

1573

UNLOCK TABLES;

1574

1575

--

1576

--

1577

1578

DROP TABLE IF EXISTS `programgenres`;

1579

SET @saved_cs_client = @@character_set_client;

1580

SET character_set_client = utf8;

1581

CREATE TABLE `programgenres` (

1582

`chanid` int(10) unsigned NOT NULL default '0',

1583

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1584

`relevance` char(1) NOT NULL default '',

1585

`genre` char(30) default NULL,

1586

PRIMARY KEY (`chanid`,`starttime`,`relevance`),

1587

KEY `genre` (`genre`)

1588

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1589

SET character_set_client = @saved_cs_client;

1590

1591

--

1592

--

1593

1594

LOCK TABLES `programgenres` WRITE;

1595

/*!40000 ALTER TABLE `programgenres` DISABLE KEYS */;

1596

/*!40000 ALTER TABLE `programgenres` ENABLE KEYS */;

1597

UNLOCK TABLES;

1598

1599

--

1600

--

1601

1602

DROP TABLE IF EXISTS `programrating`;

1603

SET @saved_cs_client = @@character_set_client;

1604

SET character_set_client = utf8;

1605

CREATE TABLE `programrating` (

1606

`chanid` int(10) unsigned NOT NULL default '0',

1607

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1608

`system` char(8) NOT NULL default '',

1609

`rating` char(16) default NULL,

1610

UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),

1611

KEY `starttime` (`starttime`,`system`)

1612

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1613

SET character_set_client = @saved_cs_client;

1614

1615

--

1616

--

1617

1618

LOCK TABLES `programrating` WRITE;

1619

/*!40000 ALTER TABLE `programrating` DISABLE KEYS */;

1620

/*!40000 ALTER TABLE `programrating` ENABLE KEYS */;

1621

UNLOCK TABLES;

1622

1623

--

1624

--

1625

1626

DROP TABLE IF EXISTS `recgrouppassword`;

1627

SET @saved_cs_client = @@character_set_client;

1628

SET character_set_client = utf8;

1629

CREATE TABLE `recgrouppassword` (

1630

`recgroup` varchar(32) NOT NULL default '',

1631

`password` varchar(10) NOT NULL default '',

1632

PRIMARY KEY (`recgroup`),

1633

UNIQUE KEY `recgroup` (`recgroup`)

1634

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1635

SET character_set_client = @saved_cs_client;

1636

1637

--

1638

--

1639

1640

LOCK TABLES `recgrouppassword` WRITE;

1641

/*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */;

1642

/*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */;

1643

UNLOCK TABLES;

1644

1645

--

1646

--

1647

1648

DROP TABLE IF EXISTS `record`;

1649

SET @saved_cs_client = @@character_set_client;

1650

SET character_set_client = utf8;

1651

CREATE TABLE `record` (

1652

`recordid` int(10) unsigned NOT NULL auto_increment,

1653

`type` int(10) unsigned NOT NULL default '0',

1654

`chanid` int(10) unsigned default NULL,

1655

`starttime` time NOT NULL default '00:00:00',

1656

`startdate` date NOT NULL default '0000-00-00',

1657

`endtime` time NOT NULL default '00:00:00',

1658

`enddate` date NOT NULL default '0000-00-00',

1659

`title` varchar(128) NOT NULL default '',

1660

`subtitle` varchar(128) NOT NULL default '',

1661

`description` text NOT NULL,

1662

`category` varchar(64) NOT NULL default '',

1663

`profile` varchar(128) NOT NULL default 'Default',

1664

`recpriority` int(10) NOT NULL default '0',

1665

`autoexpire` int(11) NOT NULL default '0',

1666

`maxepisodes` int(11) NOT NULL default '0',

1667

`maxnewest` int(11) NOT NULL default '0',

1668

`startoffset` int(11) NOT NULL default '0',

1669

`endoffset` int(11) NOT NULL default '0',

1670

`recgroup` varchar(32) NOT NULL default 'Default',

1671

`dupmethod` int(11) NOT NULL default '6',

1672

`dupin` int(11) NOT NULL default '15',

1673

`station` varchar(20) NOT NULL default '',

1674

`seriesid` varchar(40) NOT NULL default '',

1675

`programid` varchar(40) NOT NULL default '',

1676

`search` int(10) unsigned NOT NULL default '0',

1677

`autotranscode` tinyint(1) NOT NULL default '0',

1678

`autocommflag` tinyint(1) NOT NULL default '0',

1679

`autouserjob1` tinyint(1) NOT NULL default '0',

1680

`autouserjob2` tinyint(1) NOT NULL default '0',

1681

`autouserjob3` tinyint(1) NOT NULL default '0',

1682

`autouserjob4` tinyint(1) NOT NULL default '0',

1683

`findday` tinyint(4) NOT NULL default '0',

1684

`findtime` time NOT NULL default '00:00:00',

1685

`findid` int(11) NOT NULL default '0',

1686

`inactive` tinyint(1) NOT NULL default '0',

1687

`parentid` int(11) NOT NULL default '0',

1688

`transcoder` int(11) NOT NULL default '0',

1689

`tsdefault` float NOT NULL default '1',

1690

`playgroup` varchar(32) NOT NULL default 'Default',

1691

`prefinput` int(10) NOT NULL default '0',

1692

`next_record` datetime NOT NULL,

1693

`last_record` datetime NOT NULL,

1694

`last_delete` datetime NOT NULL,

1695

`storagegroup` varchar(32) NOT NULL default 'Default',

1696

`avg_delay` int(11) NOT NULL default '100',

1697

PRIMARY KEY (`recordid`),

1698

KEY `chanid` (`chanid`,`starttime`),

1699

KEY `title` (`title`),

1700

KEY `seriesid` (`seriesid`),

1701

KEY `programid` (`programid`),

1702

KEY `maxepisodes` (`maxepisodes`),

1703

KEY `search` (`search`),

1704

KEY `type` (`type`)

1705

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1706

SET character_set_client = @saved_cs_client;

1707

1708

--

1709

--

1710

1711

LOCK TABLES `record` WRITE;

1712

/*!40000 ALTER TABLE `record` DISABLE KEYS */;

1713

/*!40000 ALTER TABLE `record` ENABLE KEYS */;

1714

UNLOCK TABLES;

1715

1716

--

1717

--

1718

1719

DROP TABLE IF EXISTS `recorded`;

1720

SET @saved_cs_client = @@character_set_client;

1721

SET character_set_client = utf8;

1722

CREATE TABLE `recorded` (

1723

`chanid` int(10) unsigned NOT NULL default '0',

1724

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1725

`endtime` datetime NOT NULL default '0000-00-00 00:00:00',

1726

`title` varchar(128) NOT NULL default '',

1727

`subtitle` varchar(128) NOT NULL default '',

1728

`description` text NOT NULL,

1729

`category` varchar(64) NOT NULL default '',

1730

`hostname` varchar(255) NOT NULL default '',

1731

`bookmark` tinyint(1) NOT NULL default '0',

1732

`editing` int(10) unsigned NOT NULL default '0',

1733

`cutlist` tinyint(1) NOT NULL default '0',

1734

`autoexpire` int(11) NOT NULL default '0',

1735

`commflagged` int(10) unsigned NOT NULL default '0',

1736

`recgroup` varchar(32) NOT NULL default 'Default',

1737

`recordid` int(11) default NULL,

1738

`seriesid` varchar(40) NOT NULL default '',

1739

`programid` varchar(40) NOT NULL default '',

1740

`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

1741

`filesize` bigint(20) NOT NULL default '0',

1742

`stars` float NOT NULL default '0',

1743

`previouslyshown` tinyint(1) default '0',

1744

`originalairdate` date default NULL,

1745

`preserve` tinyint(1) NOT NULL default '0',

1746

`findid` int(11) NOT NULL default '0',

1747

`deletepending` tinyint(1) NOT NULL default '0',

1748

`transcoder` int(11) NOT NULL default '0',

1749

`timestretch` float NOT NULL default '1',

1750

`recpriority` int(11) NOT NULL default '0',

1751

`basename` varchar(255) NOT NULL,

1752

`progstart` datetime NOT NULL default '0000-00-00 00:00:00',

1753

`progend` datetime NOT NULL default '0000-00-00 00:00:00',

1754

`playgroup` varchar(32) NOT NULL default 'Default',

1755

`profile` varchar(32) NOT NULL default '',

1756

`duplicate` tinyint(1) NOT NULL default '0',

1757

`transcoded` tinyint(1) NOT NULL default '0',

1758

`watched` tinyint(4) NOT NULL default '0',

1759

`storagegroup` varchar(32) NOT NULL default 'Default',

1760

PRIMARY KEY (`chanid`,`starttime`),

1761

KEY `endtime` (`endtime`),

1762

KEY `seriesid` (`seriesid`),

1763

KEY `programid` (`programid`),

1764

KEY `title` (`title`),

1765

KEY `recordid` (`recordid`),

1766

KEY `deletepending` (`deletepending`,`lastmodified`),

1767

KEY `recgroup` (`recgroup`,`endtime`)

1768

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1769

SET character_set_client = @saved_cs_client;

1770

1771

--

1772

--

1773

1774

LOCK TABLES `recorded` WRITE;

1775

/*!40000 ALTER TABLE `recorded` DISABLE KEYS */;

1776

/*!40000 ALTER TABLE `recorded` ENABLE KEYS */;

1777

UNLOCK TABLES;

1778

1779

--

1780

--

1781

1782

DROP TABLE IF EXISTS `recordedcredits`;

1783

SET @saved_cs_client = @@character_set_client;

1784

SET character_set_client = utf8;

1785

CREATE TABLE `recordedcredits` (

1786

`person` mediumint(8) unsigned NOT NULL default '0',

1787

`chanid` int(10) unsigned NOT NULL default '0',

1788

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1789

`role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',

1790

UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`),

1791

KEY `person` (`person`,`role`)

1792

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1793

SET character_set_client = @saved_cs_client;

1794

1795

--

1796

--

1797

1798

LOCK TABLES `recordedcredits` WRITE;

1799

/*!40000 ALTER TABLE `recordedcredits` DISABLE KEYS */;

1800

/*!40000 ALTER TABLE `recordedcredits` ENABLE KEYS */;

1801

UNLOCK TABLES;

1802

1803

--

1804

--

1805

1806

DROP TABLE IF EXISTS `recordedfile`;

1807

SET @saved_cs_client = @@character_set_client;

1808

SET character_set_client = utf8;

1809

CREATE TABLE `recordedfile` (

1810

`chanid` int(10) unsigned NOT NULL default '0',

1811

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1812

`basename` varchar(128) NOT NULL default '',

1813

`filesize` bigint(20) NOT NULL default '0',

1814

`width` smallint(5) unsigned NOT NULL default '0',

1815

`height` smallint(5) unsigned NOT NULL default '0',

1816

`fps` float(6,3) NOT NULL default '0.000',

1817

`aspect` float(8,6) NOT NULL default '0.000000',

1818

`audio_sample_rate` smallint(5) unsigned NOT NULL default '0',

1819

`audio_bits_per_sample` smallint(5) unsigned NOT NULL default '0',

1820

`audio_channels` tinyint(3) unsigned NOT NULL default '0',

1821

`audio_type` varchar(255) NOT NULL default '',

1822

`video_type` varchar(255) NOT NULL default '',

1823

`comment` varchar(255) NOT NULL default '',

1824

PRIMARY KEY (`chanid`,`starttime`),

1825

KEY `basename` (`basename`)

1826

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1827

SET character_set_client = @saved_cs_client;

1828

1829

--

1830

--

1831

1832

LOCK TABLES `recordedfile` WRITE;

1833

/*!40000 ALTER TABLE `recordedfile` DISABLE KEYS */;

1834

/*!40000 ALTER TABLE `recordedfile` ENABLE KEYS */;

1835

UNLOCK TABLES;

1836

1837

--

1838

--

1839

1840

DROP TABLE IF EXISTS `recordedmarkup`;

1841

SET @saved_cs_client = @@character_set_client;

1842

SET character_set_client = utf8;

1843

CREATE TABLE `recordedmarkup` (

1844

`chanid` int(10) unsigned NOT NULL default '0',

1845

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1846

`mark` mediumint(8) unsigned NOT NULL default '0',

1847

`offset` varchar(32) default NULL,

1848

`type` tinyint(4) NOT NULL default '0',

1849

PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)

1850

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1851

SET character_set_client = @saved_cs_client;

1852

1853

--

1854

--

1855

1856

LOCK TABLES `recordedmarkup` WRITE;

1857

/*!40000 ALTER TABLE `recordedmarkup` DISABLE KEYS */;

1858

/*!40000 ALTER TABLE `recordedmarkup` ENABLE KEYS */;

1859

UNLOCK TABLES;

1860

1861

--

1862

--

1863

1864

DROP TABLE IF EXISTS `recordedprogram`;

1865

SET @saved_cs_client = @@character_set_client;

1866

SET character_set_client = utf8;

1867

CREATE TABLE `recordedprogram` (

1868

`chanid` int(10) unsigned NOT NULL default '0',

1869

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1870

`endtime` datetime NOT NULL default '0000-00-00 00:00:00',

1871

`title` varchar(128) NOT NULL default '',

1872

`subtitle` varchar(128) NOT NULL default '',

1873

`description` text NOT NULL,

1874

`category` varchar(64) NOT NULL default '',

1875

`category_type` varchar(64) NOT NULL default '',

1876

`airdate` year(4) NOT NULL default '0000',

1877

`stars` float unsigned NOT NULL default '0',

1878

`previouslyshown` tinyint(4) NOT NULL default '0',

1879

`title_pronounce` varchar(128) NOT NULL default '',

1880

`stereo` tinyint(1) NOT NULL default '0',

1881

`subtitled` tinyint(1) NOT NULL default '0',

1882

`hdtv` tinyint(1) NOT NULL default '0',

1883

`closecaptioned` tinyint(1) NOT NULL default '0',

1884

`partnumber` int(11) NOT NULL default '0',

1885

`parttotal` int(11) NOT NULL default '0',

1886

`seriesid` varchar(40) NOT NULL default '',

1887

`originalairdate` date default NULL,

1888

`showtype` varchar(30) NOT NULL default '',

1889

`colorcode` varchar(20) NOT NULL default '',

1890

`syndicatedepisodenumber` varchar(20) NOT NULL default '',

1891

`programid` varchar(40) NOT NULL default '',

1892

`manualid` int(10) unsigned NOT NULL default '0',

1893

`generic` tinyint(1) default '0',

1894

`listingsource` int(11) NOT NULL default '0',

1895

`first` tinyint(1) NOT NULL default '0',

1896

`last` tinyint(1) NOT NULL default '0',

1897

`audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL,

1898

`subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL,

1899

`videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL,

1900

PRIMARY KEY (`chanid`,`starttime`,`manualid`),

1901

KEY `endtime` (`endtime`),

1902

KEY `title` (`title`),

1903

KEY `title_pronounce` (`title_pronounce`),

1904

KEY `seriesid` (`seriesid`),

1905

KEY `programid` (`programid`),

1906

KEY `id_start_end` (`chanid`,`starttime`,`endtime`)

1907

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1908

SET character_set_client = @saved_cs_client;

1909

1910

--

1911

--

1912

1913

LOCK TABLES `recordedprogram` WRITE;

1914

/*!40000 ALTER TABLE `recordedprogram` DISABLE KEYS */;

1915

/*!40000 ALTER TABLE `recordedprogram` ENABLE KEYS */;

1916

UNLOCK TABLES;

1917

1918

--

1919

--

1920

1921

DROP TABLE IF EXISTS `recordedrating`;

1922

SET @saved_cs_client = @@character_set_client;

1923

SET character_set_client = utf8;

1924

CREATE TABLE `recordedrating` (

1925

`chanid` int(10) unsigned NOT NULL default '0',

1926

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1927

`system` char(8) NOT NULL default '',

1928

`rating` char(16) default NULL,

1929

UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`),

1930

KEY `starttime` (`starttime`,`system`)

1931

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1932

SET character_set_client = @saved_cs_client;

1933

1934

--

1935

--

1936

1937

LOCK TABLES `recordedrating` WRITE;

1938

/*!40000 ALTER TABLE `recordedrating` DISABLE KEYS */;

1939

/*!40000 ALTER TABLE `recordedrating` ENABLE KEYS */;

1940

UNLOCK TABLES;

1941

1942

--

1943

--

1944

1945

DROP TABLE IF EXISTS `recordedseek`;

1946

SET @saved_cs_client = @@character_set_client;

1947

SET character_set_client = utf8;

1948

CREATE TABLE `recordedseek` (

1949

`chanid` int(10) unsigned NOT NULL default '0',

1950

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

1951

`mark` mediumint(8) unsigned NOT NULL default '0',

1952

`offset` bigint(20) unsigned NOT NULL,

1953

`type` tinyint(4) NOT NULL default '0',

1954

PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)

1955

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1956

SET character_set_client = @saved_cs_client;

1957

1958

--

1959

--

1960

1961

LOCK TABLES `recordedseek` WRITE;

1962

/*!40000 ALTER TABLE `recordedseek` DISABLE KEYS */;

1963

/*!40000 ALTER TABLE `recordedseek` ENABLE KEYS */;

1964

UNLOCK TABLES;

1965

1966

--

1967

--

1968

1969

DROP TABLE IF EXISTS `recordingprofiles`;

1970

SET @saved_cs_client = @@character_set_client;

1971

SET character_set_client = utf8;

1972

CREATE TABLE `recordingprofiles` (

1973

`id` int(10) unsigned NOT NULL auto_increment,

1974

`name` varchar(128) default NULL,

1975

`videocodec` varchar(128) default NULL,

1976

`audiocodec` varchar(128) default NULL,

1977

`profilegroup` int(10) unsigned NOT NULL default '0',

1978

PRIMARY KEY (`id`),

1979

KEY `profilegroup` (`profilegroup`)

1980

) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

1981

SET character_set_client = @saved_cs_client;

1982

1983

--

1984

--

1985

1986

LOCK TABLES `recordingprofiles` WRITE;

1987

/*!40000 ALTER TABLE `recordingprofiles` DISABLE KEYS */;

1988

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),(42,'Default',NULL,NULL,7),(43,'Live TV',NULL,NULL,7),(44,'High Quality',NULL,NULL,7),(45,'Low Quality',NULL,NULL,7),(46,'Default',NULL,NULL,9),(47,'Live TV',NULL,NULL,9),(48,'High Quality',NULL,NULL,9),(49,'Low Quality',NULL,NULL,9);

1989

/*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */;

1990

UNLOCK TABLES;

1991

1992

--

1993

--

1994

1995

DROP TABLE IF EXISTS `recordmatch`;

1996

SET @saved_cs_client = @@character_set_client;

1997

SET character_set_client = utf8;

1998

CREATE TABLE `recordmatch` (

1999

`recordid` int(10) unsigned default NULL,

2000

`chanid` int(10) unsigned default NULL,

2001

`starttime` datetime default NULL,

2002

`manualid` int(10) unsigned default NULL,

2003

`oldrecduplicate` tinyint(1) default NULL,

2004

`recduplicate` tinyint(1) default NULL,

2005

`findduplicate` tinyint(1) default NULL,

2006

`oldrecstatus` int(11) default NULL,

2007

KEY `recordid` (`recordid`)

2008

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2009

SET character_set_client = @saved_cs_client;

2010

2011

--

2012

--

2013

2014

LOCK TABLES `recordmatch` WRITE;

2015

/*!40000 ALTER TABLE `recordmatch` DISABLE KEYS */;

2016

/*!40000 ALTER TABLE `recordmatch` ENABLE KEYS */;

2017

UNLOCK TABLES;

2018

2019

--

2020

--

2021

2022

DROP TABLE IF EXISTS `romdb`;

2023

SET @saved_cs_client = @@character_set_client;

2024

SET character_set_client = utf8;

2025

CREATE TABLE `romdb` (

2026

`crc` varchar(64) NOT NULL default '',

2027

`name` varchar(128) NOT NULL default '',

2028

`description` varchar(128) NOT NULL default '',

2029

`category` varchar(128) NOT NULL default '',

2030

`year` varchar(10) NOT NULL default '',

2031

`manufacturer` varchar(128) NOT NULL default '',

2032

`country` varchar(128) NOT NULL default '',

2033

`publisher` varchar(128) NOT NULL default '',

2034

`platform` varchar(64) NOT NULL default '',

2035

`filesize` int(12) default NULL,

2036

`flags` varchar(64) NOT NULL default '',

2037

`version` varchar(64) NOT NULL default '',

2038

`binfile` varchar(64) NOT NULL default '',

2039

KEY `crc` (`crc`),

2040

KEY `year` (`year`),

2041

KEY `category` (`category`),

2042

KEY `name` (`name`),

2043

KEY `description` (`description`),

2044

KEY `platform` (`platform`)

2045

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2046

SET character_set_client = @saved_cs_client;

2047

2048

--

2049

--

2050

2051

LOCK TABLES `romdb` WRITE;

2052

/*!40000 ALTER TABLE `romdb` DISABLE KEYS */;

2053

/*!40000 ALTER TABLE `romdb` ENABLE KEYS */;

2054

UNLOCK TABLES;

2055

2056

--

2057

--

2058

2059

DROP TABLE IF EXISTS `schemalock`;

2060

SET @saved_cs_client = @@character_set_client;

2061

SET character_set_client = utf8;

2062

CREATE TABLE `schemalock` (

2063

`schemalock` int(1) default NULL

2064

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2065

SET character_set_client = @saved_cs_client;

2066

2067

--

2068

--

2069

2070

LOCK TABLES `schemalock` WRITE;

2071

/*!40000 ALTER TABLE `schemalock` DISABLE KEYS */;

2072

/*!40000 ALTER TABLE `schemalock` ENABLE KEYS */;

2073

UNLOCK TABLES;

2074

2075

--

2076

--

2077

2078

DROP TABLE IF EXISTS `settings`;

2079

SET @saved_cs_client = @@character_set_client;

2080

SET character_set_client = utf8;

2081

CREATE TABLE `settings` (

2082

`value` varchar(128) NOT NULL default '',

2083

`data` text,

2084

`hostname` varchar(255) default NULL,

2085

KEY `value` (`value`,`hostname`)

2086

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2087

SET character_set_client = @saved_cs_client;

2088

2089

--

2090

--

2091

2092

LOCK TABLES `settings` WRITE;

2093

/*!40000 ALTER TABLE `settings` DISABLE KEYS */;

2094

INSERT INTO `settings` VALUES ('mythfilldatabaseLastRunStart',NULL,NULL),('mythfilldatabaseLastRunEnd',NULL,NULL),('mythfilldatabaseLastRunStatus',NULL,NULL),('DataDirectMessage',NULL,NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1214',NULL),('DefaultTranscoder','0',NULL),('MythFillSuggestedRunTime','1970-01-01T00:00:00',NULL),('MythFillGrabberSuggestsTime','1',NULL),('BackendServerIP','127.0.0.1','OLDHOSTNAME'),('BackendServerPort','6543','OLDHOSTNAME'),('BackendStatusPort','6544','OLDHOSTNAME'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('RecordFilePrefix','/var/lib/mythtv/recordings','OLDHOSTNAME'),('TruncateDeletesSlowly','1','OLDHOSTNAME'),('TVFormat','NTSC',NULL),('VbiFormat','None',NULL),('FreqTable','us-bcast',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','OLDHOSTNAME'),('JobQueueCheckFrequency','60','OLDHOSTNAME'),('JobQueueWindowStart','00:00','OLDHOSTNAME'),('JobQueueWindowEnd','23:59','OLDHOSTNAME'),('JobQueueCPU','0','OLDHOSTNAME'),('JobAllowCommFlag','1','OLDHOSTNAME'),('JobAllowTranscode','1','OLDHOSTNAME'),('JobAllowUserJob1','0','OLDHOSTNAME'),('JobAllowUserJob2','0','OLDHOSTNAME'),('JobAllowUserJob3','0','OLDHOSTNAME'),('JobAllowUserJob4','0','OLDHOSTNAME'),('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),('upnp:UDN:urn:schemas-upnp-org:device:MediaServer:1','256a89b4-1266-49ca-9ac7-f0b4b4641e7f','OLDHOSTNAME'),('Deinterlace','0','OLDHOSTNAME'),('DeinterlaceFilter','linearblend','OLDHOSTNAME'),('CustomFilters','','OLDHOSTNAME'),('PreferredMPEG2Decoder','ffmpeg','OLDHOSTNAME'),('UseOpenGLVSync','0','OLDHOSTNAME'),('RealtimePriority','1','OLDHOSTNAME'),('UseVideoTimebase','0','OLDHOSTNAME'),('DecodeExtraAudio','1','OLDHOSTNAME'),('AspectOverride','0','OLDHOSTNAME'),('PIPLocation','0','OLDHOSTNAME'),('PlaybackExitPrompt','0','OLDHOSTNAME'),('EndOfRecordingExitPrompt','0','OLDHOSTNAME'),('ClearSavedPosition','1','OLDHOSTNAME'),('AltClearSavedPosition','1','OLDHOSTNAME'),('UseOutputPictureControls','0','OLDHOSTNAME'),('AudioNag','1','OLDHOSTNAME'),('UDPNotifyPort','6948','OLDHOSTNAME'),('PlayBoxOrdering','1','OLDHOSTNAME'),('PlayBoxEpisodeSort','Date','OLDHOSTNAME'),('GeneratePreviewPixmaps','0','OLDHOSTNAME'),('PreviewPixmapOffset','64',NULL),('PreviewFromBookmark','1','OLDHOSTNAME'),('PlaybackPreview','1','OLDHOSTNAME'),('PlaybackPreviewLowCPU','0','OLDHOSTNAME'),('PlaybackBoxStartInTitle','1','OLDHOSTNAME'),('ShowGroupInfo','0','OLDHOSTNAME'),('AllRecGroupPassword','',NULL),('DisplayRecGroup','All Programs','OLDHOSTNAME'),('QueryInitialFilter','0','OLDHOSTNAME'),('RememberRecGroup','1','OLDHOSTNAME'),('DispRecGroupAsAllProg','0','OLDHOSTNAME'),('LiveTVInAllPrograms','0','OLDHOSTNAME'),('DisplayGroupDefaultView','0','OLDHOSTNAME'),('DisplayGroupTitleSort','0','OLDHOSTNAME'),('PVR350OutputEnable','0','OLDHOSTNAME'),('PVR350VideoDev','/dev/video16','OLDHOSTNAME'),('PVR350EPGAlphaValue','164','OLDHOSTNAME'),('PVR350InternalAudioOnly','0','OLDHOSTNAME'),('SmartForward','0','OLDHOSTNAME'),('StickyKeys','0','OLDHOSTNAME'),('FFRewReposTime','100','OLDHOSTNAME'),('FFRewReverse','1','OLDHOSTNAME'),('ExactSeeking','0','OLDHOSTNAME'),('AutoCommercialSkip','0','OLDHOSTNAME'),('CommRewindAmount','0','OLDHOSTNAME'),('CommNotifyAmount','0','OLDHOSTNAME'),('MaximumCommercialSkip','3600',NULL),('CommSkipAllBlanks','1',NULL),('VertScanPercentage','0','OLDHOSTNAME'),('HorizScanPercentage','0','OLDHOSTNAME'),('XScanDisplacement','0','OLDHOSTNAME'),('YScanDisplacement','0','OLDHOSTNAME'),('OSDTheme','blueosd','OLDHOSTNAME'),('OSDGeneralTimeout','2','OLDHOSTNAME'),('OSDProgramInfoTimeout','3','OLDHOSTNAME'),('OSDNotifyTimeout','5','OLDHOSTNAME'),('OSDFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCCFont','FreeMono.ttf','OLDHOSTNAME'),('OSDThemeFontSizeType','default','OLDHOSTNAME'),('CCBackground','0','OLDHOSTNAME'),('DefaultCCMode','0','OLDHOSTNAME'),('PersistentBrowseMode','1','OLDHOSTNAME'),('EnableMHEG','0','OLDHOSTNAME'),('OSDCC708TextZoom','100','OLDHOSTNAME'),('OSDCC708DefaultFontType','MonoSerif','OLDHOSTNAME'),('OSDCC708MonoSerifFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708PropSerifFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708MonoSansSerifFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708PropSansSerifFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CasualFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CursiveFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CapitalsFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708MonoSerifItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708PropSerifItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708MonoSansSerifItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708PropSansSerifItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CasualItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CursiveItalicFont','FreeMono.ttf','OLDHOSTNAME'),('OSDCC708CapitalsItalicFont','FreeMono.ttf','OLDHOSTNAME'),('ChannelOrdering','channum','OLDHOSTNAME'),('ChannelFormat','<num> <sign>','OLDHOSTNAME'),('LongChannelFormat','<num> <name>','OLDHOSTNAME'),('SmartChannelChange','0','OLDHOSTNAME'),('LastFreeCard','0',NULL),('AutoExpireMethod','2',NULL),('AutoExpireDayPriority','3',NULL),('AutoExpireDefault','1',NULL),('AutoExpireLiveTVMaxAge','1',NULL),('AutoExpireExtraSpace','1',NULL),('AutoCommercialFlag','1',NULL),('CommercialSkipMethod','255',NULL),('AggressiveCommDetect','1',NULL),('AutoTranscode','0',NULL),('AutoRunUserJob1','0',NULL),('AutoRunUserJob2','0',NULL),('AutoRunUserJob3','0',NULL),('AutoRunUserJob4','0',NULL),('RecordPreRoll','0',NULL),('RecordOverTime','0',NULL),('OverTimeCategory','category name',NULL),('CategoryOverTime','30',NULL),('ATSCCheckSignalThreshold','65',NULL),('ATSCCheckSignalWait','5000',NULL),('HDRingbufferSize','9400',NULL),('EPGFillType','10','OLDHOSTNAME'),('EPGShowCategoryColors','1','OLDHOSTNAME'),('EPGShowCategoryText','1','OLDHOSTNAME'),('EPGScrollType','1','OLDHOSTNAME'),('EPGShowChannelIcon','1','OLDHOSTNAME'),('EPGShowFavorites','0','OLDHOSTNAME'),('WatchTVGuide','0','OLDHOSTNAME'),('chanPerPage','5','OLDHOSTNAME'),('timePerPage','4','OLDHOSTNAME'),('UnknownTitle','Unknown','OLDHOSTNAME'),('UnknownCategory','Unknown','OLDHOSTNAME'),('DefaultTVChannel','3','OLDHOSTNAME'),('SelectChangesChannel','0','OLDHOSTNAME'),('SelChangeRecThreshold','16','OLDHOSTNAME'),('EPGEnableJumpToChannel','0',NULL),('Theme','G.A.N.T','OLDHOSTNAME'),('ThemePainter','qt','OLDHOSTNAME'),('Style','','OLDHOSTNAME'),('ThemeFontSizeType','default','OLDHOSTNAME'),('RandomTheme','0','OLDHOSTNAME'),('MenuTheme','default','OLDHOSTNAME'),('XineramaScreen','0','OLDHOSTNAME'),('XineramaMonitorAspectRatio','1.3333','OLDHOSTNAME'),('GuiWidth','0','OLDHOSTNAME'),('GuiHeight','0','OLDHOSTNAME'),('GuiOffsetX','0','OLDHOSTNAME'),('GuiOffsetY','0','OLDHOSTNAME'),('GuiSizeForTV','1','OLDHOSTNAME'),('HideMouseCursor','1','OLDHOSTNAME'),('RunFrontendInWindow','0','OLDHOSTNAME'),('UseVideoModes','0','OLDHOSTNAME'),('GuiVidModeResolution','640x480','OLDHOSTNAME'),('TVVidModeResolution','640x480','OLDHOSTNAME'),('TVVidModeForceAspect','0.0','OLDHOSTNAME'),('VidModeWidth0','0','OLDHOSTNAME'),('VidModeHeight0','0','OLDHOSTNAME'),('TVVidModeResolution0','640x480','OLDHOSTNAME'),('TVVidModeForceAspect0','0.0','OLDHOSTNAME'),('VidModeWidth1','0','OLDHOSTNAME'),('VidModeHeight1','0','OLDHOSTNAME'),('TVVidModeResolution1','640x480','OLDHOSTNAME'),('TVVidModeForceAspect1','0.0','OLDHOSTNAME'),('VidModeWidth2','0','OLDHOSTNAME'),('VidModeHeight2','0','OLDHOSTNAME'),('TVVidModeResolution2','640x480','OLDHOSTNAME'),('TVVidModeForceAspect2','0.0','OLDHOSTNAME'),('ISO639Language0','eng','OLDHOSTNAME'),('ISO639Language1','eng','OLDHOSTNAME'),('DateFormat','ddd MMM d','OLDHOSTNAME'),('ShortDateFormat','M/d','OLDHOSTNAME'),('TimeFormat','h:mm AP','OLDHOSTNAME'),('QtFontSmall','12','OLDHOSTNAME'),('QtFontMedium','16','OLDHOSTNAME'),('QtFontBig','25','OLDHOSTNAME'),('PlayBoxTransparency','1','OLDHOSTNAME'),('PlayBoxShading','0','OLDHOSTNAME'),('UseVirtualKeyboard','1','OLDHOSTNAME'),('LCDEnable','0','OLDHOSTNAME'),('LCDShowTime','1','OLDHOSTNAME'),('LCDShowMenu','1','OLDHOSTNAME'),('LCDShowMusic','1','OLDHOSTNAME'),('LCDShowMusicItems','ArtistTitle','OLDHOSTNAME'),('LCDShowChannel','1','OLDHOSTNAME'),('LCDShowRecStatus','0','OLDHOSTNAME'),('LCDShowVolume','1','OLDHOSTNAME'),('LCDShowGeneric','1','OLDHOSTNAME'),('LCDBacklightOn','1','OLDHOSTNAME'),('LCDHeartBeatOn','0','OLDHOSTNAME'),('LCDBigClock','0','OLDHOSTNAME'),('LCDKeyString','ABCDEF','OLDHOSTNAME'),('LCDPopupTime','5','OLDHOSTNAME'),('AudioOutputDevice','ALSA:default','OLDHOSTNAME'),('PassThruOutputDevice','Default','OLDHOSTNAME'),('AC3PassThru','0','OLDHOSTNAME'),('DTSPassThru','0','OLDHOSTNAME'),('AggressiveSoundcardBuffer','0','OLDHOSTNAME'),('MythControlsVolume','1','OLDHOSTNAME'),('MixerDevice','default','OLDHOSTNAME'),('MixerControl','PCM','OLDHOSTNAME'),('MasterMixerVolume','70','OLDHOSTNAME'),('PCMMixerVolume','70','OLDHOSTNAME'),('IndividualMuteControl','0','OLDHOSTNAME'),('AllowQuitShutdown','4','OLDHOSTNAME'),('NoPromptOnExit','1','OLDHOSTNAME'),('HaltCommand','halt','OLDHOSTNAME'),('LircKeyPressedApp','','OLDHOSTNAME'),('UseArrowAccels','1','OLDHOSTNAME'),('NetworkControlEnabled','0','OLDHOSTNAME'),('NetworkControlPort','6546','OLDHOSTNAME'),('SetupPinCodeRequired','0','OLDHOSTNAME'),('MonitorDrives','0','OLDHOSTNAME'),('EnableXbox','0','OLDHOSTNAME'),('LogEnabled','0',NULL),('LogPrintLevel','8','OLDHOSTNAME'),('LogCleanEnabled','0','OLDHOSTNAME'),('LogCleanPeriod','14','OLDHOSTNAME'),('LogCleanDays','14','OLDHOSTNAME'),('LogCleanMax','30','OLDHOSTNAME'),('LogMaxCount','100','OLDHOSTNAME'),('MythFillEnabled','0',NULL),('MythFillDatabasePath','/usr/bin/mythfilldatabase',NULL),('MythFillDatabaseArgs','',NULL),('MythFillDatabaseLog','',NULL),('MythFillPeriod','1',NULL),('MythFillMinHour','2',NULL),('MythFillMaxHour','5',NULL),('SchedMoveHigher','1',NULL),('DefaultStartOffset','0',NULL),('DefaultEndOffset','0',NULL),('ComplexPriority','0',NULL),('PrefInputPriority','2',NULL),('OnceRecPriority','0',NULL),('HDTVRecPriority','0',NULL),('CCRecPriority','0',NULL),('SingleRecordRecPriority','1',NULL),('OverrideRecordRecPriority','0',NULL),('FindOneRecordRecPriority','-1',NULL),('WeekslotRecordRecPriority','0',NULL),('TimeslotRecordRecPriority','0',NULL),('ChannelRecordRecPriority','0',NULL),('AllRecordRecPriority','0',NULL),('ArchiveDBSchemaVer','1000',NULL),('MythArchiveTempDir','','OLDHOSTNAME'),('MythArchiveShareDir','/usr/share/mythtv/mytharchive/','OLDHOSTNAME'),('MythArchiveVideoFormat','PAL','OLDHOSTNAME'),('MythArchiveFileFilter','*.mpg *.mov *.avi *.mpeg *.nuv','OLDHOSTNAME'),('MythArchiveDVDLocation','/dev/dvd','OLDHOSTNAME'),('MythArchiveEncodeToAc3','0','OLDHOSTNAME'),('MythArchiveCopyRemoteFiles','0','OLDHOSTNAME'),('MythArchiveAlwaysUseMythTranscode','1','OLDHOSTNAME'),('MythArchiveUseFIFO','1','OLDHOSTNAME'),('MythArchiveMainMenuAR','16:9','OLDHOSTNAME'),('MythArchiveChapterMenuAR','Video','OLDHOSTNAME'),('MythArchiveDateFormat','%a %b %d','OLDHOSTNAME'),('MythArchiveTimeFormat','%I:%M %p','OLDHOSTNAME'),('MythArchiveFfmpegCmd','ffmpeg','OLDHOSTNAME'),('MythArchiveMplexCmd','mplex','OLDHOSTNAME'),('MythArchiveDvdauthorCmd','dvdauthor','OLDHOSTNAME'),('MythArchiveSpumuxCmd','spumux','OLDHOSTNAME'),('MythArchiveMpeg2encCmd','mpeg2enc','OLDHOSTNAME'),('MythArchiveMkisofsCmd','mkisofs','OLDHOSTNAME'),('MythArchiveGrowisofsCmd','growisofs','OLDHOSTNAME'),('MythArchiveTcrequantCmd','tcrequant','OLDHOSTNAME'),('MythArchivePng2yuvCmd','png2yuv','OLDHOSTNAME'),('DVDDBSchemaVer','1002',NULL),('DVDDeviceLocation','/dev/dvd','OLDHOSTNAME'),('VCDDeviceLocation','/dev/cdrom','OLDHOSTNAME'),('DVDOnInsertDVD','1','OLDHOSTNAME'),('mythdvd.DVDPlayerCommand','Internal','OLDHOSTNAME'),('VCDPlayerCommand','mplayer vcd:// -cdrom-device %d -fs -zoom -vo xv','OLDHOSTNAME'),('DVDRipLocation','/var/lib/mythdvd/temp','OLDHOSTNAME'),('TitlePlayCommand','mplayer dvd://%t -dvd-device %d -fs -zoom -vo xv -aid %a -channels %c','OLDHOSTNAME'),('SubTitleCommand','-sid %s','OLDHOSTNAME'),('TranscodeCommand','transcode','OLDHOSTNAME'),('MTDPort','2442','OLDHOSTNAME'),('MTDNiceLevel','20','OLDHOSTNAME'),('MTDConcurrentTranscodes','1','OLDHOSTNAME'),('MTDRipSize','0','OLDHOSTNAME'),('MTDLogFlag','0','OLDHOSTNAME'),('MTDac3Flag','0','OLDHOSTNAME'),('MTDxvidFlag','1','OLDHOSTNAME'),('mythvideo.TrustTranscodeFRDetect','1','OLDHOSTNAME'),('GalleryDBSchemaVer','1000',NULL),('GalleryDir','/var/lib/mythtv/pictures','OLDHOSTNAME'),('GalleryThumbnailLocation','1','OLDHOSTNAME'),('GallerySortOrder','20','OLDHOSTNAME'),('GalleryImportDirs','/media/cdrom:/media/usbdisk','OLDHOSTNAME'),('GalleryMoviePlayerCmd','mplayer -fs %s','OLDHOSTNAME'),('SlideshowOpenGLTransition','none','OLDHOSTNAME'),('SlideshowOpenGLTransitionLength','2000','OLDHOSTNAME'),('GalleryOverlayCaption','0','OLDHOSTNAME'),('SlideshowTransition','none','OLDHOSTNAME'),('SlideshowBackground','','OLDHOSTNAME'),('SlideshowDelay','5','OLDHOSTNAME'),('GameDBSchemaVer','1012',NULL),('MusicDBSchemaVer','1006',NULL),('MusicLocation','/var/lib/mythtv/music/','OLDHOSTNAME'),('MusicAudioDevice','default','OLDHOSTNAME'),('CDDevice','/dev/cdrom','OLDHOSTNAME'),('TreeLevels','splitartist artist album title','OLDHOSTNAME'),('NonID3FileNameFormat','GENRE/ARTIST/ALBUM/TRACK_TITLE','OLDHOSTNAME'),('Ignore_ID3','0','OLDHOSTNAME'),('AutoLookupCD','1','OLDHOSTNAME'),('AutoPlayCD','0','OLDHOSTNAME'),('KeyboardAccelerators','1','OLDHOSTNAME'),('CDWriterEnabled','1','OLDHOSTNAME'),('CDDiskSize','1','OLDHOSTNAME'),('CDCreateDir','1','OLDHOSTNAME'),('CDWriteSpeed','0','OLDHOSTNAME'),('CDBlankType','fast','OLDHOSTNAME'),('PlayMode','Normal','OLDHOSTNAME'),('IntelliRatingWeight','35','OLDHOSTNAME'),('IntelliPlayCountWeight','25','OLDHOSTNAME'),('IntelliLastPlayWeight','25','OLDHOSTNAME'),('IntelliRandomWeight','15','OLDHOSTNAME'),('MusicShowRatings','0','OLDHOSTNAME'),('ShowWholeTree','0','OLDHOSTNAME'),('ListAsShuffled','0','OLDHOSTNAME'),('VisualMode','Random','OLDHOSTNAME'),('VisualCycleOnSongChange','0','OLDHOSTNAME'),('VisualModeDelay','0','OLDHOSTNAME'),('VisualScaleWidth','1','OLDHOSTNAME'),('VisualScaleHeight','1','OLDHOSTNAME'),('ParanoiaLevel','Full','OLDHOSTNAME'),('FilenameTemplate','ARTIST/ALBUM/TRACK-TITLE','OLDHOSTNAME'),('TagSeparator',' - ','OLDHOSTNAME'),('NoWhitespace','0','OLDHOSTNAME'),('PostCDRipScript','','OLDHOSTNAME'),('EjectCDAfterRipping','1','OLDHOSTNAME'),('OnlyImportNewMusic','0','OLDHOSTNAME'),('EncoderType','ogg','OLDHOSTNAME'),('DefaultRipQuality','0','OLDHOSTNAME'),('Mp3UseVBR','0','OLDHOSTNAME'),('PhoneDBSchemaVer','1001',NULL),('SipRegisterWithProxy','1','OLDHOSTNAME'),('SipProxyName','fwd.pulver.com','OLDHOSTNAME'),('SipProxyAuthName','','OLDHOSTNAME'),('SipProxyAuthPassword','','OLDHOSTNAME'),('MySipName','Me','OLDHOSTNAME'),('SipAutoanswer','0','OLDHOSTNAME'),('SipBindInterface','eth0','OLDHOSTNAME'),('SipLocalPort','5060','OLDHOSTNAME'),('NatTraversalMethod','None','OLDHOSTNAME'),('NatIpAddress','http://checkip.dyndns.org','OLDHOSTNAME'),('AudioLocalPort','21232','OLDHOSTNAME'),('VideoLocalPort','21234','OLDHOSTNAME'),('MicrophoneDevice','None','OLDHOSTNAME'),('CodecPriorityList','GSM;G.711u;G.711a','OLDHOSTNAME'),('PlayoutAudioCall','40','OLDHOSTNAME'),('PlayoutVideoCall','110','OLDHOSTNAME'),('TxResolution','176x144','OLDHOSTNAME'),('TransmitFPS','5','OLDHOSTNAME'),('TransmitBandwidth','256','OLDHOSTNAME'),('CaptureResolution','352x288','OLDHOSTNAME'),('TimeToAnswer','10','OLDHOSTNAME'),('DefaultVxmlUrl','http://127.0.0.1/vxml/index.vxml','OLDHOSTNAME'),('DefaultVoicemailPrompt','I am not at home, please leave a message after the tone','OLDHOSTNAME'),('VideoDBSchemaVer','1010',NULL),('VideoStartupDir','/var/lib/mythtv/videos','OLDHOSTNAME'),('VideoArtworkDir','/var/lib/mythtv/posters','OLDHOSTNAME'),('VideoDefaultParentalLevel','4','OLDHOSTNAME'),('VideoAggressivePC','0','OLDHOSTNAME'),('Default MythVideo View','1','OLDHOSTNAME'),('VideoListUnknownFiletypes','1','OLDHOSTNAME'),('VideoBrowserNoDB','0','OLDHOSTNAME'),('VideoGalleryNoDB','0','OLDHOSTNAME'),('VideoTreeNoDB','0','OLDHOSTNAME'),('VideoTreeLoadMetaData','1','OLDHOSTNAME'),('VideoNewBrowsable','1','OLDHOSTNAME'),('mythvideo.sort_ignores_case','1','OLDHOSTNAME'),('mythvideo.db_folder_view','1','OLDHOSTNAME'),('mythvideo.ImageCacheSize','50','OLDHOSTNAME'),('MovieListCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -M tv=no;video=no','OLDHOSTNAME'),('MoviePosterCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -P','OLDHOSTNAME'),('MovieDataCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -D','OLDHOSTNAME'),('VideoGalleryColsPerPage','4','OLDHOSTNAME'),('VideoGalleryRowsPerPage','3','OLDHOSTNAME'),('VideoGallerySubtitle','1','OLDHOSTNAME'),('VideoGalleryAspectRatio','1','OLDHOSTNAME'),('VideoDefaultPlayer','mplayer -fs -zoom -quiet -vo xv %s','OLDHOSTNAME'),('MythFillFixProgramIDsHasRunOnce','1','OLDHOSTNAME'),('DisplayGroupDefaultViewMask','1','OLDHOSTNAME'),('SecurityPin','','OLDHOSTNAME'),('MiscStatusScript','','OLDHOSTNAME'),('DisableFirewireReset','0','OLDHOSTNAME'),('Theme','Mythbuntu-9.10','localhost'),('Theme','G.A.N.T','OLDHOSTNAME'),('MythFillFixProgramIDsHasRunOnce','1','OLDHOSTNAME'),('BackupDBLastRunStart','2008-04-12 22:16:28',NULL),('BackupDBLastRunEnd','2008-04-12 22:16:29',NULL),('Language','EN','OLDHOSTNAME'),('BackendServerIP','127.0.0.1','OLDHOSTNAME'),('BackendServerPort','6543','OLDHOSTNAME'),('BackendStatusPort','6544','OLDHOSTNAME'),('SecurityPin','','OLDHOSTNAME'),('TruncateDeletesSlowly','0','OLDHOSTNAME'),('MiscStatusScript','','OLDHOSTNAME'),('DisableFirewireReset','0','OLDHOSTNAME'),('JobQueueMaxSimultaneousJobs','1','OLDHOSTNAME'),('JobQueueCheckFrequency','60','OLDHOSTNAME'),('JobQueueWindowStart','00:00','OLDHOSTNAME'),('JobQueueWindowEnd','23:59','OLDHOSTNAME'),('JobQueueCPU','0','OLDHOSTNAME'),('JobAllowCommFlag','1','OLDHOSTNAME'),('JobAllowTranscode','1','OLDHOSTNAME'),('JobAllowUserJob1','0','OLDHOSTNAME'),('JobAllowUserJob2','0','OLDHOSTNAME'),('JobAllowUserJob3','0','OLDHOSTNAME'),('JobAllowUserJob4','0','OLDHOSTNAME');

2095

/*!40000 ALTER TABLE `settings` ENABLE KEYS */;

2096

UNLOCK TABLES;

2097

2098

--

2099

--

2100

2101

DROP TABLE IF EXISTS `storagegroup`;

2102

SET @saved_cs_client = @@character_set_client;

2103

SET character_set_client = utf8;

2104

CREATE TABLE `storagegroup` (

2105

`id` int(11) NOT NULL auto_increment,

2106

`groupname` varchar(32) NOT NULL,

2107

`hostname` varchar(64) NOT NULL default '',

2108

`dirname` varchar(255) NOT NULL default '',

2109

PRIMARY KEY (`id`),

2110

UNIQUE KEY `grouphostdir` (`groupname`,`hostname`,`dirname`),

2111

KEY `hostname` (`hostname`)

2112

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

2113

SET character_set_client = @saved_cs_client;

2114

2115

--

2116

--

2117

2118

LOCK TABLES `storagegroup` WRITE;

2119

/*!40000 ALTER TABLE `storagegroup` DISABLE KEYS */;

2120

INSERT INTO `storagegroup` VALUES (1,'Default','OLDHOSTNAME','/var/lib/mythtv/recordings');

2121

/*!40000 ALTER TABLE `storagegroup` ENABLE KEYS */;

2122

UNLOCK TABLES;

2123

2124

--

2125

--

2126

2127

DROP TABLE IF EXISTS `tvchain`;

2128

SET @saved_cs_client = @@character_set_client;

2129

SET character_set_client = utf8;

2130

CREATE TABLE `tvchain` (

2131

`chanid` int(10) unsigned NOT NULL default '0',

2132

`starttime` datetime NOT NULL default '0000-00-00 00:00:00',

2133

`chainid` varchar(128) NOT NULL default '',

2134

`chainpos` int(10) NOT NULL default '0',

2135

`discontinuity` tinyint(1) NOT NULL default '0',

2136

`watching` int(10) NOT NULL default '0',

2137

`hostprefix` varchar(128) NOT NULL default '',

2138

`cardtype` varchar(32) NOT NULL default 'V4L',

2139

`input` varchar(32) NOT NULL default '',

2140

`channame` varchar(32) NOT NULL default '',

2141

`endtime` datetime NOT NULL default '0000-00-00 00:00:00',

2142

PRIMARY KEY (`chanid`,`starttime`)

2143

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2144

SET character_set_client = @saved_cs_client;

2145

2146

--

2147

--

2148

2149

LOCK TABLES `tvchain` WRITE;

2150

/*!40000 ALTER TABLE `tvchain` DISABLE KEYS */;

2151

/*!40000 ALTER TABLE `tvchain` ENABLE KEYS */;

2152

UNLOCK TABLES;

2153

2154

--

2155

--

2156

2157

DROP TABLE IF EXISTS `upnpmedia`;

2158

SET @saved_cs_client = @@character_set_client;

2159

SET character_set_client = utf8;

2160

CREATE TABLE `upnpmedia` (

2161

`intid` int(10) unsigned NOT NULL default '0',

2162

`class` varchar(64) NOT NULL default '',

2163

`itemtype` varchar(128) NOT NULL default '',

2164

`parentid` int(10) unsigned NOT NULL default '0',

2165

`itemproperties` varchar(255) NOT NULL default '',

2166

`filepath` varchar(512) NOT NULL default '',

2167

`title` varchar(255) NOT NULL default '',

2168

`filename` varchar(512) NOT NULL default '',

2169

`coverart` varchar(512) NOT NULL default '',

2170

PRIMARY KEY (`intid`),

2171

KEY `class` (`class`),

2172

KEY `filepath` (`filepath`),

2173

KEY `parentid` (`parentid`)

2174

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2175

SET character_set_client = @saved_cs_client;

2176

2177

--

2178

--

2179

2180

LOCK TABLES `upnpmedia` WRITE;

2181

/*!40000 ALTER TABLE `upnpmedia` DISABLE KEYS */;

2182

/*!40000 ALTER TABLE `upnpmedia` ENABLE KEYS */;

2183

UNLOCK TABLES;

2184

2185

--

2186

--

2187

2188

DROP TABLE IF EXISTS `videocategory`;

2189

SET @saved_cs_client = @@character_set_client;

2190

SET character_set_client = utf8;

2191

CREATE TABLE `videocategory` (

2192

`intid` int(10) unsigned NOT NULL auto_increment,

2193

`category` varchar(128) NOT NULL,

2194

PRIMARY KEY (`intid`)

2195

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2196

SET character_set_client = @saved_cs_client;

2197

2198

--

2199

--

2200

2201

LOCK TABLES `videocategory` WRITE;

2202

/*!40000 ALTER TABLE `videocategory` DISABLE KEYS */;

2203

/*!40000 ALTER TABLE `videocategory` ENABLE KEYS */;

2204

UNLOCK TABLES;

2205

2206

--

2207

--

2208

2209

DROP TABLE IF EXISTS `videocountry`;

2210

SET @saved_cs_client = @@character_set_client;

2211

SET character_set_client = utf8;

2212

CREATE TABLE `videocountry` (

2213

`intid` int(10) unsigned NOT NULL auto_increment,

2214

`country` varchar(128) NOT NULL,

2215

PRIMARY KEY (`intid`)

2216

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2217

SET character_set_client = @saved_cs_client;

2218

2219

--

2220

--

2221

2222

LOCK TABLES `videocountry` WRITE;

2223

/*!40000 ALTER TABLE `videocountry` DISABLE KEYS */;

2224

/*!40000 ALTER TABLE `videocountry` ENABLE KEYS */;

2225

UNLOCK TABLES;

2226

2227

--

2228

--

2229

2230

DROP TABLE IF EXISTS `videogenre`;

2231

SET @saved_cs_client = @@character_set_client;

2232

SET character_set_client = utf8;

2233

CREATE TABLE `videogenre` (

2234

`intid` int(10) unsigned NOT NULL auto_increment,

2235

`genre` varchar(128) NOT NULL,

2236

PRIMARY KEY (`intid`)

2237

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2238

SET character_set_client = @saved_cs_client;

2239

2240

--

2241

--

2242

2243

LOCK TABLES `videogenre` WRITE;

2244

/*!40000 ALTER TABLE `videogenre` DISABLE KEYS */;

2245

/*!40000 ALTER TABLE `videogenre` ENABLE KEYS */;

2246

UNLOCK TABLES;

2247

2248

--

2249

--

2250

2251

DROP TABLE IF EXISTS `videometadata`;

2252

SET @saved_cs_client = @@character_set_client;

2253

SET character_set_client = utf8;

2254

CREATE TABLE `videometadata` (

2255

`intid` int(10) unsigned NOT NULL auto_increment,

2256

`title` varchar(128) NOT NULL,

2257

`director` varchar(128) NOT NULL,

2258

`plot` text,

2259

`rating` varchar(128) NOT NULL,

2260

`inetref` varchar(32) NOT NULL,

2261

`year` int(10) unsigned NOT NULL,

2262

`userrating` float NOT NULL,

2263

`length` int(10) unsigned NOT NULL,

2264

`showlevel` int(10) unsigned NOT NULL,

2265

`filename` text NOT NULL,

2266

`coverfile` text NOT NULL,

2267

`childid` int(11) NOT NULL default '-1',

2268

`browse` tinyint(1) NOT NULL default '1',

2269

`playcommand` varchar(255) default NULL,

2270

`category` int(10) unsigned NOT NULL default '0',

2271

PRIMARY KEY (`intid`),

2272

KEY `director` (`director`),

2273

KEY `title` (`title`),

2274

KEY `title_2` (`title`)

2275

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2276

SET character_set_client = @saved_cs_client;

2277

2278

--

2279

--

2280

2281

LOCK TABLES `videometadata` WRITE;

2282

/*!40000 ALTER TABLE `videometadata` DISABLE KEYS */;

2283

/*!40000 ALTER TABLE `videometadata` ENABLE KEYS */;

2284

UNLOCK TABLES;

2285

2286

--

2287

--

2288

2289

DROP TABLE IF EXISTS `videometadatacountry`;

2290

SET @saved_cs_client = @@character_set_client;

2291

SET character_set_client = utf8;

2292

CREATE TABLE `videometadatacountry` (

2293

`idvideo` int(10) unsigned NOT NULL,

2294

`idcountry` int(10) unsigned NOT NULL,

2295

KEY `idvideo` (`idvideo`),

2296

KEY `idcountry` (`idcountry`)

2297

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2298

SET character_set_client = @saved_cs_client;

2299

2300

--

2301

--

2302

2303

LOCK TABLES `videometadatacountry` WRITE;

2304

/*!40000 ALTER TABLE `videometadatacountry` DISABLE KEYS */;

2305

/*!40000 ALTER TABLE `videometadatacountry` ENABLE KEYS */;

2306

UNLOCK TABLES;

2307

2308

--

2309

--

2310

2311

DROP TABLE IF EXISTS `videometadatagenre`;

2312

SET @saved_cs_client = @@character_set_client;

2313

SET character_set_client = utf8;

2314

CREATE TABLE `videometadatagenre` (

2315

`idvideo` int(10) unsigned NOT NULL,

2316

`idgenre` int(10) unsigned NOT NULL,

2317

KEY `idvideo` (`idvideo`),

2318

KEY `idgenre` (`idgenre`)

2319

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2320

SET character_set_client = @saved_cs_client;

2321

2322

--

2323

--

2324

2325

LOCK TABLES `videometadatagenre` WRITE;

2326

/*!40000 ALTER TABLE `videometadatagenre` DISABLE KEYS */;

2327

/*!40000 ALTER TABLE `videometadatagenre` ENABLE KEYS */;

2328

UNLOCK TABLES;

2329

2330

--

2331

--

2332

2333

DROP TABLE IF EXISTS `videosource`;

2334

SET @saved_cs_client = @@character_set_client;

2335

SET character_set_client = utf8;

2336

CREATE TABLE `videosource` (

2337

`sourceid` int(10) unsigned NOT NULL auto_increment,

2338

`name` varchar(128) NOT NULL default '',

2339

`xmltvgrabber` varchar(128) default NULL,

2340

`userid` varchar(128) NOT NULL default '',

2341

`freqtable` varchar(16) NOT NULL default 'default',

2342

`lineupid` varchar(64) default NULL,

2343

`password` varchar(64) default NULL,

2344

`useeit` smallint(6) NOT NULL default '0',

2345

PRIMARY KEY (`sourceid`),

2346

UNIQUE KEY `name` (`name`)

2347

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2348

SET character_set_client = @saved_cs_client;

2349

2350

--

2351

--

2352

2353

LOCK TABLES `videosource` WRITE;

2354

/*!40000 ALTER TABLE `videosource` DISABLE KEYS */;

2355

/*!40000 ALTER TABLE `videosource` ENABLE KEYS */;

2356

UNLOCK TABLES;

2357

2358

--

2359

--

2360

2361

DROP TABLE IF EXISTS `videotypes`;

2362

SET @saved_cs_client = @@character_set_client;

2363

SET character_set_client = utf8;

2364

CREATE TABLE `videotypes` (

2365

`intid` int(10) unsigned NOT NULL auto_increment,

2366

`extension` varchar(128) NOT NULL,

2367

`playcommand` varchar(255) NOT NULL,

2368

`f_ignore` tinyint(1) default NULL,

2369

`use_default` tinyint(1) default NULL,

2370

PRIMARY KEY (`intid`)

2371

) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

2372

SET character_set_client = @saved_cs_client;

2373

2374

--

2375

--

2376

2377

LOCK TABLES `videotypes` WRITE;

2378

/*!40000 ALTER TABLE `videotypes` DISABLE KEYS */;

2379

INSERT INTO `videotypes` VALUES (1,'txt','',1,0),(2,'log','',1,0),(3,'mpg','Internal',0,0),(4,'avi','',0,1),(5,'vob','Internal',0,0),(6,'mpeg','Internal',0,0),(7,'VIDEO_TS','Internal',0,0),(8,'iso','Internal',0,0),(9,'img','Internal',0,0);

2380

/*!40000 ALTER TABLE `videotypes` ENABLE KEYS */;

2381

UNLOCK TABLES;

2382

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

2383

2384

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

2385

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

2386

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

2387

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

2388

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

2389

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

2390

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

2391