Difference between revisions of "Record table"

From MythTV Official Wiki
Jump to: navigation, search
(Convert FOREIGN KEYS to new template DbRef)
 
(15 intermediate revisions by 9 users not shown)
Line 1: Line 1:
 +
{{Wrongtitle|record table}}
 
The '''record table''' contains the list of recording rules that have been created. The [[scheduler]] uses this information to determine which shows in the [[program table]] should be recorded and on what [[video capture card]] (listed in the [[capturecard table]]).
 
The '''record table''' contains the list of recording rules that have been created. The [[scheduler]] uses this information to determine which shows in the [[program table]] should be recorded and on what [[video capture card]] (listed in the [[capturecard table]]).
−
[[BR]]
+
 
−
The table is fairly self-explanatory, except fot the '''type''' column, which is documented in '''enum RecordingType''' in the file libs/libmythtv/recordingtypes.h.
+
;type: documented in '''enum RecordingType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h].
−
The current values:
+
:{| border=1 cellspacing=0 cellpadding=5
−
     kNotRecording = 0,
+
| kNotRecording
−
     kSingleRecord = 1,
+
| 0
−
     kTimeslotRecord = 2,
+
|-
−
     kChannelRecord = 3,
+
| kSingleRecord
−
     kAllRecord = 4,
+
| 1
−
     kWeekslotRecord = 5,
+
|-
−
     kFindOneRecord = 6,
+
| kTimeslotRecord
−
     kOverrideRecord = 7,
+
| 2
−
     kDontRecord = 8,
+
|-
−
     kFindDailyRecord = 9,
+
| kChannelRecord (Obsolete)
−
     kFindWeeklyRecord = 10
+
| 3
 +
|-
 +
| kAllRecord
 +
| 4
 +
|-
 +
| kWeekslotRecord
 +
| 5
 +
|-
 +
| kFindOneRecord
 +
| 6
 +
|-
 +
| kOverrideRecord
 +
| 7
 +
|-
 +
| kDontRecord
 +
| 8
 +
|-
 +
| kFindDailyRecord (Obsolete)
 +
| 9
 +
|-
 +
| kFindWeeklyRecord (Obsolete)
 +
| 10
 +
|-
 +
| kTemplateRecord
 +
| 11
 +
|}
 +
;dupmethod:[[Duplicate matching]] method, documented in '''enum RecordingDupMethodType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h].
 +
:{| border=1 cellspacing=0 cellpadding=5
 +
|-
 +
| kDupCheckUnset
 +
| 0x00
 +
|-
 +
| kDupCheckNone
 +
| 0x01
 +
|-
 +
| kDupCheckSub
 +
| 0x02
 +
|-
 +
| kDupCheckDesc
 +
| 0x04
 +
|-
 +
| kDupCheckSubDesc
 +
| 0x06
 +
|-
 +
| kDupCheckSubThenDesc
 +
| 0x08
 +
|}
 +
;dupin:[[Duplicate matching]] where, documented in '''enum RecordingDupInType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h].
 +
:{| border=1 cellspacing=0 cellpadding=5
 +
|-
 +
| kDupsUnset
 +
| 0x00
 +
|-
 +
| kDupsInRecorded
 +
| 0x01
 +
|-
 +
| kDupsInOldRecorded
 +
| 0x02
 +
|-
 +
| kDupsInAll
 +
| 0x0F
 +
|-
 +
| kDupsNewEpi
 +
| 0x10
 +
|}
 +
;station: Station callsign
 +
;inetref: Metadata lookup, e.g. <tt>ttvdb.py_12345</tt> or <tt>tmdb3.py_12345</tt>
 +
;search: Search type, , documented in '''enum RecSearchType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h].
 +
:{| border=1 cellspacing=0 cellpadding=5
 +
|-
 +
| kNoSearch
 +
| 0
 +
|-
 +
| kPowerSearch
 +
| 1
 +
|-
 +
| kTitleSearch
 +
| 2
 +
|-
 +
| kKeywordSearch
 +
| 3
 +
|-
 +
| kPeopleSearch
 +
| 4
 +
|-
 +
| kManualSearch
 +
| 5
 +
|}
 +
;findday: ?
 +
;findtime: time of day
 +
;findid: represent a <i>days sinf 0000-01-01</i> and is calculates with <tt>(UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528</tt>
 +
;parentid: ?
 +
;transcoder: ?
 +
;avg_delay: ?
 +
 
 +
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
! Field name    !! Type            !! Null !! Key !! Default    !! Extras        || Schema-Version
 +
|-
 +
| recordid      || int(10) unsigned ||      || PRI || NULL      || auto_increment |
 +
|-
 +
| type          || int(10) unsigned ||      || MUL || 0          ||                |
 +
|-
 +
| chanid        || int(10) unsigned || YES  || MUL || NULL      || {{DbRef|channel|chanid}} ||
 +
|-
 +
| starttime    || time            ||      ||    || 00:00:00  ||                |
 +
|-
 +
| startdate    || date            ||      ||    || 0000-00-00 ||                |
 +
|-
 +
| endtime      || time            ||      ||    || 00:00:00  ||                |
 +
|-
 +
| enddate      || date            ||      ||    || 0000-00-00 ||                |
 +
|-
 +
| title        || varchar(128)    ||      || MUL ||            ||                |
 +
|-
 +
| subtitle      || varchar(128)    ||      ||    ||            ||                |
 +
|-
 +
| description  || varchar(16000)  ||      ||    ||            ||                |
 +
|-
 +
| season        || smallint(5)      ||      ||    ||            ||                || +1278
 +
|-
 +
| episode      || smallint(5)      ||      ||    ||            ||                || +1278
 +
|-
 +
| category      || varchar(64)      ||      ||    ||            ||                |
 +
|-
 +
| profile      || varchar(128)    ||      ||    || Default    || {{DbRef|recordingprofiles|name}} ||
 +
|-
 +
| recpriority  || int(10)          ||      ||    || 0          ||                |
 +
|-
 +
| autoexpire    || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| maxepisodes  || int(11)          ||      || MUL || 0          ||                |
 +
|-
 +
| maxnewest    || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| startoffset  || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| endoffset    || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| recgroup      || varchar(32)      ||      ||    || Default    || {{DbRef|recgrouppassword|recgroup}} ||
 +
|-
 +
| dupmethod    || int(11)          ||      ||    || 6          ||                |
 +
|-
 +
| dupin        || int(11)          ||      ||     || 15        ||                |
 +
|-
 +
| station      || varchar(20)      ||      ||    ||            ||                |
 +
|-
 +
| seriesid      || varchar(64)      || YES  || MUL || NULL      ||                |
 +
|-
 +
| programid    || varchar(64)      || YES  || MUL || NULL      ||                |
 +
|-
 +
| inetref      || varchar(40)      ||      ||    ||            ||                || +1278
 +
|-
 +
| search        || int(10) unsigned ||      || MUL || 0          ||                |
 +
|-
 +
| autotranscode || tinyint(1)      ||      ||    || 0         ||                |
 +
|-
 +
| autocommflag  || tinyint(1)      ||      ||     || 0          ||                |
 +
|-
 +
| autouserjob1  || tinyint(1)      ||      ||    || 0          ||                |
 +
|-
 +
| autouserjob2  || tinyint(1)      ||      ||    || 0          ||                |
 +
|-
 +
| autouserjob3  || tinyint(1)      ||      ||     || 0          ||                |
 +
|-
 +
| autouserjob4  || tinyint(1)      ||      ||     || 0          ||                |
 +
|-
 +
| autometadata  || tinyint(1)      ||      ||     || 0          ||                || +1278
 +
|-
 +
| findday      || tinyint(4)      ||      ||    || 0          ||                |
 +
|-
 +
| findtime      || time            ||      ||    || 00:00:00  ||                |
 +
|-
 +
| findid        || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| inactive      || tinyint(1)      ||      ||    || 0          ||                |
 +
|-
 +
| parentid      || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| transcoder    || int(11)          ||      ||    || 0          ||                |
 +
|-
 +
| playgroup    || varchar(32)      ||      ||    || Default    || {{DbRef|playgroup|name}} ||
 +
|-
 +
| prefinput    || int(10)          ||      ||    || 0          || {{DbRef|cardinput|cardinputid}}     ||
 +
|-
 +
| next_record  || datetime        ||      ||     || NULL      ||                |
 +
|-
 +
| last_record  || datetime        ||      ||     || NULL      ||                |
 +
|-
 +
| last_delete  || datetime        ||      ||     || NULL      ||                |
 +
|-
 +
| storagegroup  || varchar(32)      ||      ||     || Default    || {{DbRef|storagegroup|groupname}} ||
 +
|-
 +
| avg_delay    || int(11)          ||      ||     || 100        ||                |
 +
|-
 +
| filter        || int(10) unsigned ||      ||    || 0          || {{DbRef|recordfilter|filterid}} || +1277
 +
|-
 +
| recgroupid    || smallint(4)      ||      || MUL || 1          || {{DbRef|recgroups|recgroupid}} || +?
 +
|}
 +
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 13:55, 22 February 2021

Important.png Note: The correct title of this article is record table. It appears incorrectly here due to technical restrictions.

The record table contains the list of recording rules that have been created. The scheduler uses this information to determine which shows in the program table should be recorded and on what video capture card (listed in the capturecard table).

type
documented in enum RecordingType in the file libs/libmyth/recordingtypes.h.
kNotRecording 0
kSingleRecord 1
kTimeslotRecord 2
kChannelRecord (Obsolete) 3
kAllRecord 4
kWeekslotRecord 5
kFindOneRecord 6
kOverrideRecord 7
kDontRecord 8
kFindDailyRecord (Obsolete) 9
kFindWeeklyRecord (Obsolete) 10
kTemplateRecord 11
dupmethod
Duplicate matching method, documented in enum RecordingDupMethodType in the file libs/libmyth/recordingtypes.h.
kDupCheckUnset 0x00
kDupCheckNone 0x01
kDupCheckSub 0x02
kDupCheckDesc 0x04
kDupCheckSubDesc 0x06
kDupCheckSubThenDesc 0x08
dupin
Duplicate matching where, documented in enum RecordingDupInType in the file libs/libmyth/recordingtypes.h.
kDupsUnset 0x00
kDupsInRecorded 0x01
kDupsInOldRecorded 0x02
kDupsInAll 0x0F
kDupsNewEpi 0x10
station
Station callsign
inetref
Metadata lookup, e.g. ttvdb.py_12345 or tmdb3.py_12345
search
Search type, , documented in enum RecSearchType in the file libs/libmyth/recordingtypes.h.
kNoSearch 0
kPowerSearch 1
kTitleSearch 2
kKeywordSearch 3
kPeopleSearch 4
kManualSearch 5
findday
 ?
findtime
time of day
findid
represent a days sinf 0000-01-01 and is calculates with (UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528
parentid
 ?
transcoder
 ?
avg_delay
 ?

Table Description

Field name Type Null Key Default Extras Schema-Version
recordid int(10) unsigned PRI NULL
type int(10) unsigned MUL 0
chanid int(10) unsigned YES MUL NULL REF channel(chanid)
starttime time 00:00:00
startdate date 0000-00-00
endtime time 00:00:00
enddate date 0000-00-00
title varchar(128) MUL
subtitle varchar(128)
description varchar(16000)
season smallint(5) +1278
episode smallint(5) +1278
category varchar(64)
profile varchar(128) Default REF recordingprofiles(name)
recpriority int(10) 0
autoexpire int(11) 0
maxepisodes int(11) MUL 0
maxnewest int(11) 0
startoffset int(11) 0
endoffset int(11) 0
recgroup varchar(32) Default REF recgrouppassword(recgroup)
dupmethod int(11) 6
dupin int(11) 15
station varchar(20)
seriesid varchar(64) YES MUL NULL
programid varchar(64) YES MUL NULL
inetref varchar(40) +1278
search int(10) unsigned MUL 0
autotranscode tinyint(1) 0
autocommflag tinyint(1) 0
autouserjob1 tinyint(1) 0
autouserjob2 tinyint(1) 0
autouserjob3 tinyint(1) 0
autouserjob4 tinyint(1) 0
autometadata tinyint(1) 0 +1278
findday tinyint(4) 0
findtime time 00:00:00
findid int(11) 0
inactive tinyint(1) 0
parentid int(11) 0
transcoder int(11) 0
playgroup varchar(32) Default REF playgroup(name)
prefinput int(10) 0 REF cardinput(cardinputid)
next_record datetime NULL
last_record datetime NULL
last_delete datetime NULL
storagegroup varchar(32) Default REF storagegroup(groupname)
avg_delay int(11) 100
filter int(10) unsigned 0 REF recordfilter(filterid) +1277
recgroupid smallint(4) MUL 1 REF recgroups(recgroupid) +?
Retrieved from "http://www.mythtv.org/wiki?title=Record_table&oldid=65611"