From e4c1b25e6ddaecaa1116d9d79cfa8b704e2d9e0f Mon Sep 17 00:00:00 2001
From: CiviCRM <info@civicrm.org>
Date: Tue, 5 Jan 2016 17:06:19 -0800
Subject: [PATCH] CRM-16173 - 4.6.12.mysql.tpl - Register "System Settings =>
 Connections" link

---
 CRM/Upgrade/Incremental/sql/4.6.12.mysql.tpl | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 CRM/Upgrade/Incremental/sql/4.6.12.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.6.12.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.12.mysql.tpl
new file mode 100644
index 0000000000..6ae76a7d9d
--- /dev/null
+++ b/CRM/Upgrade/Incremental/sql/4.6.12.mysql.tpl
@@ -0,0 +1,13 @@
+{* file to handle db changes in 4.6.12 during upgrade *}
+
+-- CRM-16173, CRM-16831
+SELECT @parent_id := id from `civicrm_navigation` where name = 'System Settings' AND domain_id = {$domainID};
+SELECT @add_weight_id := weight from `civicrm_navigation` where `name` = 'Manage Extensions' and `parent_id` = @parent_id;
+UPDATE `civicrm_navigation`
+SET `weight` = `weight`+1
+WHERE `parent_id` = @parent_id
+AND `weight` > @add_weight_id;
+INSERT INTO `civicrm_navigation`
+( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
+VALUES
+( {$domainID}, 'civicrm/a/#/cxn', '{ts escape="sql" skip="true"}Connections{/ts}', 'Connections', 'administer CiviCRM', '', @parent_id , '1', NULL, @add_weight_id + 1 );
-- 
2.25.1