From 99e30afad49dafcc3ab928ff879952228d7f125d Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Wed, 3 Aug 2011 16:43:47 +0200 Subject: [PATCH 2/3] Bug 5433 follow up - kohastructure.sql missing The 2 fields added by the updatedatabase were not in the kohastructure.sql Signed-off-by: Paul Poulain --- installer/data/mysql/kohastructure.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e3c6f42..e9edf25 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -526,6 +526,8 @@ DROP TABLE IF EXISTS `cities`; CREATE TABLE `cities` ( `cityid` int(11) NOT NULL auto_increment, `city_name` varchar(100) NOT NULL default '', + `city_state` VARCHAR( 100 ) NULL DEFAULT NULL, + `city_country` VARCHAR( 100 ) NULL DEFAULT NULL, `city_zipcode` varchar(20) default NULL, PRIMARY KEY (`cityid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 1.7.4.1