Difference between revisions of "Videogenre table"
From MythTV Official Wiki
m |
m |
||
Line 1: | Line 1: | ||
{{Wrongtitle|videogenre table}} | {{Wrongtitle|videogenre table}} | ||
The '''videogenre table''' contains the genres used by [[MythVideo]]. | The '''videogenre table''' contains the genres used by [[MythVideo]]. | ||
+ | |||
+ | Table is current as of schema version 1037. | ||
+ | |||
== Table Description == | == Table Description == | ||
{| 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 |
|- | |- | ||
− | |intid || int(10) unsigned || || PRI || NULL || auto_increment | + | | intid || int(10) unsigned || NO || PRI || NULL || auto_increment |
|- | |- | ||
− | |genre || varchar(128) || || || || | + | | genre || varchar(128) || NO || || || |
|- | |- | ||
|} | |} | ||
Line 16: | Line 19: | ||
*'''genre''' is the name of the genre. | *'''genre''' is the name of the genre. | ||
− | [[Category:DB Table]] | + | [[Category:MythVideo DB Table]] |
Latest revision as of 03:48, 26 September 2010
Note: The correct title of this article is videogenre table. It appears incorrectly here due to technical restrictions.
The videogenre table contains the genres used by MythVideo.
Table is current as of schema version 1037.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
intid | int(10) unsigned | NO | PRI | NULL | auto_increment |
genre | varchar(128) | NO |
Fields
- initid is a unique identifier for entires in this table. The idgenre field of the videometadatagenre table relates to this field.
- genre is the name of the genre.