mysql> describe gamemetadata;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| system    | varchar(128) |      | MUL |         |       |
| romname   | varchar(128) |      | MUL |         |       |
| gamename  | varchar(128) |      | MUL |         |       |
| genre     | varchar(128) |      | MUL |         |       |
| year      | varchar(10)  |      | MUL |         |       |
| favorite  | tinyint(1)   | YES  |     | NULL    |       |
| rompath   | varchar(255) |      |     |         |       |
| gametype  | varchar(64)  |      |     |         |       |
| diskcount | tinyint(1)   |      |     | 1       |       |
| country   | varchar(128) |      |     |         |       |
| crc_value | varchar(64)  |      |     |         |       |
| display   | tinyint(1)   |      |     | 1       |       |
| version   | varchar(64)  |      |     |         |       |
| publisher | varchar(128) |      |     |         |       |
+-----------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)

mysql>