From 09e22d8298b577ed8d71981863ce54ee5f1b83c6 Mon Sep 17 00:00:00 2001
From: Jon goldberg <jon@palantetech.coop>
Date: Sun, 26 Apr 2015 09:58:28 -0600
Subject: [PATCH] CRM-13283 - Add schema file for StatusPreference entity

---
 xml/schema/Core/StatusPreference.xml | 78 ++++++++++++++++++++++++++++
 xml/schema/Core/files.xml            |  1 +
 2 files changed, 79 insertions(+)
 create mode 100644 xml/schema/Core/StatusPreference.xml

diff --git a/xml/schema/Core/StatusPreference.xml b/xml/schema/Core/StatusPreference.xml
new file mode 100644
index 0000000000..89ffc98a19
--- /dev/null
+++ b/xml/schema/Core/StatusPreference.xml
@@ -0,0 +1,78 @@
+<?xml version="1.0" encoding="iso-8859-1" ?>
+
+<table>
+  <base>CRM/Core</base>
+  <class>StatusPreference</class>
+  <name>civicrm_status_pref</name>
+  <comment>Preferences controlling status checks called in system.check.</comment>
+  <add>4.7</add>
+  <field>
+    <name>id</name>
+    <type>int unsigned</type>
+    <title>Status Preference ID</title>
+    <required>true</required>
+    <comment>Unique Status Preference ID</comment>
+    <add>4.7</add>
+  </field>
+  <primaryKey>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
+  </primaryKey>
+  <field>
+    <name>domain_id</name>
+    <title>Setting Domain</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <pseudoconstant>
+      <table>civicrm_domain</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>name</labelColumn>
+    </pseudoconstant>
+    <comment>Which Domain is this Status Preference for</comment>
+    <add>4.7</add>
+  </field>
+  <foreignKey>
+    <name>domain_id</name>
+    <table>civicrm_domain</table>
+    <key>id</key>
+    <add>4.7</add>
+  </foreignKey>
+  <field>
+    <name>name</name>
+    <title>Status Preference Name</title>
+    <type>int unsigned</type>
+    <import>true</import>
+    <add>4.7</add>
+  </field>
+  <index>
+    <name>UI_status_pref_name</name>
+    <fieldName>name</fieldName>
+    <unique>true</unique>
+    <add>4.7</add>
+  </index>
+  <field>
+    <name>hush_until</name>
+    <title>Hush Status Notifications Until</title>
+    <type>date</type>
+    <import>true</import>
+    <comment>expires minimum_date_severity.  NULL never hushes.</comment>
+    <default>NULL</default>
+    <add>4.7</add>
+  </field>
+  <field>
+    <name>minimum_report_severity</name>
+    <title>Minimum Report Severity</title>
+    <type>int unsigned</type>
+    <import>true</import>
+    <comment>Hush messages up to but excluding this severity.</comment>
+    <add>4.7</add>
+  </field>
+  <field>
+    <name>prefs</name>
+    <title>Status Preferences</title>
+    <type>varchar</type>
+    <length>255</length>
+    <comment>These settings are per-check, and can't be compared across checks.</comment>
+    <add>4.7</add>
+  </field>
+</table>
diff --git a/xml/schema/Core/files.xml b/xml/schema/Core/files.xml
index aaac22233a..51a0ba7ebe 100644
--- a/xml/schema/Core/files.xml
+++ b/xml/schema/Core/files.xml
@@ -55,4 +55,5 @@
   <xi:include href="PrintLabel.xml"           parse="xml" />
   <xi:include href="WordReplacement.xml"      parse="xml" />
   <xi:include href="RecurringEntity.xml"      parse="xml" />
+  <xi:include href="StatusPreference.xml"     parse="xml" />
 </tables>
-- 
2.25.1