Videocollection table

From MythTV Official Wiki
Revision as of 22:42, 22 February 2014 by Pmhahn (talk | contribs) (videocollection table)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

The videocollection table contains ...

Table Description

Field name Type Null Key Default Extras Description
intid int(10) unsigned PRI NULL auto_increment
title varchar(256) MUL NULL
contenttype set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO')
plot text NULL NULL
network varchar(128) NULL NULL
collectionref varchar(128) NULL
certification varchar(128) NULL NULL
genre varchar(128) NULL
releasedate date NULL NULL
language varchar(10) NULL NULL
status varchar(64) NULL NULL
rating float NULL 0
ratingcount int(10) NULL 0
runtime smallint(5) unsigned NULL 0
banner text NULL NULL
fanart text NULL NULL
coverart text NULL NULL

Fields

Example Entries