< Extension:CentralNotice

Fields

Stores details on all the campaigns known to CentralNotice.

notlog_id

Primary key. Identifying key for the campaign.

notlog_timestamp

Foreign key.

notlog_user_id

Foreign key.

notlog_action

notlog_not_id

Foreign key.

notlog_not_name

notlog_begin_projects

notlog_end_projects

notlog_begin_languages

notlog_end_languages

notlog_begin_countries

notlog_end_countries

notlog_begin_start

notlog_end_start

notlog_begin_end

notlog_end_end

notlog_begin_enabled

notlog_end_enabled

notlog_begin_preferred

notlog_end_preferred

notlog_begin_throttle

notlog_end_throttle

notlog_begin_locked

notlog_end_locked

notlog_begin_geo

notlog_end_geo

notlog_begin_banners

notlog_end_banners

notlog_begin_buckets

notlog_end_buckets

notlog_begin_mobile_carrier

notlog_end_mobile_carrier

notlog_begin_weight

notlog_end_weight

notlog_begin_archived

notlog_end_archived

notlog_begin_mixins

notlog_end_mixins

notlog_comment

Schema summary

mysql> describe cn_notice_log;
+-----------------------------+--------------------------------------+------+-----+----------+----------------+
| Field                       | Type                                 | Null | Key | Default  | Extra          |
+-----------------------------+--------------------------------------+------+-----+----------+----------------+
| notlog_id                   | int(10) unsigned                     | NO   | PRI | NULL     | auto_increment |
| notlog_timestamp            | binary(14)                           | NO   | MUL | NULL     |                |
| notlog_user_id              | int(10) unsigned                     | NO   | MUL | NULL     |                |
| notlog_action               | enum('created','modified','removed') | NO   |     | modified |                |
| notlog_not_id               | int(10) unsigned                     | NO   | MUL | NULL     |                |
| notlog_not_name             | varbinary(255)                       | YES  |     | NULL     |                |
| notlog_begin_projects       | varbinary(255)                       | YES  |     | NULL     |                |
| notlog_end_projects         | varbinary(255)                       | YES  |     | NULL     |                |
| notlog_begin_languages      | blob                                 | YES  |     | NULL     |                |
| notlog_end_languages        | blob                                 | YES  |     | NULL     |                |
| notlog_begin_countries      | blob                                 | YES  |     | NULL     |                |
| notlog_end_countries        | blob                                 | YES  |     | NULL     |                |
| notlog_begin_start          | binary(14)                           | YES  |     | NULL     |                |
| notlog_end_start            | binary(14)                           | YES  |     | NULL     |                |
| notlog_begin_end            | binary(14)                           | YES  |     | NULL     |                |
| notlog_end_end              | binary(14)                           | YES  |     | NULL     |                |
| notlog_begin_enabled        | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_end_enabled          | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_begin_preferred      | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_end_preferred        | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_begin_throttle       | int(11)                              | YES  |     | NULL     |                |
| notlog_end_throttle         | int(11)                              | YES  |     | NULL     |                |
| notlog_begin_locked         | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_end_locked           | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_begin_geo            | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_end_geo              | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_begin_banners        | blob                                 | YES  |     | NULL     |                |
| notlog_end_banners          | blob                                 | YES  |     | NULL     |                |
| notlog_begin_buckets        | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_end_buckets          | tinyint(1)                           | YES  |     | NULL     |                |
| notlog_begin_mobile_carrier | int(11)                              | YES  |     | NULL     |                |
| notlog_end_mobile_carrier   | int(11)                              | YES  |     | NULL     |                |
| notlog_begin_weight         | int(11)                              | YES  |     | NULL     |                |
| notlog_end_weight           | int(11)                              | YES  |     | NULL     |                |
| notlog_begin_archived       | tinyint(4)                           | YES  |     | NULL     |                |
| notlog_end_archived         | tinyint(4)                           | YES  |     | NULL     |                |
| notlog_begin_mixins         | blob                                 | YES  |     | NULL     |                |
| notlog_end_mixins           | blob                                 | YES  |     | NULL     |                |
| notlog_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.