Gamemetadata table
From MythTV Official Wiki
Revision as of 02:33, 26 September 2010 by Wagnerrp (talk | contribs) (Created page with '{{Wrongtitle|gamemetadata table}} The '''gamemetadata table''' is used by MythGame to store information about games. Table is current as of schema revision 1017. == Table D…')
Note: The correct title of this article is gamemetadata table. It appears incorrectly here due to technical restrictions.
The gamemetadata table is used by MythGame to store information about games.
Table is current as of schema revision 1017.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
system | varchar(128) | No | MUL | ||
romname | varchar(128) | No | MUL | ||
gamename | varchar(128) | No | MUL | ||
genre | varchar(128) | No | MUL | ||
year | varchar(10) | No | MUL | ||
publisher | varchar(128) | No | |||
favorite | tinyint(1) | Yes | NULL | ||
rompath | varchar(255) | No | |||
fanart | varchar(255) | No | |||
boxart | varchar(255) | No | |||
gametype | varchar(64) | No | |||
diskcount | tinyint(1) | No | 1 | ||
country | varchar(128) | No | |||
crc_value | varchar(64) | No | |||
inetref | text | No | |||
display | tinyint(1) | No | 1 | ||
version | varchar(64) | No |