From 169abce49ab7daa71fabdc44bdddad65e1b882c2 Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Tue, 5 Jan 2016 10:40:11 +1300
Subject: [PATCH] CRM-17752 add index to civicrm_financial_trxn.trxn_id

https://issues.civicrm.org/jira/browse/CRM-17752
---
 CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl | 4 ++++
 xml/schema/Financial/FinancialTrxn.xml          | 7 ++++++-
 2 files changed, 10 insertions(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl
index ead67d5eea..23d481cf68 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl
@@ -13,3 +13,7 @@ AFTER is_multiple_registrations;
 UPDATE civicrm_event
 SET max_additional_participants = 9
 WHERE is_multiple_registrations = 1;
+
+-- CRM-17752
+ALTER TABLE `civicrm_financial_trxn`
+ADD INDEX `UI_ftrxn_trxn_id` (`trxn_id`);
diff --git a/xml/schema/Financial/FinancialTrxn.xml b/xml/schema/Financial/FinancialTrxn.xml
index a681beec67..0b26359252 100755
--- a/xml/schema/Financial/FinancialTrxn.xml
+++ b/xml/schema/Financial/FinancialTrxn.xml
@@ -170,9 +170,14 @@
     <title>Transaction ID</title>
     <type>varchar</type>
     <length>255</length>
-    <comment>user-specified unique processor transaction id, bank id + trans id,... depending on payment_method</comment>
+    <comment>Transaction id supplied by external processor. This may not be unique.</comment>
     <add>1.3</add>
   </field>
+  <index>
+    <name>UI_ftrxn_trxn_id</name>
+    <fieldName>trxn_id</fieldName>
+    <add>4.7</add>
+  </index>
   <field>
     <name>trxn_result_code</name>
     <title>Transaction result Code</title>
-- 
2.25.1