From 24b3f36b5b13a219837b1205e2e092383c0d7a5f Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 21 Aug 2011 08:44:29 -0400 Subject: [PATCH] Bug 6716 - Definition of the branchcategories table This patch adds field definitions to the branchcategories table. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e51a24bbdc..60047a8028 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -328,11 +328,11 @@ CREATE TABLE `branch_item_rules` ( -- DROP TABLE IF EXISTS `branchcategories`; -CREATE TABLE `branchcategories` ( -- information related to library/branch groups - `categorycode` varchar(10) NOT NULL default '', -- unique key, used to identify the group - `categoryname` varchar(32), -- name used to identify the group - `codedescription` mediumtext, -- description of the group - `categorytype` varchar(16), -- defines if this is a search or properties group +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; -- 2.39.2