CRM/Upgrade/Incremental/sql/5.15.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.15.alpha1 during upgrade *}
   2 --dev/core#905 Add contribution recur status option group
   3 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);
   4
   5 SELECT @option_group_id_ps := MAX(id) FROM `civicrm_option_group` where name = 'contribution_recur_status';
   6
   7 INSERT INTO `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `weight`, `is_reserved`, `is_active`, `is_default`)
   8 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
   9 FROM civicrm_option_value ov
  10 INNER JOIN civicrm_option_group og
  11 ON og.id = ov.option_group_id AND og.name = 'contribution_status';
  12
  13 SELECT @maxValue := MAX(CAST(value AS UNSIGNED))  FROM `civicrm_option_value` where option_group_id = @option_group_id_ps;
  14 SELECT @maxWeight := MAX(weight) FROM `civicrm_option_value` where option_group_id = @option_group_id_ps;
  15
  16 INSERT INTO `civicrm_option_value` (
  17 `option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `weight`, `is_reserved`, `is_active`, `is_default`
  18 )
  19 VALUES(
  20  @option_group_id_ps, {localize field='label'}'Processing'{/localize}, @maxValue + 1, 'Processing', @maxWeight + 1, 1 , 1 , 0
  21 ),
  22 (
  23 @option_group_id_ps, {localize field='label'}'Failing'{/localize}, @maxValue + 2, 'Failing', @maxWeight + 2, 1 , 1 , 0
  24 )
  25 ON DUPLICATE KEY UPDATE id=id;