Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-4374 |
2 | ||
3 | SELECT @og_id_at := max(id) from civicrm_option_group where name = 'activity_type'; | |
4 | SELECT @max_val_at := max(round(value)) from civicrm_option_value where option_group_id=@og_id_at; | |
5 | SELECT @max_wt_at := max(weight) from civicrm_option_value where option_group_id=@og_id_at; | |
6 | ||
7 | SELECT @og_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol'; | |
8 | SELECT @max_val_mp := max(round(value)) from civicrm_option_value where option_group_id=@og_id_mp; | |
9 | SELECT @max_wt_mp := max(weight) from civicrm_option_value where option_group_id=@og_id_mp; | |
10 | ||
11 | SELECT @civicase_component_id := id from civicrm_component where name = 'CiviCase'; | |
12 | ||
13 | {if $multilingual} | |
14 | INSERT INTO civicrm_option_value | |
15 | (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, filter, weight, is_reserved, is_active, component_id) VALUES | |
16 | (@og_id_at, {foreach from=$locales item=locale}'Change Case Start Date',{/foreach} @max_val_at + 1, 'Change Case Start Date', 0, @max_wt_at + 1, 1, 1, @civicase_component_id), | |
17 | (@og_id_mp, {foreach from=$locales item=locale}'Localdir',{/foreach} @max_val_mp + 1, 'Localdir', 0, @max_wt_mp + 1, 1, 1, NULL); | |
18 | {else} | |
10824d34 | 19 | INSERT INTO `civicrm_option_value` |
20 | (`option_group_id`, `label`, `value`, `name`, `filter`, `weight`, `is_reserved`, `is_active`, component_id) VALUES | |
6a488035 TO |
21 | (@og_id_at, 'Change Case Start Date', @max_val_at + 1, 'Change Case Start Date', 0, @max_wt_at + 1, 1, 1, @civicase_component_id ), |
22 | (@og_id_mp, 'Localdir', @max_val_mp + 1, 'Localdir', 0, @max_wt_mp + 1, 1, 1, NULL); | |
23 | {/if} | |
24 | ||
25 | --CRM-4373 | |
26 | --Adding new custom search for FullText Search. | |
27 | ||
28 | SELECT @og_id_cs := id FROM civicrm_option_group WHERE name = 'custom_search'; | |
29 | SELECT @maxValue := max(CAST( `value` AS UNSIGNED )) FROM civicrm_option_value WHERE option_group_id = @og_id_cs; | |
10824d34 | 30 | |
6a488035 TO |
31 | {if $multilingual} |
32 | INSERT INTO civicrm_option_value | |
33 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active) VALUES | |
34 | (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_FullText', 'Full-text Search', {/foreach} @maxValue + 1, 'CRM_Contact_Form_Search_Custom_FullText', @maxValue + 1, 1); | |
35 | {else} | |
36 | INSERT INTO civicrm_option_value | |
10824d34 | 37 | (option_group_id, label, value, name, description, weight, is_active ) VALUES |
38 | (@og_id_cs, 'CRM_Contact_Form_Search_Custom_FullText', @maxValue + 1, 'CRM_Contact_Form_Search_Custom_FullText', 'Full-text Search', @maxValue + 1, 1); | |
6a488035 | 39 | {/if} |