Extension:CentralNotice/cn notice 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
editStores details on all the campaigns known to CentralNotice.
notlog_id
editPrimary key. Identifying key for the campaign.
notlog_timestamp
editForeign key.
notlog_user_id
editForeign key.
notlog_action
editnotlog_not_id
editForeign key.
notlog_not_name
editnotlog_begin_projects
editnotlog_end_projects
editnotlog_begin_languages
editnotlog_end_languages
editnotlog_begin_countries
editnotlog_end_countries
editnotlog_begin_start
editnotlog_end_start
editnotlog_begin_end
editnotlog_end_end
editnotlog_begin_enabled
editnotlog_end_enabled
editnotlog_begin_preferred
editnotlog_end_preferred
editnotlog_begin_throttle
editnotlog_end_throttle
editnotlog_begin_locked
editnotlog_end_locked
editnotlog_begin_geo
editnotlog_end_geo
editnotlog_begin_banners
editnotlog_end_banners
editnotlog_begin_buckets
editnotlog_end_buckets
editnotlog_begin_mobile_carrier
editnotlog_end_mobile_carrier
editnotlog_begin_weight
editnotlog_end_weight
editnotlog_begin_archived
editnotlog_end_archived
editnotlog_begin_mixins
editnotlog_end_mixins
editnotlog_comment
editSchema summary
editmysql> 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 | |
+-----------------------------+--------------------------------------+------+-----+----------+----------------+