CRM-13283 - Initial API for StatusPreference
[civicrm-core.git] / xml / schema / Core / StatusPreference.xml
CommitLineData
09e22d82
J
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 Preference Name</title>
43 <type>int unsigned</type>
44 <import>true</import>
45 <add>4.7</add>
46 </field>
47 <index>
48 <name>UI_status_pref_name</name>
49 <fieldName>name</fieldName>
50 <unique>true</unique>
51 <add>4.7</add>
52 </index>
53 <field>
54 <name>hush_until</name>
55 <title>Hush Status Notifications Until</title>
56 <type>date</type>
57 <import>true</import>
58 <comment>expires minimum_date_severity. NULL never hushes.</comment>
59 <default>NULL</default>
60 <add>4.7</add>
61 </field>
62 <field>
63 <name>minimum_report_severity</name>
64 <title>Minimum Report Severity</title>
65 <type>int unsigned</type>
66 <import>true</import>
67 <comment>Hush messages up to but excluding this severity.</comment>
68 <add>4.7</add>
69 </field>
70 <field>
71 <name>prefs</name>
72 <title>Status Preferences</title>
73 <type>varchar</type>
74 <length>255</length>
75 <comment>These settings are per-check, and can't be compared across checks.</comment>
76 <add>4.7</add>
77 </field>
78</table>