killbill-aplcache

Details

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 7ba749e..17e344a 100644
--- a/account/src/main/resources/com/ning/billing/account/ddl.sql
+++ b/account/src/main/resources/com/ning/billing/account/ddl.sql
@@ -3,7 +3,7 @@ CREATE TABLE accounts (
     record_id int(11) unsigned NOT NULL AUTO_INCREMENT,
     id char(36) NOT NULL,
     external_key varchar(128) NULL,
-    email varchar(50) NOT NULL,
+    email varchar(128) NOT NULL,
     name varchar(100) NOT NULL,
     first_name_length int NOT NULL,
     currency char(3) DEFAULT NULL,
@@ -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,
@@ -29,7 +29,6 @@ CREATE TABLE accounts (
 ) ENGINE=innodb;
 CREATE UNIQUE INDEX accounts_id ON accounts(id);
 CREATE UNIQUE INDEX accounts_external_key ON accounts(external_key);
-CREATE UNIQUE INDEX accounts_email ON accounts(email);
 
 DROP TABLE IF EXISTS account_history;
 CREATE TABLE account_history (
@@ -37,7 +36,7 @@ CREATE TABLE account_history (
     record_id int(11) unsigned NOT NULL,
     id char(36) NOT NULL,
     external_key varchar(128) NULL,
-    email varchar(50) NOT NULL,
+    email varchar(128) NOT NULL,
     name varchar(100) NOT NULL,
     first_name_length int NOT NULL,
     currency char(3) DEFAULT NULL,
@@ -51,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,
@@ -67,7 +66,7 @@ CREATE TABLE account_emails (
     record_id int(11) unsigned NOT NULL AUTO_INCREMENT,
     id char(36) NOT NULL,
     account_id char(36) NOT NULL,
-    email varchar(50) NOT NULL,
+    email varchar(128) NOT NULL,
     created_by varchar(50) NOT NULL,
     created_date datetime NOT NULL,
     updated_by varchar(50) NOT NULL,
@@ -83,10 +82,10 @@ CREATE TABLE account_email_history (
     record_id int(11) unsigned NOT NULL,
     id char(36) NOT NULL,
     account_id char(36) NOT NULL,
-    email varchar(50) NOT NULL,
+    email varchar(128) NOT NULL,
     change_type char(6) NOT NULL,
     updated_by varchar(50) NOT NULL,
     date datetime NOT NULL,
     PRIMARY KEY(history_record_id)
 ) ENGINE=innodb;
-CREATE INDEX account_email_record_id ON account_email_history(record_id);
\ No newline at end of file
+CREATE INDEX account_email_record_id ON account_email_history(record_id);