Archiveitems table

From MythTV Official Wiki
Jump to: navigation, search

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

The archiveitems table contains video content being prepared by MythArchive for burning to optical media.

Table is current as of schema revision 1005.

Table Description

Field name Type Null Key Default Extras
intid int unsigned No PRI NULL auto_increment
type set Yes ('Recording', 'Video', 'File')
title varchar(128) Yes NULL
subtitle varchar(128) Yes NULL
description text Yes
startdate varbinary(30) Yes NULL
starttime varbinary(30) Yes NULL
size int unsigned No
filename text No
hascutlist bool No
cutlist text Yes
duration int unsigned No 0
cutduration int unsigned No 0
videowidth int unsigned No 0
videoheight int unsigned No 0
filecodec varchar(50) No
videocodec varchar(50) No
encoderprofile varchar(50) No NONE