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 ); |