From c521918544529ad184490ad082783d25b704f0bf Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Tue, 3 May 2016 15:13:02 +1200
Subject: [PATCH] CRM-17118 extend civicrm_address postal_code to accept full
 data strings from paypal etc.

---
 CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl | 4 ++++
 xml/schema/Core/Address.xml                 | 2 +-
 2 files changed, 5 insertions(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl
index 4f54df1002..641b3335b7 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl
@@ -5,3 +5,7 @@ ALTER TABLE `civicrm_contact` CHANGE `image_URL` `image_URL` VARCHAR(512) CHARAC
 
 -- CRM-18537
 DELETE FROM civicrm_state_province WHERE name = 'Fernando de Noronha';
+
+-- CRM-17118 extend civicrm_address postal_code to accept full data strings from paypal etc.
+ALTER TABLE civicrm_address CHANGE `postal_code` `postal_code` varchar(64) ;
+
diff --git a/xml/schema/Core/Address.xml b/xml/schema/Core/Address.xml
index 028b4bed3e..2af1739845 100644
--- a/xml/schema/Core/Address.xml
+++ b/xml/schema/Core/Address.xml
@@ -317,7 +317,7 @@
     <name>postal_code</name>
     <title>Postal Code</title>
     <type>varchar</type>
-    <length>12</length>
+    <length>64</length>
     <import>true</import>
     <headerPattern>/postal|zip/i</headerPattern>
     <dataPattern>/\d?\d{4}(-\d{4})?/</dataPattern>
-- 
2.25.1