Commit | Line | Data |
---|---|---|
e4c1b25e C |
1 | {* file to handle db changes in 4.6.12 during upgrade *} |
2 | ||
3 | -- CRM-16173, CRM-16831 | |
4 | SELECT @parent_id := id from `civicrm_navigation` where name = 'System Settings' AND domain_id = {$domainID}; | |
5 | SELECT @add_weight_id := weight from `civicrm_navigation` where `name` = 'Manage Extensions' and `parent_id` = @parent_id; | |
6 | UPDATE `civicrm_navigation` | |
7 | SET `weight` = `weight`+1 | |
8 | WHERE `parent_id` = @parent_id | |
9 | AND `weight` > @add_weight_id; | |
10 | INSERT INTO `civicrm_navigation` | |
11 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
12 | VALUES | |
13 | ( {$domainID}, 'civicrm/a/#/cxn', '{ts escape="sql" skip="true"}Connections{/ts}', 'Connections', 'administer CiviCRM', '', @parent_id , '1', NULL, @add_weight_id + 1 ); |