Commit | Line | Data |
---|---|---|
0b621ada | 1 | {* file to handle db changes in 4.6.alpha4 during upgrade *} |
8bbae400 N |
2 | --CRM-15821 PCP Owner Notification |
3 | ||
4 | {include file='../CRM/Upgrade/4.6.alpha4.msg_template/civicrm_msg_template.tpl'} | |
5 | ||
6 | -- Add new column owner_notify_id in pcp block table | |
7 | ALTER TABLE `civicrm_pcp_block` ADD `owner_notify_id` INT NULL DEFAULT NULL COMMENT 'FK to option_value where option_group = pcp_owner_notification'; | |
8 | ||
9 | -- Add new column is_notify in pcp table | |
10 | ALTER TABLE `civicrm_pcp` ADD `is_notify` INT NOT NULL DEFAULT '0'; | |
11 | ||
12 | --Add PCP owner notification option group | |
0f78be59 | 13 | INSERT INTO `civicrm_option_group` ( `name`, {localize field='title'}`title`{/localize}, `is_active` ) VALUES ('pcp_owner_notify', {localize}'{ts escape="sql"}PCP owner notifications{/ts}'{/localize}, 1); |
8bbae400 N |
14 | |
15 | SELECT @ogid_pcp_owner := MAX(id) FROM `civicrm_option_group`; | |
16 | ||
0f78be59 | 17 | INSERT INTO `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `is_default`, `weight`) VALUES (@ogid_pcp_owner, {localize}'{ts escape="sql"}Owner chooses whether to receive notifications{/ts}'{/localize}, '1', 'owner_chooses', 1, 1), (@ogid_pcp_owner, {localize}'{ts escape="sql"}Notifications are sent to ALL owners{/ts}'{/localize}, '2', 'all_owners', 0, 2),(@ogid_pcp_owner, {localize}'{ts escape="sql"}Notifications are NOT available{/ts}'{/localize}, '3', 'no_notifications', 0, 3); |
8bbae400 N |
18 | |
19 | UPDATE `civicrm_pcp_block` SET `owner_notify_id` = 3; | |
20 | UPDATE `civicrm_pcp` SET `is_notify` = 0; | |
21 |