Extension:CentralNotice/cn template log table

FieldsEdit

Stores details on all the campaigns known to CentralNotice.

tmplog_idEdit

Primary key. Identifying key for the campaign.

tmplog_timestampEdit

Foreign key.

tmplog_user_idEdit

Foreign key.

tmplog_actionEdit

tmplog_template_idEdit

Foreign key.

tmplog_template_nameEdit

tmplog_begin_anonEdit

tmplog_end_anonEdit

tmplog_begin_accountEdit

tmplog_end_accountEdit

tmplog_begin_fundraisingEdit

tmplog_end_fundraisingEdit

tmplog_begin_autolinkEdit

tmplog_end_autolinkEdit

tmplog_begin_landingpagesEdit

tmplog_end_landingpagesEdit

tmplog_content_changeEdit

tmplog_begin_prioritylangsEdit

tmplog_end_prioritylangsEdit

tmplog_begin_archivedEdit

tmplog_end_archivedEdit

tmplog_begin_categoryEdit

tmplog_end_categoryEdit

tmplog_begin_preview_sandboxEdit

tmplog_end_preview_sandboxEdit

tmplog_begin_controller_mixinEdit

tmplog_end_controller_mixinEdit

tmplog_begin_devicesEdit

tmplog_end_devicesEdit

tmplog_commentEdit

Schema summaryEdit

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     |                |
+-------------------------------+--------------------------------------+------+-----+----------+----------------+