Extension:CentralNotice/cn notice log table

FieldsEdit

Stores details on all the campaigns known to CentralNotice.

notlog_idEdit

Primary key. Identifying key for the campaign.

notlog_timestampEdit

Foreign key.

notlog_user_idEdit

Foreign key.

notlog_actionEdit

notlog_not_idEdit

Foreign key.

notlog_not_nameEdit

notlog_begin_projectsEdit

notlog_end_projectsEdit

notlog_begin_languagesEdit

notlog_end_languagesEdit

notlog_begin_countriesEdit

notlog_end_countriesEdit

notlog_begin_startEdit

notlog_end_startEdit

notlog_begin_endEdit

notlog_end_endEdit

notlog_begin_enabledEdit

notlog_end_enabledEdit

notlog_begin_preferredEdit

notlog_end_preferredEdit

notlog_begin_throttleEdit

notlog_end_throttleEdit

notlog_begin_lockedEdit

notlog_end_lockedEdit

notlog_begin_geoEdit

notlog_end_geoEdit

notlog_begin_bannersEdit

notlog_end_bannersEdit

notlog_begin_bucketsEdit

notlog_end_bucketsEdit

notlog_begin_mobile_carrierEdit

notlog_end_mobile_carrierEdit

notlog_begin_weightEdit

notlog_end_weightEdit

notlog_begin_archivedEdit

notlog_end_archivedEdit

notlog_begin_mixinsEdit

notlog_end_mixinsEdit

notlog_commentEdit

Schema summaryEdit

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