Jump to content

Extension:DiscussionTools/discussiontools item revisions table

From mediawiki.org
mysql> describe discussiontools_item_revisions;
+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| itr_id              | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| itr_itemid_id       | int(11)             | NO   | MUL | NULL    |                |
| itr_revision_id     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| itr_items_id        | int(11)             | NO   |     | NULL    |                |
| itr_parent_id       | int(11)             | YES  |     | NULL    |                |
| itr_transcludedfrom | bigint(20) unsigned | YES  |     | NULL    |                |
| itr_level           | tinyint(4)          | NO   |     | NULL    |                |
| itr_headinglevel    | tinyint(4)          | YES  |     | NULL    |                |
+---------------------+---------------------+------+-----+---------+----------------+