Extension:Moderation/moderation table

From MediaWiki.org
Jump to navigation Jump to search

See also: https://github.com/edwardspec/mediawiki-moderation/blob/master/sql/patch-moderation.sql

MariaDB [wiki]> describe moderation;
+---------------------------+---------------------+------+-----+---------+----------------+
| Field                     | Type                | Null | Key | Default | Extra          |
+---------------------------+---------------------+------+-----+---------+----------------+
| mod_id                    | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| mod_timestamp             | varbinary(14)       | NO   |     |         |                |
| mod_user                  | int(10) unsigned    | NO   |     | 0       |                |
| mod_user_text             | varbinary(255)      | NO   | MUL | NULL    |                |
| mod_cur_id                | int(10) unsigned    | NO   |     | NULL    |                |
| mod_namespace             | int(11)             | NO   |     | 0       |                |
| mod_title                 | varbinary(255)      | NO   |     |         |                |
| mod_comment               | varbinary(255)      | NO   |     |         |                |
| mod_minor                 | tinyint(3) unsigned | NO   |     | 0       |                |
| mod_bot                   | tinyint(3) unsigned | NO   |     | 0       |                |
| mod_new                   | tinyint(3) unsigned | NO   |     | 0       |                |
| mod_last_oldid            | int(10) unsigned    | NO   |     | 0       |                |
| mod_ip                    | varbinary(40)       | NO   |     |         |                |
| mod_old_len               | int(11)             | YES  |     | NULL    |                |
| mod_new_len               | int(11)             | YES  |     | NULL    |                |
| mod_header_xff            | varbinary(255)      | YES  |     |         |                |
| mod_header_ua             | varbinary(255)      | YES  |     |         |                |
| mod_tags                  | blob                | YES  |     | NULL    |                |
| mod_preload_id            | varbinary(256)      | NO   | MUL | NULL    |                |
| mod_rejected              | tinyint(4)          | NO   | MUL | 0       |                |
| mod_rejected_by_user      | int(10) unsigned    | NO   |     | 0       |                |
| mod_rejected_by_user_text | varbinary(255)      | YES  |     | NULL    |                |
| mod_rejected_batch        | tinyint(4)          | NO   |     | 0       |                |
| mod_rejected_auto         | tinyint(4)          | NO   | MUL | 0       |                |
| mod_preloadable           | int(10) unsigned    | NO   | MUL | 0       |                |
| mod_conflict              | tinyint(4)          | NO   |     | 0       |                |
| mod_merged_revid          | int(10) unsigned    | NO   | MUL | 0       |                |
| mod_text                  | mediumblob          | YES  |     | NULL    |                |
| mod_stash_key             | varbinary(255)      | YES  |     | NULL    |                |
| mod_type                  | varbinary(16)       | NO   |     | edit    |                |
| mod_page2_namespace       | int(11)             | NO   |     | 0       |                |
| mod_page2_title           | varbinary(255)      | NO   |     |         |                |
+---------------------------+---------------------+------+-----+---------+----------------+