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

-- CRM-12142
-- Populate default text for premiums_nothankyou_label
UPDATE `civicrm_premiums` SET {localize field="premiums_nothankyou_label"}premiums_nothankyou_label = '{ts escape="sql"}No thank-you{/ts}'{/localize};

-- CRM-12233 Fix price field label for quick config membership signup field
UPDATE `civicrm_price_field` cpf
LEFT JOIN `civicrm_price_set` cps ON cps.id = cpf.price_set_id
SET {localize field="label"}cpf.label = '{ts escape="sql"}Membership{/ts}'{/localize}
WHERE cps.is_quick_config = 1 AND cpf.name = 'membership_amount';
Commit	Line	Data
35fe5ae1 DG	1	-- CRM-12142
35fe5ae1 DG	2	-- Populate default text for premiums_nothankyou_label
e81d0c88 DG	3	UPDATE `civicrm_premiums` SET {localize field="premiums_nothankyou_label"}premiums_nothankyou_label = '{ts escape="sql"}No thank-you{/ts}'{/localize};
	4
	5	-- CRM-12233 Fix price field label for quick config membership signup field
	6	UPDATE `civicrm_price_field` cpf
	7	LEFT JOIN `civicrm_price_set` cps ON cps.id = cpf.price_set_id
	8	SET {localize field="label"}cpf.label = '{ts escape="sql"}Membership{/ts}'{/localize}
	9	WHERE cps.is_quick_config = 1 AND cpf.name = 'membership_amount';