Merge pull request #16869 from colemanw/del

[civicrm-core.git] / xml / schema / Contact / SavedSearch.xml

diff --git a/xml/schema/Contact/SavedSearch.xml b/xml/schema/Contact/SavedSearch.xml
index 4da353078754c92a7bce91671b065f332410deac..89f578084b3387200caef35c5c3c652fc5ad54eb 100644 (file)
--- a/xml/schema/Contact/SavedSearch.xml
+++ b/xml/schema/Contact/SavedSearch.xml
@@ -55,6 +55,7 @@
     <name>mapping_id</name>
     <table>civicrm_mapping</table>
     <key>id</key>
+    <onDelete>SET NULL</onDelete>
     <add>1.5</add>
   </foreignKey>
   <field>
@@ -70,6 +71,7 @@
     <title>Where Clause</title>
     <comment>the sql where clause if a saved search acl</comment>
     <add>1.6</add>
+    <drop>5.24</drop>
   </field>
   <field>
     <name>select_tables</name>
@@ -78,6 +80,7 @@
     <comment>the tables to be included in a select data</comment>
     <serialize>PHP</serialize>
     <add>1.6</add>
+    <drop>5.24</drop>
   </field>
   <field>
     <name>where_tables</name>
@@ -86,5 +89,22 @@
     <comment>the tables to be included in the count statement</comment>
     <serialize>PHP</serialize>
     <add>1.6</add>
+    <drop>5.24</drop>
+  </field>
+  <field>
+    <name>api_entity</name>
+    <type>varchar</type>
+    <title>Entity Name</title>
+    <length>255</length>
+    <comment>Entity name for API based search</comment>
+    <add>5.24</add>
+  </field>
+  <field>
+    <name>api_params</name>
+    <type>text</type>
+    <title>API Parameters</title>
+    <comment>Parameters for API based search</comment>
+    <serialize>JSON</serialize>
+    <add>5.24</add>
   </field>
 </table>