From 07ec1afa970db753581a5c975aeb76588b1b27ba Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Thu, 7 Apr 2011 11:41:33 +0200 Subject: [PATCH] Bug 5422: Add missing fields to deletedborrowers and change datatype to text Signed-off-by: Magnus Enger Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 478afd61e4..8a17bace36 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -206,7 +206,7 @@ CREATE TABLE `borrowers` ( `address` mediumtext NOT NULL, `address2` text, `city` mediumtext NOT NULL, - `state` mediumtext default NULL, + `state` text default NULL, `zipcode` varchar(25) default NULL, `country` text, `email` mediumtext, @@ -220,7 +220,7 @@ CREATE TABLE `borrowers` ( `B_address` varchar(100) default NULL, `B_address2` text default NULL, `B_city` mediumtext, - `B_state` mediumtext default NULL, + `B_state` text default NULL, `B_zipcode` varchar(25) default NULL, `B_country` text, `B_email` text, @@ -254,7 +254,7 @@ CREATE TABLE `borrowers` ( `altcontactaddress1` varchar(255) default NULL, `altcontactaddress2` varchar(255) default NULL, `altcontactaddress3` varchar(255) default NULL, - `altcontactstate` mediumtext default NULL, + `altcontactstate` text default NULL, `altcontactzipcode` varchar(50) default NULL, `altcontactcountry` text default NULL, `altcontactphone` varchar(50) default NULL, @@ -657,6 +657,7 @@ CREATE TABLE `deletedborrowers` ( `address` mediumtext NOT NULL, `address2` text, `city` mediumtext NOT NULL, + `state` text default NULL, `zipcode` varchar(25) default NULL, `country` text, `email` mediumtext, @@ -670,6 +671,7 @@ CREATE TABLE `deletedborrowers` ( `B_address` varchar(100) default NULL, `B_address2` text default NULL, `B_city` mediumtext, + `B_state` text default NULL, `B_zipcode` varchar(25) default NULL, `B_country` text, `B_email` text, @@ -703,6 +705,7 @@ CREATE TABLE `deletedborrowers` ( `altcontactaddress1` varchar(255) default NULL, `altcontactaddress2` varchar(255) default NULL, `altcontactaddress3` varchar(255) default NULL, + `altcontactstate` text default NULL, `altcontactzipcode` varchar(50) default NULL, `altcontactcountry` text default NULL, `altcontactphone` varchar(50) default NULL, -- 2.11.4.GIT