X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FContact%2FDashboardContact.xml;h=9ec01e202e84d90b75c4b3b62ce55e554ff871d1;hb=46795cdab4d39b9217b461aa295e4b6b536d5a2c;hp=95d990523a958ee1f4dbb0c1e44a9b121af10ba7;hpb=674cb8b854f6008090d4dcce9372ee76346a198f;p=civicrm-core.git

diff --git a/xml/schema/Contact/DashboardContact.xml b/xml/schema/Contact/DashboardContact.xml
index 95d990523a..9ec01e202e 100644
--- a/xml/schema/Contact/DashboardContact.xml
+++ b/xml/schema/Contact/DashboardContact.xml
@@ -47,9 +47,16 @@
     <onDelete>CASCADE</onDelete>
     <add>3.1</add>
   </foreignKey>
+  <index>
+    <name>index_dashboard_id_contact_id</name>
+    <fieldName>dashboard_id</fieldName>
+    <fieldName>contact_id</fieldName>
+    <unique>true</unique>
+    <add>4.7</add>
+  </index>
   <field>
     <name>column_no</name>
-    <type>boolean</type>
+    <type>int</type>
     <comment>column no for this widget</comment>
     <default>0</default>
     <add>3.1</add>
@@ -61,6 +68,7 @@
     <comment>Is Minimized?</comment>
     <default>0</default>
     <add>3.1</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>is_fullscreen</name>
@@ -69,6 +77,7 @@
     <comment>Is Fullscreen?</comment>
     <default>1</default>
     <add>3.1</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>is_active</name>
@@ -91,6 +100,7 @@
     <type>longtext</type>
     <comment>dashlet content</comment>
     <add>3.3</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>created_date</name>
@@ -98,5 +108,6 @@
     <title>Dashlet Created On</title>
     <comment>When was content populated</comment>
     <add>3.3</add>
+    <drop>4.7</drop>
   </field>
 </table>