Difference between revisions of "Record table"

From MythTV Official Wiki
Jump to: navigation, search
m (added currect table for starttime)
m (Fix broken svn link with an equivalent github link)
(8 intermediate revisions by 4 users not shown)
Line 2: Line 2:
 
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]]).
  
−
The table is fairly self-explanatory, except for the '''type''' column, which is documented in '''enum RecordingType''' in the file [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/recordingtypes.h?format=txt libs/libmythtv/recordingtypes.h].
+
The table is fairly self-explanatory, except for the '''type''' column, which is documented in '''enum RecordingType''' in the file [https://github.com/MythTV/mythtv/blob/b2b6633ffb51df1ef134d9b4b6fed841655d0600/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h].
 +
 
 
The current values:
 
The current values:
 
{| border=1 cellspacing=0 cellpadding=5
 
{| border=1 cellspacing=0 cellpadding=5
Line 38: Line 39:
 
| 10
 
| 10
 
|}
 
|}
−
The findid is produced by calulating this: (UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528
+
The findid is produced by calculating this: (UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528
 +
 
 +
== 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      ||                | REFERENCES [[channel table|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    || REFERENCES [[recordingprofiles table|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    || REFERENCES [[recgrouppassword table|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    || REFERENCES [[playgroup table|playgroup]](name) ||
 +
|-
 +
| prefinput    || int(10)          ||      ||    || 0          || REFERENCED [[cardinput table|cardinput]](cardinputid)    ||
 +
|-
 +
| next_record  || datetime        ||      ||    || NULL      ||                |
 +
|-
 +
| last_record  || datetime        ||      ||    || NULL      ||                |
 +
|-
 +
| last_delete  || datetime        ||      ||    || NULL      ||                |
 +
|-
 +
| storagegroup  || varchar(32)      ||      ||    || Default    || REFERENCES [[storagegroup table|storagegroup]](groupname) ||
 +
|-
 +
| avg_delay    || int(11)          ||      ||    || 100        ||                |
 +
|-
 +
| filter        || int(10) unsigned ||      ||    || 0          || REFERENCES [[recordfilter table|recordfilter]](filterid) || +1277
 +
|}
 +
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 20:05, 30 July 2014

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

The table is fairly self-explanatory, except for the type column, which is documented in enum RecordingType in the file libs/libmyth/recordingtypes.h.

The current values:

kNotRecording 0
kSingleRecord 1
kTimeslotRecord 2
kChannelRecord 3
kAllRecord 4
kWeekslotRecord 5
kFindOneRecord 6
kOverrideRecord 7
kDontRecord 8
kFindDailyRecord 9
kFindWeeklyRecord 10

The findid is produced by calculating this: (UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528

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 REFERENCES 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 REFERENCES 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 REFERENCES 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 REFERENCES playgroup(name)
prefinput int(10) 0 REFERENCED cardinput(cardinputid)
next_record datetime NULL
last_record datetime NULL
last_delete datetime NULL
storagegroup varchar(32) Default REFERENCES storagegroup(groupname)
avg_delay int(11) 100
filter int(10) unsigned 0 REFERENCES recordfilter(filterid) +1277
Retrieved from "http://www.mythtv.org/wiki?title=Record_table&oldid=60735"