Difference between revisions of "Oldrecorded table"

From MythTV Official Wiki
Jump to: navigation, search
m (Added rectype description)
m (foreign key)
 
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{Wrongtitle|oldrecorded table}}
 
{{Wrongtitle|oldrecorded table}}
 
The '''oldrecorded table''' lists all of the recordings that have been made. It is used by the [[scheduler]] to determine whether new shows are duplicates of previously recorded shows. [[mythfrontend]] provides a mechanism (Manage Recordings => Previously Recorded => Highlight programme, press D (for delete) and then click OK when prompted) to delete shows from this table in order to make the [[scheduler]] forget that they were ever recorded.
 
The '''oldrecorded table''' lists all of the recordings that have been made. It is used by the [[scheduler]] to determine whether new shows are duplicates of previously recorded shows. [[mythfrontend]] provides a mechanism (Manage Recordings => Previously Recorded => Highlight programme, press D (for delete) and then click OK when prompted) to delete shows from this table in order to make the [[scheduler]] forget that they were ever recorded.
 +
 +
This table also contains "future" entries for programs the scheduler intends to record.  These entries are used to determine what was missed or should have happened after a crash or hang.
 +
 +
See the [[recorded table]] for additional reference.
  
 
== Table Description ==
 
== Table Description ==
 
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 
|- style="background: lightsteelblue"
 
|- style="background: lightsteelblue"
!  Field name  !! Type            !! Null !! Key !! Default            !! Extras
+
!  Field name  !! Type            !! Null !! Key !! Default            !! Extras !! Schema-Version
 
|-
 
|-
|| chanid      || int(10) unsigned ||      ||     || 0                  ||
+
|| chanid      || int(10) unsigned ||      || MUL || 0                  || REFERENCES [[channel table|channel]](chanid)
 
|-
 
|-
 
|| starttime  || datetime        ||      || PRI || 0000-00-00 00:00:00 ||
 
|| starttime  || datetime        ||      || PRI || 0000-00-00 00:00:00 ||
Line 15: Line 19:
 
|| title      || varchar(128)    ||      || PRI ||                    ||
 
|| title      || varchar(128)    ||      || PRI ||                    ||
 
|-
 
|-
|| subtitle    || varchar(128)    ||      ||     ||                    ||
+
|| subtitle    || varchar(128)    ||      || MUL ||                    ||
 +
|-
 +
|| description || text            ||      || MUL ||                    ||
 
|-
 
|-
|| description || text            ||      ||    ||                    ||
+
|| season      || smallint(5)      ||      ||    ||                    || || +1278
 +
|-
 +
|| episode    || smallint(5)      ||      ||    ||                    || || +1278
 
|-
 
|-
 
|| category    || varchar(64)      ||      ||    ||                    ||
 
|| category    || varchar(64)      ||      ||    ||                    ||
 
|-
 
|-
|| seriesid    || varchar(12)      ||     || MUL ||                     ||
+
|| seriesid    || varchar(64)      || NULL || MUL || NULL                ||
 
|-
 
|-
|| programid  || varchar(20)      ||      || MUL ||                     ||
+
|| programid  || varchar(64)      || NULL || MUL || NULL                || REFERENCES [[program table|program]](programid)
 +
|-
 +
|| inetref    || varchar(40)      ||      ||     || NULL                || || +1278
 
|-
 
|-
 
|| findid      || int(11)          ||      ||    || 0                  ||
 
|| findid      || int(11)          ||      ||    || 0                  ||
 
|-
 
|-
|| recordid    || int(11)          ||      || MUL || 0                  ||
+
|| recordid    || int(11)          ||      || MUL || 0                  || REFERENCES [[record table|record]](recordid)
 
|-
 
|-
 
|| station    || varchar(20)      ||      || PRI ||                    ||
 
|| station    || varchar(20)      ||      || PRI ||                    ||
Line 39: Line 49:
 
|| reactivate  || smallint(6)      ||      ||    || 0                  ||
 
|| reactivate  || smallint(6)      ||      ||    || 0                  ||
 
|-
 
|-
|| generic    || tinyint(1)      || YES  ||    || 0                  ||
+
|| generic    || tinyint(1)      ||     ||    || NULL                || || +1109
 +
|-
 +
|| future      || tinyint(1)      ||      || MUL || 0                  || || +1271
 
|-
 
|-
 
|}
 
|}
Line 57: Line 69:
 
*'''rectype''' has the same meaning as the ''type'' field of the [[record table]].
 
*'''rectype''' has the same meaning as the ''type'' field of the [[record table]].
 
*'''duplicate''' determines whether a show should be recorded again or not (0 = yes, 1 = no).
 
*'''duplicate''' determines whether a show should be recorded again or not (0 = yes, 1 = no).
*'''recstatus''' recording status. See the [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/programinfo.h?rev=17318#L103 RecStatusType] enum in [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmyth/programinfo.h libs/libmyth/programinfo.h] for a definition of the values.
+
*'''recstatus''' recording status. See the [https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmyth/programtypes.h#L210 RecStatusType] enum in [https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmyth/programtypes.h libs/libmyth/programtypes.h] for a definition of the values.
*'''reactivate''' asks the scheduler to restart this recording if possible (1 = reactivate, 0=default). See [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/programinfo.cpp?rev=17318#L2923 ProgramInfo::ReactivateRecording(void)] in [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/programinfo.cpp mythtv/libs/libmythtv/programinfo.cpp] for where it is set.
+
*'''reactivate''' asks the scheduler to restart this recording if possible (1 = reactivate, 0=default). See [https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmythtv/recordinginfo.cpp#L1102 RecordingInfo::ReactivateRecording(void)] in [https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmythtv/recordinginfo.cpp mythtv/libs/libmythtv/recordinginfo.cpp] for where it is set.
*'''generic''' identifies a [[generic listing]] (1=generic, 0=default). Introduced in schema [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/dbcheck.cpp?rev=17318#L1955 rev 1109] in [http://svn.mythtv.org/trac/browser/trunk/mythtv/libs/libmythtv/dbcheck.cpp mythtv/libs/libmythtv/dbcheck.cpp], which shows how it is initialized.
+
*'''generic''' identifies a [[generic listing]] (1=generic, 0=default). Introduced in schema {{gitcommit|a1a9210|mythtv|rev 1109}} in [https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmythtv/dbcheck.cpp mythtv/libs/libmythtv/dbcheck.cpp], which shows how it is initialized.
 
+
*'''future''' identifies a future entries (1=future, 0=non-future). Introduced in schema 1271 in commit {{gitcommit|543d783|mythtv|v0.25pre-1716-g543d783}}}.
{{stub}}
 
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 14:28, 4 January 2016

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

The oldrecorded table lists all of the recordings that have been made. It is used by the scheduler to determine whether new shows are duplicates of previously recorded shows. mythfrontend provides a mechanism (Manage Recordings => Previously Recorded => Highlight programme, press D (for delete) and then click OK when prompted) to delete shows from this table in order to make the scheduler forget that they were ever recorded.

This table also contains "future" entries for programs the scheduler intends to record. These entries are used to determine what was missed or should have happened after a crash or hang.

See the recorded table for additional reference.

Table Description

Field name Type Null Key Default Extras Schema-Version
chanid int(10) unsigned MUL 0 REFERENCES channel(chanid)
starttime datetime PRI 0000-00-00 00:00:00
endtime datetime MUL 0000-00-00 00:00:00
title varchar(128) PRI
subtitle varchar(128) MUL
description text MUL
season smallint(5) +1278
episode smallint(5) +1278
category varchar(64)
seriesid varchar(64) NULL MUL NULL
programid varchar(64) NULL MUL NULL REFERENCES program(programid)
inetref varchar(40) NULL +1278
findid int(11) 0
recordid int(11) MUL 0 REFERENCES record(recordid)
station varchar(20) PRI
rectype int(10) unsigned 0
duplicate tinyint(1) 0
recstatus int(11) MUL 0
reactivate smallint(6) 0
generic tinyint(1) NULL +1109
future tinyint(1) MUL 0 +1271

Fields

  • chanid relates to the chanid field of the channel table.
  • starttime is when the recoding began.
  • endtime is when the recording ended.
  • title is the name of the series or program.
  • subtitle is the episode name.
  • description is a short description of the episode.
  • category is the genre of the program.
    • Sitcom, Drama, Cooking, etc.
  • seriesid is a unique identifier for the series this recording is part of.
  • programid is a unique identifier for this program. It relates to the programid field of the program table.
  • station is the callsign of the station this program was recorded on.
  • rectype has the same meaning as the type field of the record table.
  • duplicate determines whether a show should be recorded again or not (0 = yes, 1 = no).
  • recstatus recording status. See the RecStatusType enum in libs/libmyth/programtypes.h for a definition of the values.
  • reactivate asks the scheduler to restart this recording if possible (1 = reactivate, 0=default). See RecordingInfo::ReactivateRecording(void) in mythtv/libs/libmythtv/recordinginfo.cpp for where it is set.
  • generic identifies a generic listing (1=generic, 0=default). Introduced in schema [rev 1109]cgitgithub in mythtv/libs/libmythtv/dbcheck.cpp, which shows how it is initialized.
  • future identifies a future entries (1=future, 0=non-future). Introduced in schema 1271 in commit [v0.25pre-1716-g543d783]cgitgithub}.