Extension:CentralNotice/cn template log table
| The subject of this page is not very well documented yet. If you need help, feel free to ask at the support desk.
If you know more about this subject, don't hesitate to help expanding our documentation by editing this page or (other pages that need documentation). |
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 | |
+-------------------------------+--------------------------------------+------+-----+----------+----------------+