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 edit
Stores details on all the campaigns known to CentralNotice.
notlog_id edit
Primary key. Identifying key for the campaign.
notlog_timestamp edit
Foreign key.
notlog_user_id edit
Foreign key.
notlog_action edit
notlog_not_id edit
Foreign key.
notlog_not_name edit
notlog_begin_projects edit
notlog_end_projects edit
notlog_begin_languages edit
notlog_end_languages edit
notlog_begin_countries edit
notlog_end_countries edit
notlog_begin_start edit
notlog_end_start edit
notlog_begin_end edit
notlog_end_end edit
notlog_begin_enabled edit
notlog_end_enabled edit
notlog_begin_preferred edit
notlog_end_preferred edit
notlog_begin_throttle edit
notlog_end_throttle edit
notlog_begin_locked edit
notlog_end_locked edit
notlog_begin_geo edit
notlog_end_geo edit
notlog_begin_banners edit
notlog_end_banners edit
notlog_begin_buckets edit
notlog_end_buckets edit
notlog_begin_mobile_carrier edit
notlog_end_mobile_carrier edit
notlog_begin_weight edit
notlog_end_weight edit
notlog_begin_archived edit
notlog_end_archived edit
notlog_begin_mixins edit
notlog_end_mixins edit
notlog_comment edit
Schema summary edit
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 | |
+-----------------------------+--------------------------------------+------+-----+----------+----------------+