Oldrecorded table

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.

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 ProgramInfo::ReactivateRecording(void) in mythtv/libs/libmythtv/programinfo.cpp for where it is set.
• generic identifies a generic listing (1=generic, 0=default). Introduced in schema rev 1109 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]}.

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