From 8a8654ffef79f148fde79381cf09fe4e83e05825 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 14 Aug 2011 14:08:00 -0400 Subject: [PATCH] Bug 6716 - Branch table documentation Documenting the branches table in Koha. Two unused fields noted, please update if they are in fact used. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 36 +++++++++++++------------- 1 file changed, 18 insertions(+), 18 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 03efc4e5b5..8ac38618d8 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -337,24 +337,24 @@ CREATE TABLE `branchcategories` ( -- DROP TABLE IF EXISTS `branches`; -CREATE TABLE `branches` ( - `branchcode` varchar(10) NOT NULL default '', - `branchname` mediumtext NOT NULL, - `branchaddress1` mediumtext, - `branchaddress2` mediumtext, - `branchaddress3` mediumtext, - `branchzip` varchar(25) default NULL, - `branchcity` mediumtext, - `branchstate` mediumtext, - `branchcountry` text, - `branchphone` mediumtext, - `branchfax` mediumtext, - `branchemail` mediumtext, - `branchurl` mediumtext, - `issuing` tinyint(4) default NULL, - `branchip` varchar(15) default NULL, - `branchprinter` varchar(100) default NULL, - `branchnotes` mediumtext, +CREATE TABLE `branches` ( -- information about your libraries or branches are stored here + `branchcode` varchar(10) NOT NULL default '', -- a unique key assigned to each branch + `branchname` mediumtext NOT NULL, -- the name of your library or branch + `branchaddress1` mediumtext, -- the first address line of for your library or branch + `branchaddress2` mediumtext, -- the second address line of for your library or branch + `branchaddress3` mediumtext, -- the third address line of for your library or branch + `branchzip` varchar(25) default NULL, -- the zip or postal code for your library or branch + `branchcity` mediumtext, -- the city or province for your library or branch + `branchstate` mediumtext, -- the state for your library or branch + `branchcountry` text, -- the county for your library or branch + `branchphone` mediumtext, -- the primary phone for your library or branch + `branchfax` mediumtext, -- the fax number for your library or branch + `branchemail` mediumtext, -- the primary email address for your library or branch + `branchurl` mediumtext, -- the URL for your library or branch's website + `issuing` tinyint(4) default NULL, --unused in Koha + `branchip` varchar(15) default NULL, -- the IP address for your library or branch + `branchprinter` varchar(100) default NULL, -- unused in Koha + `branchnotes` mediumtext, -- notes related to your library or branch UNIQUE KEY `branchcode` (`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.20.1