Extension:LiquidThreads/thread history table

From MediaWiki.org
Jump to navigation Jump to search
mysql> describe thread_history;
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| th_id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| th_thread         | int(10) unsigned | NO   | MUL | NULL    |                |
| th_timestamp      | varbinary(14)    | NO   | MUL | NULL    |                |
| th_user           | int(10) unsigned | NO   | MUL | NULL    |                |
| th_user_text      | varbinary(255)   | NO   |     | NULL    |                |
| th_change_type    | int(10) unsigned | NO   |     | NULL    |                |
| th_change_object  | int(10) unsigned | NO   |     | NULL    |                |
| th_change_comment | tinyblob         | NO   |     | NULL    |                |
| th_content        | longblob         | NO   |     | NULL    |                |
+-------------------+------------------+------+-----+---------+----------------+