CRM/Upgrade/Incremental/sql/3.0.alpha2.mysql.tpl

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