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 |
- |
|
|