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