Extension:LiquidThreads/thread table
Appearance
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 | | +--------------------------+------------------+------+-----+----------------+----------------+