Difference between revisions of "Oldrecorded table"
From MythTV Official Wiki
(→Fields) |
|||
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. | ||
== Table Description == | == Table Description == | ||
Line 41: | Line 43: | ||
|| generic || tinyint(1) || YES || || 0 || | || generic || tinyint(1) || YES || || 0 || | ||
|- | |- | ||
− | |} | + | || future || tinyint(1) || No || MUL || 0 || |
+ | |-|} | ||
== Fields == | == Fields == | ||
Line 60: | Line 63: | ||
*'''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 [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. | ||
*'''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 [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. | ||
− | + | *'''future''' identifies a future entries (1=future, 0=non-future). Introduced in schema 1271 in commit {543d7836}. | |
− | { | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Revision as of 16:10, 19 April 2012
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.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
chanid | int(10) unsigned | 0 | |||
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) | ||||
description | text | ||||
category | varchar(64) | ||||
seriesid | varchar(12) | MUL | |||
programid | varchar(20) | MUL | |||
findid | int(11) | 0 | |||
recordid | int(11) | MUL | 0 | ||
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) | YES | 0 | ||
future | tinyint(1) | No | MUL | 0 |