Difference between revisions of "Oldrecorded table"
From MythTV Official Wiki
(→Fields) |
(Add info on recstatus field.) |
||
Line 56: | Line 56: | ||
*'''station''' is the callsign of the station this program was recorded on. | *'''station''' is the callsign of the station this program was recorded on. | ||
*'''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/libmythtv/programinfo.h libs/libmythtv/programinfo.h] for a definition of the values. | |
+ | *'''reactivate''' | ||
+ | *'''generic''' | ||
{{stub}} | {{stub}} | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Revision as of 03:10, 15 May 2008
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 to delete shows from this table in order to make the scheduler forget that they were ever recorded.
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 |
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.
- duplicate determines whether a show should be recorded again or not (0 = yes, 1 = no).
- recstatus recording status. See the RecStatusType enum in libs/libmythtv/programinfo.h for a definition of the values.
- reactivate
- generic