Extension:CentralNotice/cn notices table

FieldsEdit

Stores details on all the campaigns known to CentralNotice.

Key Name Type Default Description
primary not_id int NOT NULL AUTO_INCREMENT 0 Identifying key for the campaign.


not_name varchar(255) NOT NULL NULL Friendly name of the campaign; displayed to the users and reported to analytics.


not_start char(14) NOT NULL NULL MediaWiki datetime string representing when this campaign should auto-start if enabled.


not_end char(14) NOT NULL NULL MediaWiki datetime string representing when this campaign should auto-end if enabled.


not_enabled tinyint(1) NOT NULL 0 Boolean value determining if the campaign is set to auto-start/end. 0 = will not auto-start/end.


not_preferred tinyint(1) NOT NULL 0 Priority level of the campaign. Lower numbers have higher priority.


not_throttle int NOT NULL 100


not_locked tinyint(1) NOT NULL 0 Boolean value indicating if editing is allowed on this campaign. 0 = editing allowed.


not_geo tinyint(1) NOT NULL 0 Boolean value indicating if the campaign has geo-target selectors. If it does there will be a row for each country targeted in cn_notice_countries. 0 = campaign not geo-targeted.


not_buckets tinyint(1) NOT NULL 1
Since: v2.1
Integer value indicating how many buckets this campaign supports. Minimum value of 1; maximum value of $wgNoticeNumberOfControllerBuckets.


not_weight int(11) NOT NULL 100
Since: v2.3
Integer value indicating how much weight this campaign carries. Used for slot allocation within a priority level.


not_mobile_carrier tinyint(1) NOT NULL 0
Since: v2.3
Boolean value indicating if the campaign has mobile-carrier selectors. If it does there will be a row for each carrier targeted in cn_notice_mobile_carriers. 0 = campaign not carrier-targeted.


not_archived tinyint(1) NOT NULL 0
Since: v2.3
Boolean value indicating if the campaign should be shown by default on the 'campaigns' page. 0 = show by default.