1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <name>civicrm_setting
</name>
7 <comment>Table to store civicrm settings for civicrm core and components.
</comment>
11 <type>int unsigned
</type>
12 <required>true
</required>
17 <autoincrement>true
</autoincrement>
20 <name>group_name
</name>
23 <required>true
</required>
24 <comment>group name for setting element, useful in caching setting elements
</comment>
31 <comment>Unique name for setting
</comment>
35 <name>index_group_name
</name>
36 <fieldName>group_name
</fieldName>
37 <fieldName>name
</fieldName>
43 <comment>data associated with this group / name combo
</comment>
47 <name>domain_id
</name>
48 <type>int unsigned
</type>
49 <required>true
</required>
50 <comment>Which Domain is this menu item for
</comment>
54 <name>domain_id
</name>
55 <table>civicrm_domain
</table>
57 <onDelete>CASCADE
</onDelete>
61 <name>contact_id
</name>
62 <type>int unsigned
</type>
63 <comment>FK to Contact ID if the setting is localized to a contact
</comment>
67 <name>contact_id
</name>
68 <table>civicrm_contact
</table>
70 <onDelete>CASCADE
</onDelete>
74 <name>is_domain
</name>
76 <comment>Is this setting a contact specific or site wide setting?
</comment>
80 <name>component_id
</name>
81 <type>int unsigned
</type>
82 <comment>Component that this menu item belongs to
</comment>
85 <table>civicrm_component
</table>
86 <keyColumn>id
</keyColumn>
87 <labelColumn>name
</labelColumn>
94 <name>component_id
</name>
95 <table>civicrm_component
</table>
100 <name>created_date
</name>
101 <type>datetime
</type>
102 <comment>When was the setting created
</comment>
106 <name>created_id
</name>
107 <type>int unsigned
</type>
108 <comment>FK to civicrm_contact, who created this setting
</comment>
112 <name>created_id
</name>
113 <table>civicrm_contact
</table>
116 <onDelete>SET NULL
</onDelete>