Extension:WikiLove/wikilove log table

From MediaWiki.org
Jump to navigation Jump to search
mysql> describe wikilove_log;
+---------------------------+------------------+------+-----+---------+----------------+
| Field                     | Type             | Null | Key | Default | Extra          |
+---------------------------+------------------+------+-----+---------+----------------+
| wll_id                    | int(11)          | NO   | PRI | NULL    | auto_increment |
| wll_timestamp             | binary(14)       | NO   | MUL | NULL    |                |
| wll_sender                | int(10) unsigned | NO   | MUL | NULL    |                |
| wll_sender_registration   | binary(14)       | YES  |     | NULL    |                |
| wll_sender_editcount      | int(11)          | YES  |     | NULL    |                |
| wll_receiver              | int(10) unsigned | NO   | MUL | NULL    |                |
| wll_receiver_registration | binary(14)       | YES  |     | NULL    |                |
| wll_receiver_editcount    | int(11)          | YES  |     | NULL    |                |
| wll_type                  | varbinary(64)    | NO   | MUL | NULL    |                |
| wll_subject               | varbinary(255)   | NO   |     | NULL    |                |
| wll_message               | blob             | NO   |     | NULL    |                |
| wll_email                 | tinyint(1)       | NO   |     | 0       |                |
+---------------------------+------------------+------+-----+---------+----------------+