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