From 5d515eaa1c465c5efe119448fec4c951b7629684 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Wed, 3 Aug 2011 16:43:47 +0200 Subject: [PATCH] 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 Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e3c6f42a76..e9edf25419 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; -- 2.20.1