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