Jump to content

Extension:DiscussionTools/discussiontools subscription table

From mediawiki.org

DESCRIBE discussiontools_subscription;

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| sub_id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| sub_item      | varbinary(255)   | NO   | MUL | NULL    |                |
| sub_namespace | int(11)          | NO   |     | 0       |                |
| sub_title     | varbinary(255)   | NO   |     | NULL    |                |
| sub_section   | varbinary(255)   | NO   |     | NULL    |                |
| sub_state     | int(11)          | NO   |     | 1       |                |
| sub_user      | int(10) unsigned | NO   | MUL | NULL    |                |
| sub_created   | binary(14)       | NO   |     | NULL    |                |
| sub_notified  | binary(14)       | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+