Merge pull request #6457 from GinkgoFJG/angular_snippets
[civicrm-core.git] / xml / schema / Core / StatusPreference.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Core</base>
5 <class>StatusPreference</class>
6 <name>civicrm_status_pref</name>
7 <comment>Preferences controlling status checks called in system.check.</comment>
8 <add>4.7</add>
9 <field>
10 <name>id</name>
11 <type>int unsigned</type>
12 <title>Status Preference ID</title>
13 <required>true</required>
14 <comment>Unique Status Preference ID</comment>
15 <add>4.7</add>
16 </field>
17 <primaryKey>
18 <name>id</name>
19 <autoincrement>true</autoincrement>
20 </primaryKey>
21 <field>
22 <name>domain_id</name>
23 <title>Setting Domain</title>
24 <type>int unsigned</type>
25 <required>true</required>
26 <pseudoconstant>
27 <table>civicrm_domain</table>
28 <keyColumn>id</keyColumn>
29 <labelColumn>name</labelColumn>
30 </pseudoconstant>
31 <comment>Which Domain is this Status Preference for</comment>
32 <add>4.7</add>
33 </field>
34 <foreignKey>
35 <name>domain_id</name>
36 <table>civicrm_domain</table>
37 <key>id</key>
38 <add>4.7</add>
39 </foreignKey>
40 <field>
41 <name>name</name>
42 <title>Status Check Name</title>
43 <type>varchar</type>
44 <length>255</length>
45 <import>true</import>
46 <required>true</required>
47 <comment>Name of the status check this preference references.</comment>
48 <add>4.7</add>
49 </field>
50 <index>
51 <name>UI_status_pref_name</name>
52 <fieldName>name</fieldName>
53 <add>4.7</add>
54 </index>
55 <field>
56 <name>hush_until</name>
57 <title>Hush Status Notifications Until</title>
58 <type>date</type>
59 <import>true</import>
60 <comment>expires ignore_severity. NULL never hushes.</comment>
61 <default>NULL</default>
62 <add>4.7</add>
63 </field>
64 <field>
65 <name>ignore_severity</name>
66 <title>Ignore Severity</title>
67 <type>int unsigned</type>
68 <import>true</import>
69 <comment>Hush messages up to and including this severity.</comment>
70 <default>1</default>
71 <add>4.7</add>
72 </field>
73 <field>
74 <name>prefs</name>
75 <title>Status Preferences</title>
76 <type>varchar</type>
77 <length>255</length>
78 <comment>These settings are per-check, and can't be compared across checks.</comment>
79 <add>4.7</add>
80 </field>
81 <field>
82 <name>check_info</name>
83 <title>Check Info</title>
84 <type>varchar</type>
85 <length>255</length>
86 <comment>These values are per-check, and can't be compared across checks.</comment>
87 <add>4.7</add>
88 </field>
89 </table>