Record table
From MythTV Official Wiki
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) | +? |