From 311de541ddf396d1988803ade324fd7ed1666f79 Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Sun, 27 Oct 2013 07:54:36 -0700
Subject: [PATCH] CRM-13655 - WordReplacement.xml - Update UNIQUE key for new
 installations

----------------------------------------
* CRM-13655: WordReplacement - Uniqueness key should allow different cases and domains
  http://issues.civicrm.org/jira/browse/CRM-13655
---
 xml/schema/Core/WordReplacement.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/xml/schema/Core/WordReplacement.xml b/xml/schema/Core/WordReplacement.xml
index e19d764234..2d5f23ec4c 100644
--- a/xml/schema/Core/WordReplacement.xml
+++ b/xml/schema/Core/WordReplacement.xml
@@ -21,6 +21,7 @@
     <name>find_word</name>
     <type>varchar</type>
     <length>255</length>
+    <collate>utf8_bin</collate>
     <comment>Word which need to be replaced</comment>
     <add>4.4</add>
   </field>
@@ -28,6 +29,7 @@
     <name>replace_word</name>
     <type>varchar</type>
     <length>255</length>
+    <collate>utf8_bin</collate>
     <comment>Word which will replace the word in find</comment>
     <add>4.4</add>
   </field>
@@ -40,6 +42,7 @@
   </field>
   <index>
     <name>UI_find</name>
+    <fieldName>domain_id</fieldName>
     <fieldName>find_word</fieldName>
     <unique>true</unique>
     <add>4.4</add>
-- 
2.25.1