View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
Lines 316-326 CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as Link Here
316
--
316
--
317
317
318
DROP TABLE IF EXISTS `branch_item_rules`;
318
DROP TABLE IF EXISTS `branch_item_rules`;
319
CREATE TABLE `branch_item_rules` (
319
CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and fine rules under 'Holds policy by item type'
320
  `branchcode` varchar(10) NOT NULL,
320
  `branchcode` varchar(10) NOT NULL, -- the branch this rule is for (branches.branchcode)
321
  `itemtype` varchar(10) NOT NULL,
321
  `itemtype` varchar(10) NOT NULL, -- the item type this rule applies to (items.itype)
322
  `holdallowed` tinyint(1) default NULL,
322
  `holdallowed` tinyint(1) default NULL, -- the number of holds allowed
323
  `returnbranch` varchar(15) default NULL,
323
  `returnbranch` varchar(15) default NULL, -- the branch the item returns to (homebranch, holdingbranch, noreturn)
324
  PRIMARY KEY  (`itemtype`,`branchcode`),
324
  PRIMARY KEY  (`itemtype`,`branchcode`),
325
  KEY `branch_item_rules_ibfk_2` (`branchcode`),
325
  KEY `branch_item_rules_ibfk_2` (`branchcode`),
326
  CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
326
  CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
327
- 

Return to bug 6716