Lines 632-637
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rule
Link Here
|
632 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
632 |
`branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode) |
633 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
633 |
`categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode) |
634 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
634 |
`maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch |
|
|
635 |
`maxonsiteissueqty` int(4) default NULL, -- the maximum number of on-site checkouts this patron category can have at this branch |
635 |
PRIMARY KEY (`categorycode`, `branchcode`), |
636 |
PRIMARY KEY (`categorycode`, `branchcode`), |
636 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
637 |
CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
637 |
ON DELETE CASCADE ON UPDATE CASCADE, |
638 |
ON DELETE CASCADE ON UPDATE CASCADE, |
Lines 647-652
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
Link Here
|
647 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
648 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
648 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
649 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
649 |
`maxissueqty` int(4) default NULL, |
650 |
`maxissueqty` int(4) default NULL, |
|
|
651 |
`maxonsiteissueqty` int(4) default NULL, |
650 |
PRIMARY KEY (`categorycode`), |
652 |
PRIMARY KEY (`categorycode`), |
651 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
653 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
652 |
ON DELETE CASCADE ON UPDATE CASCADE |
654 |
ON DELETE CASCADE ON UPDATE CASCADE |
Lines 660-665
DROP TABLE IF EXISTS `default_branch_circ_rules`;
Link Here
|
660 |
CREATE TABLE `default_branch_circ_rules` ( |
662 |
CREATE TABLE `default_branch_circ_rules` ( |
661 |
`branchcode` VARCHAR(10) NOT NULL, |
663 |
`branchcode` VARCHAR(10) NOT NULL, |
662 |
`maxissueqty` int(4) default NULL, |
664 |
`maxissueqty` int(4) default NULL, |
|
|
665 |
`maxonsiteissueqty` int(4) default NULL, |
663 |
`holdallowed` tinyint(1) default NULL, |
666 |
`holdallowed` tinyint(1) default NULL, |
664 |
`returnbranch` varchar(15) default NULL, |
667 |
`returnbranch` varchar(15) default NULL, |
665 |
PRIMARY KEY (`branchcode`), |
668 |
PRIMARY KEY (`branchcode`), |
Lines 688-693
DROP TABLE IF EXISTS `default_circ_rules`;
Link Here
|
688 |
CREATE TABLE `default_circ_rules` ( |
691 |
CREATE TABLE `default_circ_rules` ( |
689 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
692 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
690 |
`maxissueqty` int(4) default NULL, |
693 |
`maxissueqty` int(4) default NULL, |
|
|
694 |
`maxonsiteissueqty` int(4) default NULL, |
691 |
`holdallowed` int(1) default NULL, |
695 |
`holdallowed` int(1) default NULL, |
692 |
`returnbranch` varchar(15) default NULL, |
696 |
`returnbranch` varchar(15) default NULL, |
693 |
PRIMARY KEY (`singleton`) |
697 |
PRIMARY KEY (`singleton`) |
Lines 1182-1187
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
1182 |
`accountsent` int(11) default NULL, -- not used? always NULL |
1186 |
`accountsent` int(11) default NULL, -- not used? always NULL |
1183 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
1187 |
`chargename` varchar(100) default NULL, -- not used? always NULL |
1184 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
1188 |
`maxissueqty` int(4) default NULL, -- total number of checkouts allowed |
|
|
1189 |
`maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed |
1185 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
1190 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
1186 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
1191 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
1187 |
`hardduedate` date default NULL, -- hard due date |
1192 |
`hardduedate` date default NULL, -- hard due date |