killbill-aplcache

RI-1461 Increase size of email postal_code columns

7/13/2012 7:11:52 PM

Kevin Postlewaite

Commit: 927a5bb

Tree: 66cfa18

Parents: 2b05067

Changes

account/src/main/resources/com/ning/billing/account/ddl.sql 4(+2 -2)

Details

account/src/main/resources/com/ning/billing/account/ddl.sql 4(+2 -2)

diff --git a/account/src/main/resources/com/ning/billing/account/ddl.sql b/account/src/main/resources/com/ning/billing/account/ddl.sql
index 5848b8f..17e344a 100644
--- a/account/src/main/resources/com/ning/billing/account/ddl.sql
+++ b/account/src/main/resources/com/ning/billing/account/ddl.sql
@@ -17,7 +17,7 @@ CREATE TABLE accounts (
     city varchar(50) DEFAULT NULL,
     state_or_province varchar(50) DEFAULT NULL,
     country varchar(50) DEFAULT NULL,
-    postal_code varchar(11) DEFAULT NULL,
+    postal_code varchar(16) DEFAULT NULL,
     phone varchar(25) DEFAULT NULL,
     migrated bool DEFAULT false,
     is_notified_for_invoices boolean NOT NULL,
@@ -50,7 +50,7 @@ CREATE TABLE account_history (
     city varchar(50) DEFAULT NULL,
     state_or_province varchar(50) DEFAULT NULL,
     country varchar(50) DEFAULT NULL,
-    postal_code varchar(11) DEFAULT NULL,
+    postal_code varchar(16) DEFAULT NULL,
     phone varchar(25) DEFAULT NULL,
     migrated bool DEFAULT false,
     is_notified_for_invoices boolean NOT NULL,