From cdfe871d36b7989f5514d468c5394d3884e48e38 Mon Sep 17 00:00:00 2001
From: Adam Roses Wight <awight@wikimedia.org>
Date: Tue, 3 Sep 2013 13:38:00 -0700
Subject: [PATCH] CRM-13326: email can be up to 254 characters long

In accordance with current IETF recommendations.  For a good overview, see
http://en.wikipedia.org/wiki/Email_address
---
 CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl | 3 +++
 xml/schema/Core/Email.xml                       | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
index c04c39ee46..d08e51fe12 100644
--- a/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
@@ -4,3 +4,6 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
 (NULL, 1229, "FL", "Florida"),
 (NULL, 1229, "RN", "Rio Negro"),
 (NULL, 1229, "SJ", "San Jose");
+
+ALTER TABLE civicrm_email
+MODIFY email VARCHAR(254);
diff --git a/xml/schema/Core/Email.xml b/xml/schema/Core/Email.xml
index ad37f4dcb9..c7857c66c0 100644
--- a/xml/schema/Core/Email.xml
+++ b/xml/schema/Core/Email.xml
@@ -51,7 +51,7 @@
   <field>
        <name>email</name>
        <type>varchar</type>
-       <length>64</length>
+       <length>254</length>
        <size>MEDIUM</size>
        <import>true</import>
        <headerPattern>/e.?mail/i</headerPattern>
-- 
2.25.1