Videocollection table

From MythTV Official Wiki
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