Extension:FanBoxes/fantag table

From MediaWiki.org
Jump to navigation Jump to search

DESCRIBE fantag;

+------------------------+---------------------+------+-----+---------+----------------+
| Field                  | Type                | Null | Key | Default | Extra          |
+------------------------+---------------------+------+-----+---------+----------------+
| fantag_id              | int(11)             | NO   | PRI | NULL    | auto_increment |
| fantag_title           | varbinary(100)      | NO   |     | NULL    |                |
| fantag_pg_id           | int(11)             | NO   | MUL | NULL    |                |
| fantag_left_text       | varbinary(20)       | YES  |     | NULL    |                |
| fantag_left_textcolor  | varbinary(20)       | YES  |     | NULL    |                |
| fantag_left_bgcolor    | varbinary(20)       | YES  |     | NULL    |                |
| fantag_right_text      | varbinary(90)       | NO   |     | NULL    |                |
| fantag_right_textcolor | varbinary(20)       | YES  |     | NULL    |                |
| fantag_right_bgcolor   | varbinary(20)       | YES  |     | NULL    |                |
| fantag_actor           | bigint(20) unsigned | NO   | MUL | NULL    |                |
| fantag_date            | datetime            | NO   |     | NULL    |                |
| fantag_count           | int(11)             | NO   |     | 1       |                |
| fantag_image_name      | varbinary(255)      | YES  |     | NULL    |                |
| fantag_left_textsize   | varbinary(20)       | YES  |     | NULL    |                |
| fantag_right_textsize  | varbinary(20)       | YES  |     | NULL    |                |
+------------------------+---------------------+------+-----+---------+----------------+