Difference between revisions of "Videogenre table"

From MythTV Official Wiki
Jump to: navigation, search
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
+
! 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

Important.png 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.