Extension:Moderation/moderation block table

From MediaWiki.org
Jump to navigation Jump to search

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

MariaDB [wiki]> describe moderation_block;
+--------------+------------------+------+-----+----------------+----------------+
| Field        | Type             | Null | Key | Default        | Extra          |
+--------------+------------------+------+-----+----------------+----------------+
| mb_id        | int(10) unsigned | NO   | PRI | NULL           | auto_increment |
| mb_address   | tinyblob         | NO   | UNI | NULL           |                |
| mb_user      | int(10) unsigned | NO   |     | 0              |                |
| mb_by        | int(10) unsigned | NO   |     | 0              |                |
| mb_by_text   | varbinary(255)   | NO   |     |                |                |
| mb_timestamp | binary(14)       | NO   |     |                |                |
+--------------+------------------+------+-----+----------------+----------------+