CRM-17663 - Cruft removal

[civicrm-core.git] / xml / schema / Contact / DashboardContact.xml

diff --git a/xml/schema/Contact/DashboardContact.xml b/xml/schema/Contact/DashboardContact.xml
index b09b4ea2069700f4512009b0b4a4be94e4ad97c5..6e3f0599b9331dcf9b1f0176607cc93faa825ed9 100644 (file)
--- a/xml/schema/Contact/DashboardContact.xml
+++ b/xml/schema/Contact/DashboardContact.xml
@@ -7,88 +7,107 @@
   <comment>Table to store dashboard for each contact.</comment>
   <add>3.1</add>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <add>3.1</add>
+    <name>id</name>
+    <type>int unsigned</type>
+    <title>Dashboard Contact ID</title>
+    <required>true</required>
+    <add>3.1</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>dashboard_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>Dashboard ID</comment>
-      <add>3.1</add>
+    <name>dashboard_id</name>
+    <type>int unsigned</type>
+    <title>Dashboard</title>
+    <required>true</required>
+    <comment>Dashboard ID</comment>
+    <add>3.1</add>
   </field>
   <foreignKey>
-       <name>dashboard_id</name>
-       <table>civicrm_dashboard</table>
-       <key>id</key>
-       <onDelete>CASCADE</onDelete>
-       <add>3.1</add>
+    <name>dashboard_id</name>
+    <table>civicrm_dashboard</table>
+    <key>id</key>
+    <onDelete>CASCADE</onDelete>
+    <add>3.1</add>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>Contact ID</comment>
-      <add>3.1</add>
+    <name>contact_id</name>
+    <type>int unsigned</type>
+    <title>Dashboard Contact</title>
+    <required>true</required>
+    <comment>Contact ID</comment>
+    <add>3.1</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <onDelete>CASCADE</onDelete>
-       <add>3.1</add>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <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>
-       <comment>column no for this widget</comment>
-       <default>0</default>
-       <add>3.1</add>
+    <name>column_no</name>
+    <type>boolean</type>
+    <comment>column no for this widget</comment>
+    <default>0</default>
+    <add>3.1</add>
   </field>
   <field>
-       <name>is_minimized</name>
-       <type>boolean</type>
-       <comment>Is Minimized?</comment>
-       <default>0</default>
-       <add>3.1</add>
+    <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>
-      <comment>Is Fullscreen?</comment>
-      <default>1</default>
-      <add>3.1</add>
+    <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>
-       <comment>Is this widget active?</comment>
-       <default>0</default>
-       <add>3.1</add>
+    <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>
     <add>3.1</add>
   </field>
   <field>
-     <name>content</name>
-     <type>longtext</type>
-     <comment>dashlet content</comment>
-     <add>3.3</add>
+    <name>content</name>
+    <type>longtext</type>
+    <comment>dashlet content</comment>
+    <add>3.3</add>
+    <drop>4.7</drop>
   </field>
   <field>
-      <name>created_date</name>
-      <type>datetime</type>
-      <comment>When was content populated</comment>
-      <add>3.3</add>
+    <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>