X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FCore%2FSetting.xml;h=0a5263fab71c3b0da36a90ab03491c1c367c7da3;hb=c5e2eefb0aeb40d78072a545540f82bc43fa9c14;hp=e50318fa556bab248583affb555a2a07908c0b36;hpb=22fd90d480014f0a551b25bea675a03d2153de78;p=civicrm-core.git

diff --git a/xml/schema/Core/Setting.xml b/xml/schema/Core/Setting.xml
index e50318fa55..0a5263fab7 100644
--- 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>