Lines 634-639
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rule
Link Here
|
634 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
634 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
635 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
635 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
636 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
636 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
|
|
637 |
`maxonsiteissueqty` int(4) default NULL, -- the maximum number of on-site checkouts this patron category can have at this branch |
637 |
PRIMARY KEY (`categorycode`, `branchcode`), |
638 |
PRIMARY KEY (`categorycode`, `branchcode`), |
638 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
639 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
639 |
ON DELETE CASCADE ON UPDATE CASCADE, |
640 |
ON DELETE CASCADE ON UPDATE CASCADE, |
Lines 649-654
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
Link Here
|
649 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
650 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
650 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
651 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
651 |
`maxissueqty` int(4) default NULL, |
652 |
`maxissueqty` int(4) default NULL, |
|
|
653 |
`maxonsiteissueqty` int(4) default NULL, |
652 |
PRIMARY KEY (`categorycode`), |
654 |
PRIMARY KEY (`categorycode`), |
653 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
655 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
654 |
ON DELETE CASCADE ON UPDATE CASCADE |
656 |
ON DELETE CASCADE ON UPDATE CASCADE |
Lines 662-667
DROP TABLE IF EXISTS `default_branch_circ_rules`;
Link Here
|
662 |
CREATE TABLE `default_branch_circ_rules` ( |
664 |
CREATE TABLE `default_branch_circ_rules` ( |
663 |
`branchcode` VARCHAR(10) NOT NULL, |
665 |
`branchcode` VARCHAR(10) NOT NULL, |
664 |
`maxissueqty` int(4) default NULL, |
666 |
`maxissueqty` int(4) default NULL, |
|
|
667 |
`maxonsiteissueqty` int(4) default NULL, |
665 |
`holdallowed` tinyint(1) default NULL, |
668 |
`holdallowed` tinyint(1) default NULL, |
666 |
`returnbranch` varchar(15) default NULL, |
669 |
`returnbranch` varchar(15) default NULL, |
667 |
PRIMARY KEY (`branchcode`), |
670 |
PRIMARY KEY (`branchcode`), |
Lines 690-695
DROP TABLE IF EXISTS `default_circ_rules`;
Link Here
|
690 |
CREATE TABLE `default_circ_rules` ( |
693 |
CREATE TABLE `default_circ_rules` ( |
691 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
694 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
692 |
`maxissueqty` int(4) default NULL, |
695 |
`maxissueqty` int(4) default NULL, |
|
|
696 |
`maxonsiteissueqty` int(4) default NULL, |
693 |
`holdallowed` int(1) default NULL, |
697 |
`holdallowed` int(1) default NULL, |
694 |
`returnbranch` varchar(15) default NULL, |
698 |
`returnbranch` varchar(15) default NULL, |
695 |
PRIMARY KEY (`singleton`) |
699 |
PRIMARY KEY (`singleton`) |
Lines 1171-1176
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
1171 |
`accountsent` int(11) default NULL, -- not used? always NULL |
1175 |
`accountsent` int(11) default NULL, -- not used? always NULL |
1172 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
1176 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
1173 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
1177 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
|
|
1178 |
`maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed |
1174 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
1179 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
1175 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
1180 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
1176 |
`hardduedate` date default NULL, -- hard due date |
1181 |
`hardduedate` date default NULL, -- hard due date |