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>
86 <name>component_id
</name>
87 <table>civicrm_component
</table>
92 <name>created_date
</name>
94 <comment>When was the setting created
</comment>
98 <name>created_id
</name>
99 <type>int unsigned
</type>
100 <comment>FK to civicrm_contact, who created this setting
</comment>
104 <name>created_id
</name>
105 <table>civicrm_contact
</table>
108 <onDelete>SET NULL
</onDelete>