[Koha-patches] [PATCH] Bug 6716 - Cities Table Documentation
Nicole C. Engard
nengard at bywatersolutions.com
Sun Aug 14 23:35:01 CEST 2011
Docmenting the cities table.
Signed-off-by: Nicole C. Engard <nengard at bywatersolutions.com>
---
installer/data/mysql/kohastructure.sql | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index e9edf25..5d71a77 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -523,12 +523,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;
--
1.7.2.3
More information about the Koha-patches
mailing list