From f52965559b581d0e435a59061441f11e8c495f42 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 21 Aug 2011 08:47:05 -0400 Subject: [PATCH] Bug 6716: DB Documentation for the branchrelations table Documents the branchrelations table. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 60047a8028..370a2a4269 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -367,9 +367,9 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st -- DROP TABLE IF EXISTS `branchrelations`; -CREATE TABLE `branchrelations` ( -- tracks which libraries/branches are in each library/branch group - `branchcode` varchar(10) NOT NULL default '', -- foreign key linking to the branches table - `categorycode` varchar(10) NOT NULL default '', -- foreign key linking to the branchcategories table +CREATE TABLE `branchrelations` ( -- this table links libraries/branches to groups + `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table to identify the branch + `categorycode` varchar(10) NOT NULL default '', -- foreign key from the branchcategories table to identify the group PRIMARY KEY (`branchcode`,`categorycode`), KEY `branchcode` (`branchcode`), KEY `categorycode` (`categorycode`), -- 2.20.1