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         <pseudoconstant>
  24             <table>civicrm_domain</table>
  25             <keyColumn>id</keyColumn>
  26             <labelColumn>name</labelColumn>
  27         </pseudoconstant>
  28         <comment>Domain for dashboard</comment>
  29         <add>3.1</add>
  30     </field>
  31     <foreignKey>
  32         <name>domain_id</name>
  33         <table>civicrm_domain</table>
  34         <key>id</key>
  35         <add>3.1</add>
  36     </foreignKey>
  37     <field>
  38       <name>name</name>
  39       <type>varchar</type>
  40       <title>Dashlet Name</title>
  41       <length>64</length>
  42       <comment>Internal name of dashlet.</comment>
  43       <add>4.4</add>
  44     </field>
  45     <field>
  46         <name>label</name>
  47         <type>varchar</type>
  48         <length>255</length>
  49         <comment>dashlet title</comment>
  50         <localizable>true</localizable>
  51         <add>3.1</add>
  52     </field>
  53     <field>
  54         <name>url</name>
  55         <type>varchar</type>
  56         <length>255</length>
  57         <comment>url in case of external dashlet</comment>
  58         <add>3.1</add>
  59     </field>
  60     <field>
  61         <name>content</name>
  62         <type>text</type>
  63         <comment>dashlet content</comment>
  64         <add>3.1</add>
  65         <drop>3.3</drop>
  66     </field>
  67     <field>
  68         <name>permission</name>
  69         <type>varchar</type>
  70         <length>255</length>
  71         <comment>Permission for the dashlet</comment>
  72         <add>3.1</add>
  73     </field>
  74     <field>
  75         <name>permission_operator</name>
  76         <type>varchar</type>
  77         <length>3</length>
  78         <comment>Permission Operator</comment>
  79         <add>3.1</add>
  80     </field>
  81     <field>
  82         <name>column_no</name>
  83         <type>boolean</type>
  84         <comment>column no for this dashlet</comment>
  85         <default>0</default>
  86         <add>3.1</add>
  87     </field>
  88     <field>
  89         <name>is_minimized</name>
  90         <type>boolean</type>
  91         <comment>Is Minimized?</comment>
  92         <default>0</default>
  93         <add>3.1</add>
  94     </field>
  95     <field>
  96         <name>fullscreen_url</name>
  97         <type>varchar</type>
  98         <length>255</length>
  99         <comment>fullscreen url for dashlet</comment>
 100         <add>3.4</add>
 101     </field>
 102     <field>
 103         <name>is_fullscreen</name>
 104         <type>boolean</type>
 105         <comment>Is Fullscreen?</comment>
 106         <default>1</default>
 107         <add>3.1</add>
 108     </field>
 109     <field>
 110         <name>is_active</name>
 111         <type>boolean</type>
 112         <comment>Is this dashlet active?</comment>
 113         <default>0</default>
 114         <add>3.1</add>
 115     </field>
 116     <field>
 117         <name>is_reserved</name>
 118         <type>boolean</type>
 119         <comment>Is this dashlet reserved?</comment>
 120         <default>0</default>
 121         <add>3.1</add>
 122     </field>
 123     <field>
 124         <name>weight</name>
 125         <type>int</type>
 126         <comment>Ordering of the dashlets.</comment>
 127         <default>0</default>
 128         <add>3.1</add>
 129     </field>
 130     <field>
 131         <name>created_date</name>
 132         <type>datetime</type>
 133         <comment>When was content populated</comment>
 134         <add>3.1</add>
 135         <drop>3.3</drop>
 136     </field>
 137 </table>