Jump to content

Extension:Sanctions/sanctions table

From mediawiki.org

Schema

[edit]
mysql> describe sanctions;
+--------------------------+---------------------+------+-----+---------+----------------+
| Field                    | Type                | Null | Key | Default | Extra          |
+--------------------------+---------------------+------+-----+---------+----------------+
| st_id                    | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| st_author                | bigint(20) unsigned | NO   |     | NULL    |                |
| st_topic                 | binary(11)          | NO   | MUL | NULL    |                |
| st_target                | bigint(20) unsigned | NO   | MUL | NULL    |                |
| st_original_name         | varbinary(255)      | YES  |     |         |                |
| st_expiry                | binary(14)          | NO   |     | NULL    |                |
| st_handled               | tinyint(1)          | NO   |     | 0       |                |
| st_emergency             | tinyint(1)          | NO   |     | 0       |                |
| st_last_update_timestamp | binary(14)          | NO   |     | NULL    |                |
+--------------------------+---------------------+------+-----+---------+----------------+