Extension:CentralNotice/cn template log table

From MediaWiki.org
Jump to navigation Jump to search

Fields[edit]

Stores details on all the campaigns known to CentralNotice.

tmplog_id[edit]

Primary key. Identifying key for the campaign.

tmplog_timestamp[edit]

Foreign key.

tmplog_user_id[edit]

Foreign key.

tmplog_action[edit]

tmplog_template_id[edit]

Foreign key.

tmplog_template_name[edit]

tmplog_begin_anon[edit]

tmplog_end_anon[edit]

tmplog_begin_account[edit]

tmplog_end_account[edit]

tmplog_begin_fundraising[edit]

tmplog_end_fundraising[edit]

tmplog_begin_autolink[edit]

tmplog_end_autolink[edit]

tmplog_begin_landingpages[edit]

tmplog_end_landingpages[edit]

tmplog_content_change[edit]

tmplog_begin_prioritylangs[edit]

tmplog_end_prioritylangs[edit]

tmplog_begin_archived[edit]

tmplog_end_archived[edit]

tmplog_begin_category[edit]

tmplog_end_category[edit]

tmplog_begin_preview_sandbox[edit]

tmplog_end_preview_sandbox[edit]

tmplog_begin_controller_mixin[edit]

tmplog_end_controller_mixin[edit]

tmplog_begin_devices[edit]

tmplog_end_devices[edit]

tmplog_comment[edit]

Schema summary[edit]

mysql> describe cn_template_log;
+-------------------------------+--------------------------------------+------+-----+----------+----------------+
| Field                         | Type                                 | Null | Key | Default  | Extra          |
+-------------------------------+--------------------------------------+------+-----+----------+----------------+
| tmplog_id                     | int(10) unsigned                     | NO   | PRI | NULL     | auto_increment |
| tmplog_timestamp              | binary(14)                           | NO   | MUL | NULL     |                |
| tmplog_user_id                | int(10) unsigned                     | NO   | MUL | NULL     |                |
| tmplog_action                 | enum('created','modified','removed') | NO   |     | modified |                |
| tmplog_template_id            | int(10) unsigned                     | NO   | MUL | NULL     |                |
| tmplog_template_name          | varbinary(255)                       | YES  |     | NULL     |                |
| tmplog_begin_anon             | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_anon               | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_account          | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_account            | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_fundraising      | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_fundraising        | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_autolink         | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_autolink           | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_landingpages     | varbinary(255)                       | YES  |     | NULL     |                |
| tmplog_end_landingpages       | varbinary(255)                       | YES  |     | NULL     |                |
| tmplog_content_change         | tinyint(1)                           | YES  |     | 0        |                |
| tmplog_begin_prioritylangs    | blob                                 | YES  |     | NULL     |                |
| tmplog_end_prioritylangs      | blob                                 | YES  |     | NULL     |                |
| tmplog_begin_archived         | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_archived           | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_category         | varbinary(255)                       | YES  |     | NULL     |                |
| tmplog_end_category           | varbinary(255)                       | YES  |     | NULL     |                |
| tmplog_begin_preview_sandbox  | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_end_preview_sandbox    | tinyint(1)                           | YES  |     | NULL     |                |
| tmplog_begin_controller_mixin | varbinary(4096)                      | YES  |     | NULL     |                |
| tmplog_end_controller_mixin   | varbinary(4096)                      | YES  |     | NULL     |                |
| tmplog_begin_devices          | varbinary(512)                       | YES  |     | NULL     |                |
| tmplog_end_devices            | varbinary(512)                       | YES  |     | NULL     |                |
| tmplog_comment                | varbinary(255)                       | YES  |     | NULL     |                |
+-------------------------------+--------------------------------------+------+-----+----------+----------------+