Merge pull request #19525 from eileenmcnaughton/member_soft
[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 <html>
16 <type>Number</type>
17 </html>
18 <add>4.7</add>
19 </field>
20 <primaryKey>
21 <name>id</name>
22 <autoincrement>true</autoincrement>
23 </primaryKey>
24 <field>
25 <name>domain_id</name>
26 <title>Domain ID</title>
27 <type>int unsigned</type>
28 <required>true</required>
29 <pseudoconstant>
30 <table>civicrm_domain</table>
31 <keyColumn>id</keyColumn>
32 <labelColumn>name</labelColumn>
33 </pseudoconstant>
34 <comment>Which Domain is this Status Preference for</comment>
35 <html>
36 <label>Domain</label>
37 </html>
38 <add>4.7</add>
39 </field>
40 <foreignKey>
41 <name>domain_id</name>
42 <table>civicrm_domain</table>
43 <key>id</key>
44 <add>4.7</add>
45 </foreignKey>
46 <field>
47 <name>name</name>
48 <title>Status Check Name</title>
49 <type>varchar</type>
50 <length>255</length>
51 <import>true</import>
52 <required>true</required>
53 <comment>Name of the status check this preference references.</comment>
54 <add>4.7</add>
55 </field>
56 <index>
57 <name>UI_status_pref_name</name>
58 <fieldName>name</fieldName>
59 <add>4.7</add>
60 </index>
61 <field>
62 <name>hush_until</name>
63 <title>Snooze Status Notifications Until</title>
64 <type>date</type>
65 <import>true</import>
66 <comment>expires ignore_severity. NULL never hushes.</comment>
67 <default>NULL</default>
68 <add>4.7</add>
69 </field>
70 <field>
71 <name>ignore_severity</name>
72 <title>Ignore Severity</title>
73 <type>int unsigned</type>
74 <import>true</import>
75 <comment>Hush messages up to and including this severity.</comment>
76 <default>1</default>
77 <add>4.7</add>
78 <pseudoconstant>
79 <callback>CRM_Utils_Check::getSeverityList</callback>
80 </pseudoconstant>
81 </field>
82 <field>
83 <name>prefs</name>
84 <title>Status Preferences</title>
85 <type>varchar</type>
86 <length>255</length>
87 <comment>These settings are per-check, and can't be compared across checks.</comment>
88 <add>4.7</add>
89 </field>
90 <field>
91 <name>check_info</name>
92 <title>Check Info</title>
93 <type>varchar</type>
94 <length>255</length>
95 <comment>These values are per-check, and can't be compared across checks.</comment>
96 <add>4.7</add>
97 </field>
98 <field>
99 <name>is_active</name>
100 <title>Check Is Active</title>
101 <type>boolean</type>
102 <default>1</default>
103 <comment>Is this status check active?</comment>
104 <add>5.19</add>
105 </field>
106 </table>