[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 3.3.6.mysql.tpl

-- CRM-7455

UPDATE civicrm_navigation
   SET name = 'Grant Report Detail'
 WHERE name LIKE 'Grant Report (Detail)';

UPDATE civicrm_navigation
   SET name = 'Grant Report Statistics'
 WHERE name LIKE 'Grant Report (Statistics)' OR name LIKE 'Shows statistics for grants';

SELECT @weight := weight
  FROM civicrm_navigation
 WHERE name LIKE 'Grant Report Detail';

UPDATE civicrm_navigation
   SET weight = @weight
 WHERE name LIKE 'Grant Report Statistics';
Commit	Line	Data
6a488035 TO	1	-- CRM-7455
6a488035 TO	2
10824d34	3	UPDATE civicrm_navigation
6a488035 TO	4	SET name = 'Grant Report Detail'
	5	WHERE name LIKE 'Grant Report (Detail)';
	6
10824d34	7	UPDATE civicrm_navigation
6a488035 TO	8	SET name = 'Grant Report Statistics'
	9	WHERE name LIKE 'Grant Report (Statistics)' OR name LIKE 'Shows statistics for grants';
	10
	11	SELECT @weight := weight
	12	FROM civicrm_navigation
	13	WHERE name LIKE 'Grant Report Detail';
	14
10824d34	15	UPDATE civicrm_navigation
6a488035 TO	16	SET weight = @weight
6a488035 TO	17	WHERE name LIKE 'Grant Report Statistics';