[Koha-patches] [PATCH] Bug 6716: Document branch_item_rules table
Nicole C. Engard
nengard at bywatersolutions.com
Thu Jul 12 15:20:40 CEST 2012
---
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
More information about the Koha-patches
mailing list