|
Lines 636-641
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rule
Link Here
|
| 636 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
636 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
| 637 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
637 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
| 638 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
638 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
|
|
639 |
`maxonsiteissueqty` int(4) default NULL, -- the maximum number of on-site checkouts this patron category can have at this branch |
| 639 |
PRIMARY KEY (`categorycode`, `branchcode`), |
640 |
PRIMARY KEY (`categorycode`, `branchcode`), |
| 640 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
641 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
| 641 |
ON DELETE CASCADE ON UPDATE CASCADE, |
642 |
ON DELETE CASCADE ON UPDATE CASCADE, |
|
Lines 651-656
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
Link Here
|
| 651 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
652 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
| 652 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
653 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
| 653 |
`maxissueqty` int(4) default NULL, |
654 |
`maxissueqty` int(4) default NULL, |
|
|
655 |
`maxonsiteissueqty` int(4) default NULL, |
| 654 |
PRIMARY KEY (`categorycode`), |
656 |
PRIMARY KEY (`categorycode`), |
| 655 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
657 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
| 656 |
ON DELETE CASCADE ON UPDATE CASCADE |
658 |
ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 664-669
DROP TABLE IF EXISTS `default_branch_circ_rules`;
Link Here
|
| 664 |
CREATE TABLE `default_branch_circ_rules` ( |
666 |
CREATE TABLE `default_branch_circ_rules` ( |
| 665 |
`branchcode` VARCHAR(10) NOT NULL, |
667 |
`branchcode` VARCHAR(10) NOT NULL, |
| 666 |
`maxissueqty` int(4) default NULL, |
668 |
`maxissueqty` int(4) default NULL, |
|
|
669 |
`maxonsiteissueqty` int(4) default NULL, |
| 667 |
`holdallowed` tinyint(1) default NULL, |
670 |
`holdallowed` tinyint(1) default NULL, |
| 668 |
`returnbranch` varchar(15) default NULL, |
671 |
`returnbranch` varchar(15) default NULL, |
| 669 |
PRIMARY KEY (`branchcode`), |
672 |
PRIMARY KEY (`branchcode`), |
|
Lines 692-697
DROP TABLE IF EXISTS `default_circ_rules`;
Link Here
|
| 692 |
CREATE TABLE `default_circ_rules` ( |
695 |
CREATE TABLE `default_circ_rules` ( |
| 693 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
696 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
| 694 |
`maxissueqty` int(4) default NULL, |
697 |
`maxissueqty` int(4) default NULL, |
|
|
698 |
`maxonsiteissueqty` int(4) default NULL, |
| 695 |
`holdallowed` int(1) default NULL, |
699 |
`holdallowed` int(1) default NULL, |
| 696 |
`returnbranch` varchar(15) default NULL, |
700 |
`returnbranch` varchar(15) default NULL, |
| 697 |
PRIMARY KEY (`singleton`) |
701 |
PRIMARY KEY (`singleton`) |
|
Lines 1186-1191
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
| 1186 |
`accountsent` int(11) default NULL, -- not used? always NULL |
1190 |
`accountsent` int(11) default NULL, -- not used? always NULL |
| 1187 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
1191 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
| 1188 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
1192 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
|
|
1193 |
`maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed |
| 1189 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
1194 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
| 1190 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
1195 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
| 1191 |
`hardduedate` date default NULL, -- hard due date |
1196 |
`hardduedate` date default NULL, -- hard due date |