Extension:LiquidThreads/thread table

From MediaWiki.org
Jump to navigation Jump to search


mysql> describe thread;
+--------------------------+------------------+------+-----+----------------+----------------+
| Field                    | Type             | Null | Key | Default        | Extra          |
+--------------------------+------------------+------+-----+----------------+----------------+
| thread_id                | int(8) unsigned  | NO   | PRI | NULL           | auto_increment |
| thread_root              | int(8) unsigned  | NO   | UNI | NULL           |                |
| thread_ancestor          | int(8) unsigned  | NO   | MUL | NULL           |                |
| thread_parent            | int(8) unsigned  | YES  | MUL | NULL           |                |
| thread_summary_page      | int(8) unsigned  | YES  | MUL | NULL           |                |
| thread_subject           | varbinary(255)   | YES  |     | NULL           |                |
| thread_author_id         | int(10) unsigned | YES  | MUL | NULL           |                |
| thread_author_name       | varbinary(255)   | YES  |     | NULL           |                |
| thread_modified          | binary(14)       | NO   | MUL |                |                |
| thread_created           | binary(14)       | NO   | MUL |                |                |
| thread_editedness        | int(1)           | NO   |     | 0              |                |
| thread_article_namespace | int(11)          | NO   | MUL | NULL           |                |
| thread_article_title     | varbinary(255)   | NO   |     | NULL           |                |
| thread_article_id        | int(8) unsigned  | NO   | MUL | NULL           |                |
| thread_type              | int(4) unsigned  | NO   |     | 0              |                |
| thread_sortkey           | varbinary(255)   | NO   | MUL |                |                |
| thread_replies           | int(8)           | YES  |     | -1             |                |
| thread_signature         | tinyblob         | YES  |     | NULL           |                |
+--------------------------+------------------+------+-----+----------------+----------------+