From f6f6476ecd9bbcbed27c17391fb134e62e443f0c Mon Sep 17 00:00:00 2001
From: Sunil Pawar <sunil@cividesk.com>
Date: Tue, 17 Jul 2018 11:07:09 +1200
Subject: [PATCH] dev/core#230 : set mapping id null on delete action

---
 CRM/Contact/DAO/SavedSearch.php    | 2 +-
 xml/schema/Contact/SavedSearch.xml | 1 +
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/CRM/Contact/DAO/SavedSearch.php b/CRM/Contact/DAO/SavedSearch.php
index 97ecac5207..91db5b3474 100644
--- a/CRM/Contact/DAO/SavedSearch.php
+++ b/CRM/Contact/DAO/SavedSearch.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Contact/SavedSearch.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:0341555885ddaf5dbc8e4d6cfe1d899c)
+ * (GenCodeChecksum:4b183aa40bb90cc7c715034178104a11)
  */
 
 /**
diff --git a/xml/schema/Contact/SavedSearch.xml b/xml/schema/Contact/SavedSearch.xml
index 4da3530787..e8b7dbd2d1 100644
--- 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>
-- 
2.25.1