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

-- CRM-5461
 SELECT @option_group_id_act   := MAX(id) from civicrm_option_group where name = 'activity_type';
 SELECT @activity_type_max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_act;
 SELECT @activity_type_max_wt  := MAX(ROUND(val.weight)) FROM civicrm_option_value val where val.option_group_id = @option_group_id_act;

UPDATE  civicrm_option_value val
   SET  val.value  = @activity_type_max_val+1,
        val.weight = @activity_type_max_wt+1
 WHERE  val.option_group_id = @option_group_id_act
   AND  val.name = 'Print PDF Letter';
Commit	Line	Data
6a488035 TO	1	-- CRM-5461
	2	SELECT @option_group_id_act := MAX(id) from civicrm_option_group where name = 'activity_type';
	3	SELECT @activity_type_max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_act;
	4	SELECT @activity_type_max_wt := MAX(ROUND(val.weight)) FROM civicrm_option_value val where val.option_group_id = @option_group_id_act;
	5
	6	UPDATE civicrm_option_value val
10824d34	7	SET val.value = @activity_type_max_val+1,
6a488035	8	val.weight = @activity_type_max_wt+1
10824d34	9	WHERE val.option_group_id = @option_group_id_act
6a488035 TO	10	AND val.name = 'Print PDF Letter';
6a488035 TO	11