Difference between revisions of "Videometadata table"
From MythTV Official Wiki
m |
(FK,Schema update) |
||
Line 7: | Line 7: | ||
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
|- style="background: lightsteelblue" | |- style="background: lightsteelblue" | ||
− | ! Field name !! Type !! Null !! Key !! Default !! Extras | + | ! Field name !! Type !! Null !! Key !! Default !! Extras !! Schema-Version |
|- | |- | ||
− | || intid || int(10) unsigned || | + | || intid || int(10) unsigned || || PRI || NULL || auto_increment |
|- | |- | ||
− | || title || varchar(128) || | + | || title || varchar(128) || || MUL || NULL || |
|- | |- | ||
− | || subtitle || text || | + | || subtitle || text || || || NULL || |
|- | |- | ||
− | || tagline || varchar(255) || | + | || tagline || varchar(255) || NULL || || NULL || |
|- | |- | ||
− | || director || varchar(128) || | + | || director || varchar(128) || || MUL || NULL || |
|- | |- | ||
− | || studio || varchar(128) || | + | || studio || varchar(128) || NULL || || NULL || |
|- | |- | ||
− | || plot || text || | + | || plot || text || NULL || || NULL || |
|- | |- | ||
− | || rating || varchar(128) || | + | || rating || varchar(128) || || || NULL || |
|- | |- | ||
− | || inetref || varchar(255) || | + | || inetref || varchar(255) || || || NULL || |
|- | |- | ||
− | || | + | || collectionref || int(10) || || || -1 || REFERENCES [[videocollection table|videocollection]](intid) || +1295 |
|- | |- | ||
− | || | + | || homepage || text || || || NULL || |
|- | |- | ||
− | || | + | || year || int(10) unsigned || || || NULL || |
|- | |- | ||
− | || | + | || releasedate || date || || || NULL || |
|- | |- | ||
− | || | + | || userrating || float || || || NULL || |
|- | |- | ||
− | || | + | || length || int(10) unsigned || || || NULL || |
|- | |- | ||
− | || | + | || playcount || int(10) || || || 0 || || +1295 |
|- | |- | ||
− | || | + | || season || smallint(5) unsigned || || || 0 || |
|- | |- | ||
− | || | + | || episode || smallint(5) unsigned || || || 0 || |
|- | |- | ||
− | || | + | || showlevel || int(10) unsigned || || || NULL || |
|- | |- | ||
− | || | + | || filename || text || || || NULL || |
|- | |- | ||
− | || | + | || hash || varchar(128) || || || NULL || |
|- | |- | ||
− | || | + | || coverfile || text || || || NULL || |
|- | |- | ||
− | || | + | || childid || int(11) || || || -1 || |
|- | |- | ||
− | || | + | || browse || tinyint(1) || || || 1 || |
|- | |- | ||
− | || | + | || watched || tinyint(1) || || || 0 || |
|- | |- | ||
− | || | + | || processed || tinyint(1) || || || 0 || |
|- | |- | ||
− | || | + | || playcommand || varchar(255) || NULL || || NULL || |
|- | |- | ||
− | || | + | || category || int(10) unsigned || || || 0 || REFERENCES [[videocategory table|videocategory]](intid) |
|- | |- | ||
− | || | + | || trailer || text || NULL || || NULL || |
|- | |- | ||
− | || | + | || host || text || || || NULL || |
|- | |- | ||
− | || | + | || screenshot || text || NULL || || NULL || |
|- | |- | ||
− | || insertdate || timestamp || | + | || banner || text || NULL || || NULL || |
+ | |- | ||
+ | || fanart || text || NULL || || NULL || | ||
+ | |- | ||
+ | || insertdate || timestamp || NULL || || CURRENT_TIMESTAMP || | ||
+ | |- | ||
+ | || contenttype || set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO') || || || || || +1295 | ||
|- | |- | ||
|} | |} | ||
[[Category:MythVideo DB Table]] | [[Category:MythVideo DB Table]] |
Latest revision as of 23:03, 22 February 2014
Note: The correct title of this article is videometadata table. It appears incorrectly here due to technical restrictions.
The videometadata table contains meta data information about the videos managed by MythVideo.
Table is current as of schema version 1037.
Table Description
Field name | Type | Null | Key | Default | Extras | Schema-Version |
---|---|---|---|---|---|---|
intid | int(10) unsigned | PRI | NULL | auto_increment | ||
title | varchar(128) | MUL | NULL | |||
subtitle | text | NULL | ||||
tagline | varchar(255) | NULL | NULL | |||
director | varchar(128) | MUL | NULL | |||
studio | varchar(128) | NULL | NULL | |||
plot | text | NULL | NULL | |||
rating | varchar(128) | NULL | ||||
inetref | varchar(255) | NULL | ||||
collectionref | int(10) | -1 | REFERENCES videocollection(intid) | +1295 | ||
homepage | text | NULL | ||||
year | int(10) unsigned | NULL | ||||
releasedate | date | NULL | ||||
userrating | float | NULL | ||||
length | int(10) unsigned | NULL | ||||
playcount | int(10) | 0 | +1295 | |||
season | smallint(5) unsigned | 0 | ||||
episode | smallint(5) unsigned | 0 | ||||
showlevel | int(10) unsigned | NULL | ||||
filename | text | NULL | ||||
hash | varchar(128) | NULL | ||||
coverfile | text | NULL | ||||
childid | int(11) | -1 | ||||
browse | tinyint(1) | 1 | ||||
watched | tinyint(1) | 0 | ||||
processed | tinyint(1) | 0 | ||||
playcommand | varchar(255) | NULL | NULL | |||
category | int(10) unsigned | 0 | REFERENCES videocategory(intid) | |||
trailer | text | NULL | NULL | |||
host | text | NULL | ||||
screenshot | text | NULL | NULL | |||
banner | text | NULL | NULL | |||
fanart | text | NULL | NULL | |||
insertdate | timestamp | NULL | CURRENT_TIMESTAMP | |||
contenttype | set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO') | +1295 |