xml/schema/Core/Dashboard.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4     <base>CRM/Core</base>
   5     <class>Dashboard</class>
   6     <name>civicrm_dashboard</name>
   7     <comment>Table to store dashboard.</comment>
   8     <add>3.1</add>
   9     <field>
  10         <name>id</name>
  11         <type>int unsigned</type>
  12         <required>true</required>
  13         <add>3.1</add>
  14     </field>
  15     <primaryKey>
  16         <name>id</name>
  17         <autoincrement>true</autoincrement>
  18     </primaryKey>
  19     <field>
  20         <name>domain_id</name>
  21         <type>int unsigned</type>
  22         <required>true</required>
  23         <comment>Domain for dashboard</comment>
  24         <add>3.1</add>
  25     </field>
  26     <foreignKey>
  27         <name>domain_id</name>
  28         <table>civicrm_domain</table>
  29         <key>id</key>
  30         <add>3.1</add>
  31     </foreignKey>
  32     <field>
  33       <name>name</name>
  34       <type>varchar</type>
  35       <title>Dashlet Name</title>
  36       <length>64</length>
  37       <comment>Internal name of dashlet.</comment>
  38       <add>4.4</add>
  39     </field>
  40     <field>
  41         <name>label</name>
  42         <type>varchar</type>
  43         <length>255</length>
  44         <comment>dashlet title</comment>
  45         <localizable>true</localizable>
  46         <add>3.1</add>
  47     </field>
  48     <field>
  49         <name>url</name>
  50         <type>varchar</type>
  51         <length>255</length>
  52         <comment>url in case of external dashlet</comment>
  53         <add>3.1</add>
  54     </field>
  55     <field>
  56         <name>content</name>
  57         <type>text</type>
  58         <comment>dashlet content</comment>
  59         <add>3.1</add>
  60         <drop>3.3</drop>
  61     </field>
  62     <field>
  63         <name>permission</name>
  64         <type>varchar</type>
  65         <length>255</length>
  66         <comment>Permission for the dashlet</comment>
  67         <add>3.1</add>
  68     </field>
  69     <field>
  70         <name>permission_operator</name>
  71         <type>varchar</type>
  72         <length>3</length>
  73         <comment>Permission Operator</comment>
  74         <add>3.1</add>
  75     </field>
  76     <field>
  77         <name>column_no</name>
  78         <type>boolean</type>
  79         <comment>column no for this dashlet</comment>
  80         <default>0</default>
  81         <add>3.1</add>
  82     </field>
  83     <field>
  84         <name>is_minimized</name>
  85         <type>boolean</type>
  86         <comment>Is Minimized?</comment>
  87         <default>0</default>
  88         <add>3.1</add>
  89     </field>
  90     <field>
  91         <name>fullscreen_url</name>
  92         <type>varchar</type>
  93         <length>255</length>
  94         <comment>fullscreen url for dashlet</comment>
  95         <add>3.4</add>
  96     </field>
  97     <field>
  98         <name>is_fullscreen</name>
  99         <type>boolean</type>
 100         <comment>Is Fullscreen?</comment>
 101         <default>1</default>
 102         <add>3.1</add>
 103     </field>
 104     <field>
 105         <name>is_active</name>
 106         <type>boolean</type>
 107         <comment>Is this dashlet active?</comment>
 108         <default>0</default>
 109         <add>3.1</add>
 110     </field>
 111     <field>
 112         <name>is_reserved</name>
 113         <type>boolean</type>
 114         <comment>Is this dashlet reserved?</comment>
 115         <default>0</default>
 116         <add>3.1</add>
 117     </field>
 118     <field>
 119         <name>weight</name>
 120         <type>int</type>
 121         <comment>Ordering of the dashlets.</comment>
 122         <default>0</default>
 123         <add>3.1</add>
 124     </field>
 125     <field>
 126         <name>created_date</name>
 127         <type>datetime</type>
 128         <comment>When was content populated</comment>
 129         <add>3.1</add>
 130         <drop>3.3</drop>
 131     </field>
 132 </table>