From c2e63bd0e9c0e30193bfd397dbd467220945c088 Mon Sep 17 00:00:00 2001
From: Eileen McNaughton <eileen@fuzion.co.nz>
Date: Sun, 27 Apr 2014 11:21:48 -0700
Subject: [PATCH] CRM-14522 remove incorrect FK from message_template schema

---
 xml/schema/Core/MessageTemplate.xml | 10 +---------
 1 file changed, 1 insertion(+), 9 deletions(-)

diff --git a/xml/schema/Core/MessageTemplate.xml b/xml/schema/Core/MessageTemplate.xml
index 312a3a4014..d83bcbc3d7 100644
--- a/xml/schema/Core/MessageTemplate.xml
+++ b/xml/schema/Core/MessageTemplate.xml
@@ -84,18 +84,10 @@
   <field>
       <name>pdf_format_id</name>
       <type>int unsigned</type>
-      <comment>FK to civicrm_option_value containing PDF Page Format.</comment>
+      <comment>a pseudo-FK to civicrm_option_value containing PDF Page Format.</comment>
       <pseudoconstant>
         <optionGroupName>pdf_format</optionGroupName>
-        <keyColumn>id</keyColumn>
       </pseudoconstant>
       <add>3.4</add>
   </field>
-  <foreignKey>
-      <name>pdf_format_id</name>
-      <table>civicrm_option_value</table>
-      <key>id</key>
-      <onDelete>SET NULL</onDelete>
-      <add>3.4</add>
-  </foreignKey>
 </table>
-- 
2.25.1