Extension:CentralNotice/cn notices table

Fields

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.