CRM-17663 - Cruft removal
[civicrm-core.git] / xml / schema / Contact / DashboardContact.xml
index dfb94a73f3617820c909186b470bd4db3dab4046..6e3f0599b9331dcf9b1f0176607cc93faa825ed9 100644 (file)
@@ -9,6 +9,7 @@
   <field>
     <name>id</name>
     <type>int unsigned</type>
+    <title>Dashboard Contact ID</title>
     <required>true</required>
     <add>3.1</add>
   </field>
@@ -19,6 +20,7 @@
   <field>
     <name>dashboard_id</name>
     <type>int unsigned</type>
+    <title>Dashboard</title>
     <required>true</required>
     <comment>Dashboard ID</comment>
     <add>3.1</add>
@@ -33,6 +35,7 @@
   <field>
     <name>contact_id</name>
     <type>int unsigned</type>
+    <title>Dashboard Contact</title>
     <required>true</required>
     <comment>Contact ID</comment>
     <add>3.1</add>
     <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>
   <field>
     <name>is_minimized</name>
     <type>boolean</type>
+    <title>Dashlet is Minimized?</title>
     <comment>Is Minimized?</comment>
     <default>0</default>
     <add>3.1</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>is_fullscreen</name>
     <type>boolean</type>
+    <title>Dashlet is FullScreen?</title>
     <comment>Is Fullscreen?</comment>
     <default>1</default>
     <add>3.1</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>is_active</name>
     <type>boolean</type>
+    <title>Dashlet is Active?</title>
     <comment>Is this widget active?</comment>
     <default>0</default>
     <add>3.1</add>
   </field>
   <field>
     <name>weight</name>
+    <title>Order</title>
     <type>int</type>
     <comment>Ordering of the widgets.</comment>
     <default>0</default>
     <type>longtext</type>
     <comment>dashlet content</comment>
     <add>3.3</add>
+    <drop>4.7</drop>
   </field>
   <field>
     <name>created_date</name>
     <type>datetime</type>
+    <title>Dashlet Created On</title>
     <comment>When was content populated</comment>
     <add>3.3</add>
+    <drop>4.7</drop>
   </field>
 </table>