1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
|
// --------------------------------------------------------------------------
//
// Table Dictionary for EPG Daemon and related Plugins
//
// --------------------------------------------------------------------------
// See the README file for copyright information and how to reach the author
// --------------------------------------------------------------------------
// ----------------------------------------------------------------
// Table Events
// ----------------------------------------------------------------
Table events
{
EVENTID "" eventid UBigInt 0 Primary,
CHANNELID "" channelid Ascii 50 Primary,
MASTERID "" masterid UInt 0 Autoinc,
USEID "" useid UInt 0 Data,
SOURCE "" source Ascii 10 Meta,
FILEREF "" fileref Ascii 100 Meta,
INSSP "" inssp Int 10 Meta,
UPDSP "" updsp Int 10 Meta,
UPDFLG "" updflg Ascii 1 Meta,
DELFLG "" delflg Ascii 1 Meta,
TABLEID "" tableid Int 2 Data,
VERSION "" version Int 3 Data,
TITLE "" title Ascii 200 Data,
COMPTITLE "" comptitle Ascii 200 Data,
SHORTTEXT "" shorttext Ascii 300 Data,
COMPSHORTTEXT "" compshorttext Ascii 300 Data,
LONGDESCRIPTION "" longdescription MText 25000 Data,
COMPLONGDESCRIPTION "" complongdescription MText 25000 Data filter epgd|httpd|epg2vdr,
STARTTIME "" starttime Int 10 Data,
DURATION "" duration Int 5 Data,
PARENTALRATING "" parentalrating Int 2 Data,
VPS "" vps Int 10 Data,
CONTENTS "Genre code like table 28 of ETSI EN 300 468" contents ASCII 100 Data filter epgd|httpd|epg2vdr,
SHORTDESCRIPTION "" shortdescription MText 3000 Data,
ACTOR "" actor MText 5000 Data,
AUDIO "" audio Ascii 50 Data,
CATEGORY "" category Ascii 50 Data,
COUNTRY "" country Ascii 50 Data,
DIRECTOR "" director Text 1000 Data,
COMMENTATOR "" commentator Ascii 200 Data,
FLAGS "" flags Ascii 100 Data,
GENRE "" genre Ascii 100 Data,
MUSIC "" music Ascii 250 Data,
PRODUCER "" producer Text 1000 Data,
SCREENPLAY "" screenplay Ascii 500 Data,
SHORTREVIEW "" shortreview Ascii 500 Data,
TIPP "" tipp Ascii 250 Data,
TOPIC "" topic Ascii 1000 Data,
YEAR "" year Ascii 10 Data,
RATING "" rating Ascii 250 Data,
NUMRATING "" numrating Int 2 Data filter epgd|httpd|epg2vdr,
TXTRATING "" txtrating Ascii 100 Data,
MOVIEID "" movieid Ascii 20 Data,
MODERATOR "" moderator Ascii 250 Data,
OTHER "" other Text 2000 Data,
GUEST "" guest Text 1000 Data,
CAMERA "" camera Text 1000 Data,
EXTEPNUM "" extepnum Int 4 Data,
IMAGECOUNT "" imagecount Int 2 Data,
EPISODECOMPNAME "" episodecompname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPSHORTNAME "" episodecompshortname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPPARTNAME "" episodecomppartname Ascii 200 Data filter epgd|httpd|epg2vdr,
EPISODELANG "" episodelang Ascii 10 Data filter epgd|httpd|epg2vdr,
SCRSERIESID "" scrseriesid Int 0 Data,
SCRSERIESEPISODE "" scrseriesepisode Int 0 Data,
SCRMOVIEID "" scrmovieid Int 0 Data,
SCRSP "" scrsp Int 0 Data,
}
// ----------------------------------------------------------------
// Indices for Events
// ----------------------------------------------------------------
Index events
{
comptitle "" COMPTITLE,
source "" SOURCE,
filerefsource "" FILEREF SOURCE,
channelid "" CHANNELID,
useid "" USEID,
useidchannelid "" USEID CHANNELID,
updflgupdsp "" UPDFLG UPDSP,
sourcechannelid "" SOURCE CHANNELID,
scrsp "" SCRSP,
sourceupdsp "" SOURCE UPDSP,
scrseriesid "" SCRSERIESID,
channelidstarttime "" CHANNELID STARTTIME,
}
// ----------------------------------------------------------------
// Table Components
// ----------------------------------------------------------------
Table components
{
EVENTID "" eventid UBigInt 0 Primary,
CHANNELID "" channelid Ascii 50 Primary,
STREAM "" stream Int 3 Primary,
TYPE "" type Int 3 Primary,
LANG "" lang Ascii 8 Primary,
DESCRIPTION "" description Ascii 100 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
}
// ----------------------------------------------------------------
// Table FileRef
// ----------------------------------------------------------------
Table fileref
{
NAME "" name Ascii 100 Primary,
SOURCE "" source Ascii 10 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
EXTERNALID "" extid Ascii 10 Data,
FILEREF "" fileref Ascii 100 Data,
TAG "" tag Ascii 100 Data,
}
// ----------------------------------------------------------------
// Indices for FileRefs
// ----------------------------------------------------------------
Index filerefs
{
SourceFileref "" SOURCE FILEREF,
Fileref "" FILEREF,
}
// ----------------------------------------------------------------
// Table ImageRefs
// ----------------------------------------------------------------
Table imagerefs
{
EVENTID "" eventid UBigInt 0 Primary,
LFN "" lfn Int 0 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
SOURCE "" source Ascii 10 Meta,
FILEREF "" fileref Ascii 100 Data,
IMGNAME "" imagename Ascii 100 Data,
}
// ----------------------------------------------------------------
// Indices for ImageRefs
// ----------------------------------------------------------------
Index imagerefs
{
lfn "" LFN,
name "" IMGNAME,
}
// ----------------------------------------------------------------
// Table Images
// ----------------------------------------------------------------
Table images
{
IMGNAME "" imagename Ascii 100 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
IMAGE "" image Mlob 512000 Data,
}
// ----------------------------------------------------------------
// Table Episodes
// ----------------------------------------------------------------
Table episodes
{
COMPNAME "" compname Ascii 100 Primary,
COMPPARTNAME "" comppartname Ascii 200 Primary,
LANG "" lang Ascii 10 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
LINK "" link Int 0 Data,
SHORTNAME "" shortname Ascii 100 Data,
COMPSHORTNAME "" compshortname Ascii 100 Data,
EPISODENAME "" episodename Ascii 100 Data,
PARTNAME "" partname Ascii 300 Data,
SEASON "" season Int 0 Data,
PART "" part Int 0 Data,
PARTS "" parts Int 0 Data,
NUMBER "" number Int 0 Data,
EXTRACOL1 "" extracol1 Ascii 250 Data,
EXTRACOL2 "" extracol2 Ascii 250 Data,
EXTRACOL3 "" extracol3 Ascii 250 Data,
COMMENT "" comment Ascii 250 Data,
}
// ----------------------------------------------------------------
// Indices for Episodes
// ----------------------------------------------------------------
Index episodes
{
updsp "" UPDSP,
}
// ----------------------------------------------------------------
// Table ChannelMap
// ----------------------------------------------------------------
Table channelmap
{
EXTERNALID "" extid Ascii 10 Primary,
CHANNELID "" channelid Ascii 50 Primary,
SOURCE "" source Ascii 20 Primary,
ORDER "" ord Int 0 Data,
VISIBLE "" visible Int 0 Data,
CHANNELNAME "" channelname Ascii 100 Data,
VPS "" vps Int 0 Data,
FORMAT "" format Ascii 50 Data,
UNKNOWNATVDR "" unknownatvdr UInt 1 Data,
MERGE "" merge Int 0 Data,
MERGESP "" mergesp Int 0 Data,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
UPDFLG "" updflg Ascii 1 Meta,
}
// ----------------------------------------------------------------
// Indices for ChannelMap
// ----------------------------------------------------------------
Index channelmap
{
sourceExtid "" SOURCE EXTERNALID,
source "" SOURCE,
updflg "" UPDFLG,
sourcechannelid "" SOURCE CHANNELID,
mergesp "" MERGESP,
channelid "" CHANNELID,
}
// ----------------------------------------------------------------
// Table Vdrs
// ----------------------------------------------------------------
Table vdrs
{
UUID "" uuid Ascii 40 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
NAME "" name Ascii 100 Data,
VERSION "" version Ascii 100 Data,
DBAPI "" dbapi UInt 0 Data,
LASTUPDATE "" lastupd Int 0 Data,
NEXTUPDATE "" nextupd Int 0 Data,
LASTMERGE "" lastmerge Int 0 Data,
STATE "" state Ascii 20 Data,
MASTER "" master Ascii 1 Data,
IP "" ip Ascii 20 Data,
MAC "" mac Ascii 18 Data,
PID "" pid UInt 0 Data filter epgd|httpd|epg2vdr,
SVDRP "" svdrp UInt 0 Data filter epgd|httpd|epg2vdr,
OSD2WEBP "" osd2webp UInt 0 Data,
TUNERCOUNT "" tunercount UInt 0 Data filter epgd|httpd|epg2vdr,
SHAREINWEB "" shareinweb UInt 1 Data,
USECOMMONRECFOLDER "" usecommonrecfolder UInt 1 Data,
VIDEODIR "" videodir Ascii 300 Data,
VIDEOTOTAL "" videototal UInt 0 Data,
VIDEOFREE "" videofree UInt 0 Data,
}
// ----------------------------------------------------------------
// Indices for Vdrs
// ----------------------------------------------------------------
Index vdrs
{
state "" STATE,
}
// ----------------------------------------------------------------
// Table Users
// ----------------------------------------------------------------
Table users
{
USER "" user Ascii 40 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
PASSWD "" passwd Ascii 100 Data,
ACTIVE "" active Int 1 Data,
RIGHTS "" rights UInt 0 Data,
}
// ----------------------------------------------------------------
// Table Parameters
// ----------------------------------------------------------------
Table parameters
{
OWNER "" owner Ascii 40 Primary,
NAME "" name Ascii 40 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
VALUE "" value Ascii 500 Data,
}
// ----------------------------------------------------------------
// Table Analyse
// ----------------------------------------------------------------
Table analyse
{
CHANNELID "" channelid Ascii 50 Primary,
VDRMASTERID "" vdr_masterid UInt 0 Data,
VDREVENTID "" vdr_eventid UBigInt 0 Primary,
VDRSTARTTIME "" vdr_starttime Int 10 Data,
VDRDURATION "" vdr_duration Int 5 Data,
VDRTITLE "" vdr_title Ascii 200 Data,
VDRSHORTTEXT "" vdr_shorttext Ascii 300 Data,
EXTMASTERID "" ext_masterid UInt 0 Data,
EXTEVENTID "" ext_eventid UBigInt 0 Data,
EXTSTARTTIME "" ext_starttime Int 10 Data,
EXTDURATION "" ext_duration Int 5 Data,
EXTTITLE "" ext_title Ascii 200 Data,
EXTSHORTTEXT "" ext_shorttext Ascii 300 Data,
EXTEPISODE "" ext_episode Ascii 1 Data,
EXTMERGE "" ext_merge Int 11 Data,
EXIIMAGES "" ext_images Ascii 1 Data,
LVMIN "" lvmin Int 3 Data,
RANK "" rank Int 5 Data,
}
// ----------------------------------------------------------------
// Indices for Analyse
// ----------------------------------------------------------------
Index analyse
{
vdr_masterid "" VDRMASTERID,
}
// ----------------------------------------------------------------
// Table Snapshot
// ----------------------------------------------------------------
Table snapshot
{
CHANNELID "" channelid Ascii 50 Data,
SOURCE "" source Ascii 10 Data,
VDRMASTERID "" masterid UInt 0 Data,
EVENTID "" eventid UBigInt 0 Data,
USEID "" useid UInt 0 Data,
STARTTIME "" starttime Int 10 Data,
DURATION "" duration Int 5 Data,
TITLE "" title Ascii 200 Data,
COMPTITLE "" comptitle Ascii 200 Data,
SHORTTEXT "" shorttext Ascii 300 Data,
COMPSHORTTEXT "" compshorttext Ascii 300 Data,
UPDSP "" updsp Int 10 Data,
EPISODE "" episode Ascii 1 Data,
MERGE "" merge Int 0 Data,
IMAGES "" images Ascii 1 Data,
}
// ----------------------------------------------------------------
// Indices for Snapshot
// ----------------------------------------------------------------
Index snapshot
{
channelid "" CHANNELID,
starttimeSource "" STARTTIME SOURCE,
}
// ----------------------------------------------------------------
// Table UseEvents
// ----------------------------------------------------------------
Table useevents
{
CNTSOURCE "" cnt_source Ascii 10 Primary,
CHANNELID "" cnt_channelid Ascii 50 Primary,
CNTEVENTID "" cnt_eventid UBigInt 0 Primary|Meta,
MASTERID "" cnt_masterid UInt 0 Data|Meta,
USEID "" cnt_useid UInt 0 Data,
SUBSOURCE "" sub_source Ascii 10 Data|Meta,
SUBEVENTID "" sub_eventid UBigInt 0 Data|Meta,
UPDSP "" all_updsp Int 0 Data,
UPDFLG "" cnt_updflg Ascii 1 Data|Meta,
DELFLG "" cnt_delflg Ascii 1 Data,
FILEREF "" cnt_fileref Ascii 100 Data,
TABLEID "" cnt_tableid Int 2 Data,
VERSION "" cnt_version Int 3 Data,
TITLE "" sub_title Ascii 200 Data,
SHORTTEXT "" sub_shorttext Ascii 300 Data,
COMPTITLE "" sub_comptitle Ascii 200 Data,
COMPSHORTTEXT "" sub_compshorttext Ascii 300 Data,
GENRE "" sub_genre Ascii 100 Data,
COUNTRY "" sub_country Ascii 50 Data,
YEAR "" sub_year Ascii 10 Data,
STARTTIME "" cnt_starttime Int 10 Data,
DURATION "" cnt_duration Int 5 Data,
PARENTALRATING "" cnt_parentalrating Int 2 Data,
VPS "" cnt_vps Int 10 Data,
CONTENTS "Genre code like table 28 of ETSI EN 300 468" cnt_contents ASCII 100 Data,
CATEGORY "" sub_category Ascii 50 Data,
SHORTDESCRIPTION "" sub_shortdescription MText 3000 Data,
SHORTREVIEW "" sub_shortreview Ascii 500 Data,
TIPP "" sub_tipp Ascii 250 Data,
RATING "" sub_rating Ascii 250 Data,
NUMRATING "" sub_numrating Int 2 Data,
TXTRATING "" sub_txtrating Ascii 100 Data,
TOPIC "" sub_topic Ascii 1000 Data,
LONGDESCRIPTION "" sub_longdescription MText 25000 Data,
COMPLONGDESCRIPTION "" sub_complongdescription MText 25000 Data,
CNTLONGDESCRIPTION "" cnt_longdescription MText 25000 Data,
MODERATOR "" sub_moderator Ascii 250 Data,
GUEST "" sub_guest Text 1000 Data,
ACTOR "" sub_actor MText 5000 Data,
PRODUCER "" sub_producer Text 1000 Data,
OTHER "" sub_other Text 2000 Data,
DIRECTOR "" sub_director Text 1000 Data,
COMMENTATOR "" sub_commentator Ascii 200 Data,
SCREENPLAY "" sub_screenplay Ascii 500 Data,
CAMERA "" sub_camera Text 1000 Data,
MUSIC "" sub_music Ascii 250 Data,
AUDIO "" sub_audio Ascii 50 Data,
FLAGS "" sub_flags Ascii 100 Data,
IMAGECOUNT "" sub_imagecount Int 2 Data,
SCRSERIESID "" sub_scrseriesid Int 0 Data,
SCRSERIESEPISODE "" sub_scrseriesepisode Int 0 Data,
SCRMOVIEID "" sub_scrmovieid Int 0 Data,
SCRSP "" sub_scrsp Int 0 Data|Meta,
EPISODECOMPNAME "" sub_episodecompname Ascii 100 Data,
EPISODECOMPSHORTNAME "" sub_episodecompshortname Ascii 100 Data,
EPISODECOMPPARTNAME "" sub_episodecomppartname Ascii 200 Data,
EPISODENAME "" epi_episodename Ascii 100 Data,
EPISODESHORTNAME "" epi_shortname Ascii 100 Data,
EPISODEPARTNAME "" epi_partname Ascii 300 Data,
EPISODELANG "" epi_lang Ascii 10 Data,
EPISODEEXTRACOL1 "" epi_extracol1 Ascii 250 Data,
EPISODEEXTRACOL2 "" epi_extracol2 Ascii 250 Data,
EPISODEEXTRACOL3 "" epi_extracol3 Ascii 250 Data,
EPISODESEASON "" epi_season Int 0 Data,
EPISODEPART "" epi_part Int 0 Data,
EPISODEPARTS "" epi_parts Int 0 Data,
EPISODENUMBER "" epi_number Int 0 Data,
}
// ----------------------------------------------------------------
// Indices for UseEvents
// ----------------------------------------------------------------
Index useevents
{
channelidstarttime "" CHANNELID STARTTIME,
useid "" USEID,
channelidupdflgupdsp "" CHANNELID UPDFLG UPDSP,
channelid "" CHANNELID,
updflgstarttimeduration "" UPDSP STARTTIME DURATION,
}
// ----------------------------------------------------------------
// Table Recording List
// ----------------------------------------------------------------
Table recordinglist
{
MD5PATH "" md5path Ascii 40 Primary,
STARTTIME "" starttime UInt 0 Primary,
OWNER "uuid of vdr" owner Ascii 40 Primary,
INSSP "" inssp Int 10 Meta,
UPDSP "" updsp Int 10 Meta,
LASTIFOUPD "" lastifoupd Int 10 Meta,
VDRUUID "" vdruuid Ascii 40 Data,
PATH "" path Ascii 1000 Data,
NAME "" name Ascii 1000 Data,
FOLDER "" folder Ascii 1000 Data,
TITLE "" title Ascii 200 Data,
SHORTTEXT "" shorttext Ascii 300 Data,
LONGDESCRIPTION "" longdescription MText 25000 Data,
DURATION "" duration UInt 0 Data,
FSK "" fsk UInt 1 Data,
EVENTID "useid" eventid UInt 0 Data,
CHANNELID "" channelid Ascii 50 Data,
CHANNELNAME "just a copy" channelname Ascii 100 Data,
STATE "" state Ascii 1 Data,
INUSE "" inuse UInt 1 Data,
JOB "" job Ascii 1 Data,
// enriched by 'external' data of events
ACTOR "" actor MText 5000 Data,
AUDIO "" audio Ascii 50 Data,
CATEGORY "" category Ascii 50 Data,
COUNTRY "" country Ascii 50 Data,
DIRECTOR "" director Text 1000 Data,
FLAGS "" flags Ascii 100 Data,
GENRE "" genre Ascii 100 Data,
MUSIC "" music Ascii 250 Data,
PRODUCER "" producer Text 1000 Data,
SCREENPLAY "" screenplay Ascii 500 Data,
SHORTREVIEW "" shortreview Ascii 500 Data,
TIPP "" tipp Ascii 250 Data,
TOPIC "" topic Ascii 1000 Data,
YEAR "" year Ascii 10 Data,
RATING "" rating Ascii 250 Data,
NUMRATING "" numrating Int 2 Data,
TXTRATING "" txtrating Ascii 100 Data,
MODERATOR "" moderator Ascii 250 Data,
OTHER "" other Text 2000 Data,
GUEST "" guest Text 1000 Data,
CAMERA "" camera Text 1000 Data,
// episode reference
EPISODECOMPNAME "" episodecompname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPSHORTNAME "" episodecompshortname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPPARTNAME "" episodecomppartname Ascii 200 Data filter epgd|httpd|epg2vdr,
EPISODELANG "" episodelang Ascii 10 Data filter epgd|httpd|epg2vdr,
// scraper fields
// IDs found while scraping (reference to scraper tables), managed by epgd
SCRSERIESID "" scrseriesid UInt 0 Data,
SCRSERIESEPISODE "" scrseriesepisode UInt 0 Data,
SCRMOVIEID "" scrmovieid UInt 0 Data,
// this fields are written by the scraper plugin,
// the id fields hold the user hint for scraping
SCRINFOMOVIEID "" scrinfomovieid UInt 0 Data,
SCRINFOSERIESID "" scrinfoseriesid UInt 0 Data,
SCRINFOEPISODEID "" scrinfoepisodeid UInt 0 Data,
SCRNEW "" scrnew UInt 0 Data,
SCRSP "" scrsp Int 0 Data,
}
// ----------------------------------------------------------------
// Table RecordingDirs
// ----------------------------------------------------------------
Table recordingdirs
{
VDRUUID "" vdruuid Ascii 40 Primary,
DIRECTORY "" directory Ascii 255 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
}
// ----------------------------------------------------------------
// Table Timers
// ----------------------------------------------------------------
Table timers
{
ID "" id UInt 0 Primary|Autoinc,
VDRUUID "" vdruuid Ascii 40 Primary,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
EVENTID "useid" eventid UInt 0 Data,
CHANNELID "" channelid Ascii 50 Data,
_STARTTIME "pre filled start timer for trigger" _starttime Int 10 Data,
SOURCE "like osd, webif, epgd" source Ascii 40 Data,
TYPE "'R'ecord, 'V'iew (umschalt)" type Ascii 1 Data,
STATE "'D'eleted, 'R'unning, 'F'inished" state Ascii 1 Data default u,
INFO "error reason if state is failed" info Ascii 255 Data,
ACTION "" action Ascii 1 Data default a,
TCCMAILCNT "" tccmailcnt UInt 0 Data,
WRNCOUNT "" wrncount UInt 0 Data,
RETRYS "" retrys UInt 0 Data,
NAMINGMODE "" namingmode Int 0 Data,
TEMPLATE "" template Ascii 100 Data,
ACTIVE "" active UInt 0 Data,
DAY "" day Int 10 Data,
WEEKDAYS "" weekdays Int 10 Data,
STARTTIME "" starttime Int 10 Data,
ENDTIME "" endtime Int 10 Data,
FILE "" file Ascii 512 Data,
DIRECTORY "" directory Ascii 512 Data,
PRIORITY "" priority Int 0 Data,
LIFETIME "" lifetime Int 0 Data,
VPS "" vps Int 0 Data,
CHILDLOCK "" childlock Int 0 Data,
AUX "" aux Ascii 1000 Data,
AUTOTIMERNAME "Bezeichung des Suchtimers" autotimername Ascii 100 Data,
AUTOTIMERID "id of autotimer" autotimerid UInt 0 Data,
AUTOTIMERINSSP "" autotimerinssp Int 0 Data,
// just to update the done state by the plugin !!
DONEID "id of done entry" doneid UInt 0 Data,
EXPRESSION "" expression Ascii 200 Data,
}
// ----------------------------------------------------------------
// Indices for Timers
// ----------------------------------------------------------------
Index timers
{
eventidchannelidvdruuid "" EVENTID CHANNELID VDRUUID,
vdruuidstate "" VDRUUID STATE
}
// ----------------------------------------------------------------
// Table
// ----------------------------------------------------------------
Table searchtimers
{
ID "" id UInt 0 Primary|Autoinc,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
CHANNELIDS "comma separated list of channleids or empty" channelids Ascii 500 Data,
CHEXCLUDE "" chexclude UInt 0 Data,
CHFORMAT "HD,SD" chformat Ascii 50 Data,
NAME "Bezeichung des Suchtimers" name Ascii 100 Data,
EXPRESSION "" expression Ascii 200 Data,
EXPRESSION1 "" expression1 Ascii 200 Data,
SEARCHMODE "1 exact, 2 regexp, 3 like, 4 enthalten, .." searchmode UInt 0 Data,
SEARCHFIELDS "Bitmaske: 1 title, 2 shorttext, 4 - desc, .." searchfields UInt 0 Data,
SEARCHFIELDS1 "Bitmaske: 0 off, 1 title, 2 shorttext, 4 - desc, .." searchfields1 UInt 0 Data,
CASESENSITIV "0,1" casesensitiv UInt 0 Data,
REPEATFIELDS "Bitmaske: 1 title, 2 shorttext, 4 - desc, .." repeatfields UInt 0 Data,
// optional EPG Detail options
EPISODENAME "" episodename Ascii 100 Data,
SEASON "e.g. '1-7'" season Ascii 10 Data,
SEASONPART "e.g. '20-'" seasonpart Ascii 10 Data,
CATEGORY "e.g. 'Spielfilm','Serie'" category Ascii 150 Data,
GENRE "e.g. 'Krimi','Action'" genre Ascii 150 Data,
YEAR "e.g. '2010-2015'" year Ascii 10 Data,
TIPP "" tipp Ascii 250 Data,
NOEPGMATCH "" noepgmatch Int 0 Data,
// steering
TYPE "'R'ecord, 'V'iew, 'S'earch" type Ascii 1 Data,
STATE "D - Deleted" state Ascii 1 Data,
NAMINGMODE "" namingmode Int 0 Data,
TEMPLATE "" template Ascii 100 Data,
ACTIVE "0,1" active UInt 0 Data,
SOURCE "webif ,osd, ..." source Ascii 40 Data,
HITS "stastic counter, just for info" hits UInt 0 Data,
MODSP "last user modification time" modsp Int 0 Data,
LASTRUN "last execution of search timer" lastrun Int 0 Data,
VDRUUID "empty or uuid of vdr" vdruuid Ascii 40 Data,
// timer details
WEEKDAYS "bitmask like timers, 0 foy all" weekdays Int 0 Data,
NEXTDAYS "" nextdays UInt 0 Data,
STARTTIME "null for unlimited search" starttime Int 0 Data,
ENDTIME "null for unlimited search" endtime Int 0 Data,
DIRECTORY "" directory Ascii 512 Data,
PRIORITY "" priority Int 0 Data,
LIFETIME "" lifetime Int 0 Data,
VPS "" vps Int 0 Data,
CHILDLOCK "" childlock Int 0 Data,
}
// ----------------------------------------------------------------
// Table TimersDone
// ----------------------------------------------------------------
Table timersdone
{
ID "" id UInt 0 Primary|Autoinc,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
SOURCE "" source Ascii 40 Data,
STATE "Q requested, C created, R recorded, F Failed" state Ascii 1 Data,
TIMERID "not filled completely in all cases yet" timerid UInt 0 Data,
AUTOTIMERID "" autotimerid UInt 0 Data,
AUTOTIMERNAME "Bezeichung des Suchtimers" autotimername Ascii 100 Data,
// to compare
TITLE "" title Ascii 200 Data,
COMPTITLE "" comptitle Ascii 200 Data,
SHORTTEXT "" shorttext Ascii 300 Data,
COMPSHORTTEXT "" compshorttext Ascii 300 Data,
LONGDESCRIPTION "" longdescription MText 25000 Data,
COMPLONGDESCRIPTION "" complongdescription MText 25000 Data,
EPISODECOMPNAME "" episodecompname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPSHORTNAME "" episodecompshortname Ascii 100 Data filter epgd|httpd|epg2vdr,
EPISODECOMPPARTNAME "" episodecomppartname Ascii 200 Data filter epgd|httpd|epg2vdr,
EPISODELANG "" episodelang Ascii 10 Data filter epgd|httpd|epg2vdr,
EPISODESEASON "" episodeseason Int 0 Data,
EPISODEPART "" episodepart Int 0 Data,
// just for info
CHANNELID "" channelid Ascii 50 Data,
CHANNELNAME "" channelname Ascii 100 Data;
EXPRESSION "expression of autotimer" expression Ascii 200 Data,
STARTTIME "" starttime Int 10 Data,
DURATION "" duration Int 5 Data,
AUX "" aux Ascii 512 Data,
}
// ----------------------------------------------------------------
// Indices for TimersDone
// ----------------------------------------------------------------
Index TimersDone
{
checkdoubles "" COMPTITLE, COMPSHORTTEXT
}
// ----------------------------------------------------------------
// Table Messages / Notifications
// ----------------------------------------------------------------
Table messages
{
ID "" id UInt 0 Primary|Autoinc,
INSSP "" inssp Int 0 Meta,
UPDSP "" updsp Int 0 Meta,
TYPE "Warning, Info, Error, Fatal" type Ascii 1 Data,
TITLE "" title Ascii 200 Data,
STATE "Read, New, Deleted" state Ascii 1 Data,
TEXT "" text MText 20000 Data,
}
// ----------------------------------------------------------------
// SCRAPER stuff
// ----------------------------------------------------------------
// ----------------------------------------------------------------
// Table Series
// ----------------------------------------------------------------
Table series
{
SERIESID "" series_id UInt 0 Primary,
SERIESNAME "" series_name Ascii 200 Data,
SERIESLASTSCRAPED "" series_last_scraped UInt 0 Data,
SERIESLASTUPDATED "" series_last_updated UInt 0 Data,
SERIESOVERVIEW "" series_overview Text 10000 Data,
SERIESFIRSTAIRED "" series_firstaired Ascii 50 Data,
SERIESNETWORK "" series_network Ascii 100 Data,
SERIESIMDBID "" series_imdb_id Ascii 20 Data,
SERIESGENRE "" series_genre Ascii 100 Data,
SERIESRATING "" series_rating Float 31 Data,
SERIESSTATUS "" series_status Ascii 50 Data,
}
// ----------------------------------------------------------------
// Indices for Series
// ----------------------------------------------------------------
Index series
{
seriesname "" SERIESNAME,
}
// ----------------------------------------------------------------
// Table SeriesEpisode
// ----------------------------------------------------------------
Table series_episode
{
EPISODEID "" episode_id UInt 0 Primary,
EPISODENUMBER "" episode_number UInt 0 Data,
SEASONNUMBER "" season_number UInt 0 Data,
EPISODENAME "" episode_name Ascii 300 Data,
EPISODEOVERVIEW "" episode_overview Text 10000 Data,
EPISODEFIRSTAIRED "" episode_firstaired Ascii 20 Data,
EPISODEGUESTSTARS "" episode_gueststars Ascii 1000 Data,
EPISODERATING "" episode_rating Float 31 Data,
EPISODELASTUPDATED "" episode_last_updated UInt 0 Data,
SERIESID "" series_id UInt 0 Data,
}
// ----------------------------------------------------------------
// Indices for SeriesEpisode
// ----------------------------------------------------------------
Index series_episode
{
series_id "" SERIESID,
}
// ----------------------------------------------------------------
// Table SeriesMedia
// ----------------------------------------------------------------
Table series_media
{
SERIESID "" series_id UInt 0 Primary,
SEASONNUMBER "" season_number UInt 0 Primary,
EPISODEID "" episode_id UInt 0 Primary,
ACTORID "" actor_id UInt 0 Primary,
MEDIATYPE "" media_type UInt 0 Primary,
INSSP "" inssp Int 0 Meta filter epgd|httpd|epg2vdr,
UPDSP "" updsp Int 0 Meta filter epgd|httpd|epg2vdr,
MEDIAURL "" media_url Ascii 100 Data,
MEDIAWIDTH "" media_width UInt 0 Data,
MEDIAHEIGHT "" media_height UInt 0 Data,
MEDIARATING "" media_rating Float 31 Data,
MEDIACONTENT "" media_content Mlob 1000000 Data,
}
// ----------------------------------------------------------------
// Indices for SeriesMedia
// ----------------------------------------------------------------
Index series_media
{
series_id "" SERIESID,
season_number "" SEASONNUMBER,
episode_id "" EPISODEID,
actor_id "" ACTORID,
}
// ----------------------------------------------------------------
// Table SeriesActor
// ----------------------------------------------------------------
Table series_actor
{
ACTORID "" actor_id UInt 0 Primary,
ACTORNAME "" actor_name Ascii 100 Data,
ACTORROLE "" actor_role Ascii 500 Data,
SORTORDER "" actor_sortorder UInt 0 Data,
}
// ----------------------------------------------------------------
// Indices for SeriesActor
// ----------------------------------------------------------------
Index series_actor
{
}
// ----------------------------------------------------------------
// Table Movie
// ----------------------------------------------------------------
Table movie
{
MOVIEID "" movie_id UInt 0 Primary,
TITLE "" movie_title Ascii 300 Data,
ORIGINALTITLE "" movie_original_title Ascii 300 Data,
TAGLINE "" movie_tagline Ascii 1000 Data,
OVERVIEW "" movie_overview Text 5000 Data,
ISADULT "" movie_adult UInt 0 Data,
COLLECTIONID "" movie_collection_id UInt 0 Data,
COLLECTIONNAME "" movie_collection_name Ascii 300 Data,
BUDGET "" movie_budget UInt 0 Data,
REVENUE "" movie_revenue UInt 0 Data,
GENRES "" movie_genres Ascii 500 Data,
HOMEPAGE "" movie_homepage Ascii 300 Data,
RELEAASEDATE "" movie_release_date Ascii 20 Data,
RUNTIME "" movie_runtime UInt 0 Data,
POPULARITY "" movie_popularity Float 31 Data,
VOTEAVERAGE "" movie_vote_average Float 31 Data,
}
// ----------------------------------------------------------------
// Indices for Movies
// ----------------------------------------------------------------
Index movie
{
movie_id "" MOVIEID,
movietitle "" TITLE,
}
// ----------------------------------------------------------------
// Table MovieActor
// ----------------------------------------------------------------
Table movie_actor
{
ACTORID "" actor_id UInt 0 Primary,
ACTORNAME "" actor_name Ascii 300 Data,
}
// ----------------------------------------------------------------
// Indices for MovieActor
// ----------------------------------------------------------------
Index movie_actor
{
actor_id "" ACTORID,
}
// ----------------------------------------------------------------
// Table MovieActors
// ----------------------------------------------------------------
Table movie_actors
{
MOVIEID "" movie_id UInt 0 Primary,
ACTORID "" actor_id UInt 0 Primary,
ROLE "" actor_role Ascii 300 Data,
}
// ----------------------------------------------------------------
// Indices for MovieActors
// ----------------------------------------------------------------
Index movie_actors
{
movie_id "" MOVIEID,
actor_id "" ACTORID,
}
// ----------------------------------------------------------------
// Table MovieMedia
// ----------------------------------------------------------------
Table movie_media
{
MOVIEID "" movie_id UInt 0 Primary,
ACTORID "" actor_id UInt 0 Primary,
MEDIATYPE "" media_type UInt 0 Primary,
MEDIAURL "" media_url Ascii 100 Data,
MEDIAWIDTH "" media_width UInt 0 Data,
MEDIAHEIGHT "" media_height UInt 0 Data,
MEDIACONTENT "" media_content Mlob 1000000 Data,
}
// ----------------------------------------------------------------
// Indices for MovieMedia
// ----------------------------------------------------------------
Index movie_media
{
movie_id "" MOVIEID,
actor_id "" ACTORID,
}
|
