| 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 |