|
Lines 349-355
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rule
Link Here
|
| 349 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
349 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
| 350 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
350 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
| 351 |
`maxonsiteissueqty` int(4) default NULL, -- the maximum number of on-site checkouts this patron category can have at this branch |
351 |
`maxonsiteissueqty` int(4) default NULL, -- the maximum number of on-site checkouts this patron category can have at this branch |
| 352 |
max_holds INT(4) NULL DEFAULT NULL, -- the maximum number of holds a patron may have at a time |
|
|
| 353 |
PRIMARY KEY (`categorycode`, `branchcode`), |
352 |
PRIMARY KEY (`categorycode`, `branchcode`), |
| 354 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
353 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
| 355 |
ON DELETE CASCADE ON UPDATE CASCADE, |
354 |
ON DELETE CASCADE ON UPDATE CASCADE, |
|
Lines 366-372
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found und
Link Here
|
| 366 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
365 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
| 367 |
`maxissueqty` int(4) default NULL, |
366 |
`maxissueqty` int(4) default NULL, |
| 368 |
`maxonsiteissueqty` int(4) default NULL, |
367 |
`maxonsiteissueqty` int(4) default NULL, |
| 369 |
max_holds INT(4) NULL DEFAULT NULL, -- the maximum number of holds a patron may have at a time |
|
|
| 370 |
PRIMARY KEY (`categorycode`), |
368 |
PRIMARY KEY (`categorycode`), |
| 371 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
369 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
| 372 |
ON DELETE CASCADE ON UPDATE CASCADE |
370 |
ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 4233-4240
CREATE TABLE `circulation_rules` (
Link Here
|
| 4233 |
KEY `branchcode` (`branchcode`), |
4231 |
KEY `branchcode` (`branchcode`), |
| 4234 |
KEY `categorycode` (`categorycode`), |
4232 |
KEY `categorycode` (`categorycode`), |
| 4235 |
KEY `itemtype` (`itemtype`), |
4233 |
KEY `itemtype` (`itemtype`), |
| 4236 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`) |
4234 |
KEY `rule_name` (`rule_name`), |
| 4237 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4235 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
|
|
4236 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4238 |
|
4237 |
|
| 4239 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4238 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 4240 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4239 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 4241 |
- |
|
|