Lines 469-478
CREATE TABLE collections_tracking (
Link Here
|
469 |
-- |
469 |
-- |
470 |
|
470 |
|
471 |
DROP TABLE IF EXISTS `branch_borrower_circ_rules`; |
471 |
DROP TABLE IF EXISTS `branch_borrower_circ_rules`; |
472 |
CREATE TABLE `branch_borrower_circ_rules` ( |
472 |
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rules for patron categories found under "Checkout limit by patron category" |
473 |
`branchcode` VARCHAR(10) NOT NULL, |
473 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
474 |
`categorycode` VARCHAR(10) NOT NULL, |
474 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
475 |
`maxissueqty` int(4) default NULL, |
475 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
476 |
PRIMARY KEY (`categorycode`, `branchcode`), |
476 |
PRIMARY KEY (`categorycode`, `branchcode`), |
477 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
477 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
478 |
ON DELETE CASCADE ON UPDATE CASCADE, |
478 |
ON DELETE CASCADE ON UPDATE CASCADE, |
479 |
- |
|
|