From 522fecb6c562f0f85258745e5f3b774d7cbedd2a Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 14 Aug 2011 17:34:29 -0400 Subject: [PATCH] Bug 6716 - Cities Table Documentation Docmenting the cities table. Signed-off-by: Nicole C. Engard Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6ff8e8d5f9..156fe60ace 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -529,12 +529,12 @@ CREATE TABLE `default_circ_rules` ( -- 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, +CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choose when adding/editing a patron/borrower + `cityid` int(11) NOT NULL auto_increment, -- unique identifier added by Koha + `city_name` varchar(100) NOT NULL default '', -- name of the city + `city_state` VARCHAR( 100 ) NULL DEFAULT NULL, -- name of the state/province + `city_country` VARCHAR( 100 ) NULL DEFAULT NULL, -- name of the country + `city_zipcode` varchar(20) default NULL, -- zip or postal code PRIMARY KEY (`cityid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2