Merge pull request #17026 from jitendrapurohit/dev-57

[civicrm-core.git] / xml / schema / Core / Setting.xml

diff --git a/xml/schema/Core/Setting.xml b/xml/schema/Core/Setting.xml
index e50318fa556bab248583affb555a2a07908c0b36..0a5263fab71c3b0da36a90ab03491c1c367c7da3 100644 (file)
--- a/xml/schema/Core/Setting.xml
+++ b/xml/schema/Core/Setting.xml
@@ -25,6 +25,7 @@
     <required>true</required>
     <comment>group name for setting element, useful in caching setting elements</comment>
     <add>4.1</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>name</name>
@@ -39,11 +40,13 @@
     <fieldName>group_name</fieldName>
     <fieldName>name</fieldName>
     <add>4.1</add>
+    <drop>4.7</drop>
   </index>
   <field>
     <name>value</name>
     <type>text</type>
     <comment>data associated with this group / name combo</comment>
+    <serialize>PHP</serialize>
     <add>4.1</add>
   </field>
   <field>
@@ -129,4 +132,13 @@
     <add>4.1</add>
     <onDelete>SET NULL</onDelete>
   </foreignKey>
+  <index>
+    <name>index_domain_contact_name</name>
+    <fieldName>domain_id</fieldName>
+    <fieldName>contact_id</fieldName>
+    <fieldName>name</fieldName>
+    <unique>true</unique>
+    <add>4.7</add>
+  </index>
+
 </table>