[Koha-patches] [PATCH] Bug 6716 - Definition of the branchcategories table
Nicole C. Engard
nengard at bywatersolutions.com
Sun Aug 21 14:45:09 CEST 2011
This patch adds field definitions to the branchcategories
table.
---
installer/data/mysql/kohastructure.sql | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 8b84019..b99c0ab 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -324,11 +324,11 @@ CREATE TABLE `branch_item_rules` (
--
DROP TABLE IF EXISTS `branchcategories`;
-CREATE TABLE `branchcategories` (
- `categorycode` varchar(10) NOT NULL default '',
- `categoryname` varchar(32),
- `codedescription` mediumtext,
- `categorytype` varchar(16),
+CREATE TABLE `branchcategories` ( -- information related to library/branch groups
+ `categorycode` varchar(10) NOT NULL default '', -- unique identifier for the library/branch group
+ `categoryname` varchar(32), -- name of the library/branch group
+ `codedescription` mediumtext, -- longer description of the library/branch group
+ `categorytype` varchar(16), -- says whether this is a search group or a properties group
PRIMARY KEY (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
1.7.2.3
More information about the Koha-patches
mailing list