From 28388c8dcef2c0f7313adf22f92e7a20ffbaf84e Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Thu, 12 Jul 2012 09:20:26 -0400 Subject: [PATCH] Bug 6716: Document branch_item_rules 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 3b9827a..4c5edfb 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -316,11 +316,11 @@ CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as -- DROP TABLE IF EXISTS `branch_item_rules`; -CREATE TABLE `branch_item_rules` ( - `branchcode` varchar(10) NOT NULL, - `itemtype` varchar(10) NOT NULL, - `holdallowed` tinyint(1) default NULL, - `returnbranch` varchar(15) default NULL, +CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and fine rules under 'Holds policy by item type' + `branchcode` varchar(10) NOT NULL, -- the branch this rule is for (branches.branchcode) + `itemtype` varchar(10) NOT NULL, -- the item type this rule applies to (items.itype) + `holdallowed` tinyint(1) default NULL, -- the number of holds allowed + `returnbranch` varchar(15) default NULL, -- the branch the item returns to (homebranch, holdingbranch, noreturn) PRIMARY KEY (`itemtype`,`branchcode`), KEY `branch_item_rules_ibfk_2` (`branchcode`), CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) -- 1.7.2.3