From a35072015a8a231db32e52dc8529c3b1b7041e7b Mon Sep 17 00:00:00 2001 From: Jon goldberg Date: Tue, 28 Apr 2015 14:10:37 -0600 Subject: [PATCH] Merge status-page project upgrade SQL with CRM-16354 upgrade SQL --- .../Incremental/sql/4.7.alpha1.mysql.tpl | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 2b3ed8f6c4..bb05c6a734 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -24,3 +24,21 @@ UPDATE civicrm_option_value SET {localize field="label"}label = 'Activity Summar {include file='../CRM/Upgrade/4.7.alpha1.msg_template/civicrm_msg_template.tpl'} +-- CRM-13283 +CREATE TABLE IF NOT EXISTS `civicrm_status_pref` ( + `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Status Preference ID', + `domain_id` int unsigned NOT NULL COMMENT 'Which Domain is this Status Preference for', + `name` varchar(255) NOT NULL COMMENT 'Name of the status check this preference references.', + `hush_until` date DEFAULT NULL COMMENT 'expires ignore_severity. NULL never hushes.', + `ignore_severity` int unsigned DEFAULT 1 COMMENT 'Hush messages up to and including this severity.', + `prefs` varchar(255) COMMENT 'These settings are per-check, and can\'t be compared across checks.', + `check_info` varchar(255) COMMENT 'These values are per-check, and can\'t be compared across checks.' +, + PRIMARY KEY ( `id` ) + + , INDEX `UI_status_pref_name`( + name + ) + +, CONSTRAINT FK_civicrm_status_pref_domain_id FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain`(`id`) +) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; -- 2.25.1