Merge pull request #19435 from civicrm/5.34

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.15.alpha1.mysql.tpl

{* file to handle db changes in 5.15.alpha1 during upgrade *}
--dev/core#905 Add contribution recur status option group
INSERT INTO `civicrm_option_group`  ( `name`, {localize field='title'}`title`{/localize}, `is_active`, `is_reserved`, `is_locked` ) VALUES ('contribution_recur_status', {localize}'{ts escape="sql"}Recurring Contribution Status{/ts}'{/localize}, 1, 1, 1);

SELECT @option_group_id_ps := MAX(id) FROM `civicrm_option_group` where name = 'contribution_recur_status';

INSERT INTO `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `weight`, `is_reserved`, `is_active`, `is_default`)
SELECT @option_group_id_ps as option_group_id, {localize field='label'}`label`{/localize}, value, ov.name, weight, ov.is_reserved, ov.is_active, is_default
FROM civicrm_option_value ov
INNER JOIN civicrm_option_group og
ON og.id = ov.option_group_id AND og.name = 'contribution_status';

SELECT @maxValue := MAX(CAST(value AS UNSIGNED))  FROM `civicrm_option_value` where option_group_id = @option_group_id_ps;
SELECT @maxWeight := MAX(weight) FROM `civicrm_option_value` where option_group_id = @option_group_id_ps;

INSERT INTO `civicrm_option_value` (
`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `weight`, `is_reserved`, `is_active`, `is_default`
)
VALUES(
 @option_group_id_ps, {localize field='label'}'Processing'{/localize}, @maxValue + 1, 'Processing', @maxWeight + 1, 1 , 1 , 0
),
(
@option_group_id_ps, {localize field='label'}'Failing'{/localize}, @maxValue + 2, 'Failing', @maxWeight + 2, 1 , 1 , 0
)
ON DUPLICATE KEY UPDATE id=id;