Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-4866 |
2 | ||
3 | SELECT @domain_id := min(id) FROM civicrm_domain; | |
4 | SELECT @nav_pl := id FROM civicrm_navigation WHERE name = 'Pledges'; | |
5 | SELECT @nav_pl_wt := max(weight) from civicrm_navigation WHERE parent_id = @nav_pl; | |
6 | ||
7 | INSERT INTO civicrm_navigation | |
8 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
9 | VALUES | |
10824d34 | 10 | ( @domain_id, 'civicrm/contact/view/pledge&reset=1&action=add&context=standalone', '{ts escape="sql"}New Pledge{/ts}','New Pledge', NULL, '', @nav_pl, '1', NULL, @nav_pl_wt+1 ); |