From 707d5a5e68d00849a1a3b286e1b750e69a3ed55b Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Fri, 13 Jul 2012 12:12:22 -0400 Subject: [PATCH] Bug 6716: Document branch_borrower_circ_rules table --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index bcf24e55aa..12e99ba431 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -469,10 +469,10 @@ CREATE TABLE collections_tracking ( -- DROP TABLE IF EXISTS `branch_borrower_circ_rules`; -CREATE TABLE `branch_borrower_circ_rules` ( - `branchcode` VARCHAR(10) NOT NULL, - `categorycode` VARCHAR(10) NOT NULL, - `maxissueqty` int(4) default NULL, +CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rules for patron categories found under "Checkout limit by patron category" + `branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) + `categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) + `maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch PRIMARY KEY (`categorycode`, `branchcode`), CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, -- 2.39.5