xml/schema/Core/Preferences.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Preferences</class>
   6   <name>civicrm_preferences</name>
   7   <comment>Define preferences for the site and users</comment>
   8   <add>1.8</add>
   9   <drop>4.1</drop>
  10   <log>true</log>
  11   <field>
  12       <name>id</name>
  13       <type>int unsigned</type>
  14       <required>true</required>
  15        <add>1.8</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22       <name>domain_id</name>
  23       <type>int unsigned</type>
  24       <required>true</required>
  25       <pseudoconstant>
  26           <table>civicrm_domain</table>
  27           <keyColumn>id</keyColumn>
  28           <labelColumn>name</labelColumn>
  29       </pseudoconstant>
  30       <comment>Which Domain is this menu item for</comment>
  31       <add>3.0</add>
  32   </field>
  33   <foreignKey>
  34        <name>domain_id</name>
  35        <table>civicrm_domain</table>
  36        <key>id</key>
  37        <onDelete>CASCADE</onDelete>
  38        <add>3.0</add>
  39   </foreignKey>
  40   <field>
  41       <name>contact_id</name>
  42       <type>int unsigned</type>
  43       <comment>FK to Contact ID</comment>
  44       <add>1.8</add>
  45   </field>
  46   <foreignKey>
  47        <name>contact_id</name>
  48        <table>civicrm_contact</table>
  49        <key>id</key>
  50        <onDelete>CASCADE</onDelete>
  51        <add>1.8</add>
  52   </foreignKey>
  53   <field>
  54        <name>is_domain</name>
  55        <type>boolean</type>
  56        <comment>Is this the record for the domain setting?</comment>
  57        <add>1.8</add>
  58   </field>
  59   <field>
  60        <name>location_count</name>
  61        <type>int unsigned</type>
  62        <comment>Number of locations to be displayed on edit page?</comment>
  63        <add>1.8</add>
  64        <drop>3.0</drop>
  65   </field>
  66   <field>
  67        <name>contact_view_options</name>
  68        <type>varchar</type>
  69        <length>128</length>
  70        <comment>What tabs are displayed in the contact summary</comment>
  71        <add>1.8</add>
  72   </field>
  73   <index>
  74     <name>index_contact_view_options</name>
  75     <fieldName>contact_view_options</fieldName>
  76     <add>1.8</add>
  77   </index>
  78   <field>
  79        <name>contact_edit_options</name>
  80        <type>varchar</type>
  81        <length>128</length>
  82        <comment>What tabs are displayed in the contact edit</comment>
  83        <add>1.8</add>
  84   </field>
  85   <index>
  86     <name>index_contact_edit_options</name>
  87     <fieldName>contact_edit_options</fieldName>
  88     <add>1.8</add>
  89   </index>
  90   <field>
  91        <name>advanced_search_options</name>
  92        <type>varchar</type>
  93        <length>128</length>
  94        <comment>What tabs are displayed in the advanced search screen</comment>
  95        <add>1.8</add>
  96   </field>
  97   <index>
  98     <name>index_advanced_search_options</name>
  99     <fieldName>advanced_search_options</fieldName>
 100     <add>1.8</add>
 101   </index>
 102   <field>
 103        <name>user_dashboard_options</name>
 104        <type>varchar</type>
 105        <length>128</length>
 106        <comment>What tabs are displayed in the contact edit</comment>
 107        <add>1.8</add>
 108   </field>
 109   <index>
 110     <name>index_user_dashboard_options</name>
 111     <fieldName>user_dashboard_options</fieldName>
 112     <add>1.8</add>
 113   </index>
 114   <field>
 115        <name>address_options</name>
 116        <type>varchar</type>
 117        <length>128</length>
 118        <comment>What fields are displayed from the address table</comment>
 119        <add>1.8</add>
 120   </field>
 121  <index>
 122     <name>index_address_options</name>
 123     <fieldName>address_options</fieldName>
 124     <add>1.8</add>
 125   </index>
 126   <field>
 127        <name>address_format</name>
 128        <type>text</type>
 129        <comment>Format to display the address</comment>
 130        <add>1.8</add>
 131   </field>
 132   <field>
 133        <name>mailing_format</name>
 134        <type>text</type>
 135        <comment>Format to display a mailing label</comment>
 136        <add>1.8</add>
 137   </field>
 138   <field>
 139        <name>display_name_format</name>
 140        <type>text</type>
 141        <comment>Format to display contact display name</comment>
 142        <add>3.2</add>
 143   </field>
 144   <field>
 145        <name>sort_name_format</name>
 146        <type>text</type>
 147        <comment>Format to display contact sort name</comment>
 148        <add>3.2</add>
 149   </field>
 150   <field>
 151        <name>individual_name_format</name>
 152        <type>text</type>
 153        <comment>Format to display a individual name</comment>
 154        <add>1.8</add>
 155        <drop>3.0</drop>
 156   </field>
 157   <field>
 158        <name>address_standardization_provider</name>
 159        <type>varchar</type>
 160        <length>64</length>
 161        <comment>object name of provider for address standarization</comment>
 162        <add>1.8</add>
 163   </field>
 164   <field>
 165        <name>address_standardization_userid</name>
 166        <type>varchar</type>
 167        <length>64</length>
 168        <comment>user id for provider login</comment>
 169        <add>1.8</add>
 170   </field>
 171   <field>
 172        <name>address_standardization_url</name>
 173        <type>varchar</type>
 174        <length>255</length>
 175        <comment>url of address standardization service</comment>
 176        <add>1.8</add>
 177   </field>
 178  <field>
 179        <name>editor_id</name>
 180        <type>int unsigned</type>
 181        <length>4</length>
 182        <comment>ID of the editor</comment>
 183        <add>2.1</add>
 184   </field>
 185  <field>
 186        <name>mailing_backend</name>
 187        <type>text</type>
 188        <comment>Smtp Backend configuration.</comment>
 189        <html>
 190          <type>TextArea</type>
 191          <rows>20</rows>
 192          <cols>80</cols>
 193        </html>
 194        <add>2.2</add>
 195   </field>
 196   <field>
 197        <name>navigation</name>
 198        <type>text</type>
 199        <comment>Store navigation for the Contact</comment>
 200        <add>3.0</add>
 201   </field>
 202   <field>
 203        <name>contact_autocomplete_options</name>
 204        <type>varchar</type>
 205        <length>255</length>
 206        <comment>What Autocomplete has to return</comment>
 207        <add>3.1</add>
 208   </field>
 209 </table>