xml/schema/Core/Setting.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Setting</class>
   6   <name>civicrm_setting</name>
   7   <comment>Table to store civicrm settings for civicrm core and components.</comment>
   8   <add>4.1</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <add>4.1</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20        <name>group_name</name>
  21        <type>varchar</type>
  22        <length>64</length>
  23        <required>true</required>
  24        <comment>group name for setting element, useful in caching setting elements</comment>
  25        <add>4.1</add>
  26   </field>
  27   <field>
  28        <name>name</name>
  29        <type>varchar</type>
  30        <length>255</length>
  31        <comment>Unique name for setting</comment>
  32        <add>4.1</add>
  33   </field>
  34   <index>
  35     <name>index_group_name</name>
  36     <fieldName>group_name</fieldName>
  37     <fieldName>name</fieldName>
  38     <add>4.1</add>
  39   </index>
  40   <field>
  41     <name>value</name>
  42     <type>text</type>
  43     <comment>data associated with this group / name combo</comment>
  44     <add>4.1</add>
  45   </field>
  46   <field>
  47       <name>domain_id</name>
  48       <type>int unsigned</type>
  49       <required>true</required>
  50       <pseudoconstant>
  51           <table>civicrm_domain</table>
  52           <keyColumn>id</keyColumn>
  53           <labelColumn>name</labelColumn>
  54       </pseudoconstant>
  55       <comment>Which Domain is this menu item for</comment>
  56       <add>4.1</add>
  57   </field>
  58   <foreignKey>
  59        <name>domain_id</name>
  60        <table>civicrm_domain</table>
  61        <key>id</key>
  62        <onDelete>CASCADE</onDelete>
  63        <add>4.1</add>
  64   </foreignKey>
  65   <field>
  66       <name>contact_id</name>
  67       <type>int unsigned</type>
  68       <comment>FK to Contact ID if the setting is localized to a contact</comment>
  69       <add>4.1</add>
  70   </field>
  71   <foreignKey>
  72        <name>contact_id</name>
  73        <table>civicrm_contact</table>
  74        <key>id</key>
  75        <onDelete>CASCADE</onDelete>
  76        <add>4.1</add>
  77   </foreignKey>
  78   <field>
  79        <name>is_domain</name>
  80        <type>boolean</type>
  81        <comment>Is this setting a contact specific or site wide setting?</comment>
  82        <add>4.1</add>
  83   </field>
  84   <field>
  85     <name>component_id</name>
  86     <type>int unsigned</type>
  87     <comment>Component that this menu item belongs to</comment>
  88     <add>4.1</add>
  89     <pseudoconstant>
  90       <table>civicrm_component</table>
  91       <keyColumn>id</keyColumn>
  92       <labelColumn>name</labelColumn>
  93     </pseudoconstant>
  94     <html>
  95       <type>Select</type>
  96     </html>
  97   </field>
  98   <foreignKey>
  99        <name>component_id</name>
 100        <table>civicrm_component</table>
 101        <key>id</key>
 102        <add>4.1</add>
 103   </foreignKey>
 104   <field>
 105     <name>created_date</name>
 106     <type>datetime</type>
 107     <comment>When was the setting created</comment>
 108     <add>4.1</add>
 109   </field>
 110   <field>
 111     <name>created_id</name>
 112     <type>int unsigned</type>
 113     <comment>FK to civicrm_contact, who created this setting</comment>
 114     <add>4.1</add>
 115   </field>
 116   <foreignKey>
 117     <name>created_id</name>
 118     <table>civicrm_contact</table>
 119     <key>id</key>
 120     <add>4.1</add>
 121     <onDelete>SET NULL</onDelete>
 122   </foreignKey>
 123 </table>