< Extension:CentralNotice

Fields

Stores details on all the campaigns known to CentralNotice.

tmplog_id

Primary key. Identifying key for the campaign.

tmplog_timestamp

Foreign key.

tmplog_user_id

Foreign key.

tmplog_action

tmplog_template_id

Foreign key.

tmplog_template_name

tmplog_begin_anon

tmplog_end_anon

tmplog_begin_account

tmplog_end_account

tmplog_begin_fundraising

tmplog_end_fundraising

tmplog_begin_landingpages

tmplog_end_landingpages

tmplog_content_change

tmplog_begin_prioritylangs

tmplog_end_prioritylangs

tmplog_begin_archived

tmplog_end_archived

tmplog_begin_category

tmplog_end_category

tmplog_begin_preview_sandbox

tmplog_end_preview_sandbox

tmplog_begin_controller_mixin

tmplog_end_controller_mixin

tmplog_begin_devices

tmplog_end_devices

tmplog_comment

Schema summary

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     |                |
+-------------------------------+--------------------------------------+------+-----+----------+----------------+
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.