From 51c381a30f0e534e753d2d6c7d0e4244fe10937c Mon Sep 17 00:00:00 2001
From: Rob Thorne <rob@torenware.com>
Date: Wed, 29 Apr 2015 16:11:37 +0000
Subject: [PATCH] CRM-16367 (Payment): added FK for created_id field.

---
 xml/schema/Financial/PaymentToken.xml | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

diff --git a/xml/schema/Financial/PaymentToken.xml b/xml/schema/Financial/PaymentToken.xml
index 58168dc2a4..221d7edaa2 100644
--- a/xml/schema/Financial/PaymentToken.xml
+++ b/xml/schema/Financial/PaymentToken.xml
@@ -63,11 +63,17 @@
   </field> 
   <field> 
     <name>created_id</name> 
-    <type>int unsigned</type> 
-    <length>255</length> 
+    <type>int unsigned</type>  
     <comment>Contact ID of token creator</comment> 
     <add>4.7</add> 
   </field> 
+  <foreignKey>
+    <name>created_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>4.7</add>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
   <field> 
     <name>expiry_date</name> 
     <type>datetime</type> 
-- 
2.25.1