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