From d6465502bddd72af16fa90a55cb30f3855c08e41 Mon Sep 17 00:00:00 2001
From: Adam Roses Wight <awight@wikimedia.org>
Date: Fri, 2 May 2014 13:43:09 -0700
Subject: [PATCH] Prevent delete cascade from case_type to case

CRM-14473: Migrate case-types from OptionGroup to new table
---
 CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 3 ++-
 xml/schema/Case/Case.xml                         | 3 +--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
index 51e9437a03..248af82c27 100644
--- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
@@ -349,7 +349,8 @@ UPDATE civicrm_case
   );
 
 ALTER TABLE civicrm_case
-  MODIFY case_type_id int(10) unsigned COLLATE utf8_unicode_ci NOT NULL COMMENT 'FK to civicrm_case_type.name';
+  MODIFY case_type_id int(10) unsigned COLLATE utf8_unicode_ci NULL COMMENT 'FK to civicrm_case_type.id',
+  ADD CONSTRAINT FK_civicrm_case_case_type_id FOREIGN KEY (case_type_id) REFERENCES civicrm_case_type (id) ON DELETE SET NULL;
 
 DELETE FROM civicrm_option_value WHERE option_group_id = @option_group_id_case_type;
 
diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml
index 71d2a1de93..53867e4a1b 100644
--- a/xml/schema/Case/Case.xml
+++ b/xml/schema/Case/Case.xml
@@ -40,7 +40,6 @@
   <field>
        <name>case_type_id</name>
        <type>int unsigned</type>
-       <required>true</required>
        <import>true</import>
        <export>false</export>
        <title>Case Type</title>
@@ -60,7 +59,7 @@
        <table>civicrm_case_type</table>
        <key>id</key>
        <add>4.5</add>
-       <onDelete>CASCADE</onDelete>
+       <onDelete>SET NULL</onDelete>
   </foreignKey>
   <field>
        <name>casetag1_id</name>
-- 
2.25.1