Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-7817 |
2 | {include file='../CRM/Upgrade/3.4.beta2.msg_template/civicrm_msg_template.tpl'} | |
3 | ||
4 | ||
5 | -- CRM-7801 | |
6 | SELECT @domain_id := min(id) FROM civicrm_domain; | |
7 | SELECT @nav_case := id FROM civicrm_navigation WHERE name = 'CiviCase'; | |
8 | SELECT @nav_case_weight := MAX(ROUND(weight)) from civicrm_navigation WHERE parent_id = @nav_case; | |
9 | ||
10 | INSERT INTO civicrm_navigation | |
11 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
12 | VALUES | |
10824d34 | 13 | ( @domain_id, 'civicrm/admin/options/encounter_medium&group=encounter_medium&reset=1', '{ts escape="sql"}Encounter Medium{/ts}','Encounter Medium', 'administer CiviCase', NULL, @nav_case, '1', NULL, @nav_case_weight+1 ); |
6a488035 | 14 |