Extension:Moderation/moderation table
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 | | | | +---------------------------+---------------------+------+-----+---------+----------------+