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

{include file='../CRM/Upgrade/3.1.beta4.msg_template/civicrm_msg_template.tpl'}

-- Set default participant role filter = 1, CRM-4924
   UPDATE   civicrm_option_value val
LEFT JOIN   civicrm_option_group gr ON ( gr.id = val.option_group_id )
      SET   val.filter = 1
    WHERE   gr.name = 'participant_role'
      AND   val.name IN ( 'Attendee', 'Host', 'Speaker', 'Volunteer' );

SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template';
INSERT INTO civicrm_option_value
    (option_group_id, {localize field='label'}`label`{/localize}, {localize field='description'}description{/localize}, value, name, weight, is_active, component_id )
VALUES
    (@option_group_id_report , {localize}'{ts escape="sql"}Activity Report (Summary){/ts}'{/localize}, {localize}'{ts escape="sql"}Shows activity statistics by type / date{/ts}'{/localize}, 'activitySummary', 'CRM_Report_Form_ActivitySummary', 28, 1, NULL );
Commit	Line	Data
6a488035 TO	1	{include file='../CRM/Upgrade/3.1.beta4.msg_template/civicrm_msg_template.tpl'}
	2
	3	-- Set default participant role filter = 1, CRM-4924
	4	UPDATE civicrm_option_value val
10824d34	5	LEFT JOIN civicrm_option_group gr ON ( gr.id = val.option_group_id )
6a488035 TO	6	SET val.filter = 1
	7	WHERE gr.name = 'participant_role'
	8	AND val.name IN ( 'Attendee', 'Host', 'Speaker', 'Volunteer' );
	9
	10	SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template';
	11	INSERT INTO civicrm_option_value
	12	(option_group_id, {localize field='label'}`label`{/localize}, {localize field='description'}description{/localize}, value, name, weight, is_active, component_id )
	13	VALUES
	14	(@option_group_id_report , {localize}'{ts escape="sql"}Activity Report (Summary){/ts}'{/localize}, {localize}'{ts escape="sql"}Shows activity statistics by type / date{/ts}'{/localize}, 'activitySummary', 'CRM_Report_Form_ActivitySummary', 28, 1, NULL );