| 
      
            Lines 884-889
          CREATE TABLE `issuingrules` ( -- circulation and fine rules
      
      
        Link Here
      
     | 
  
        
          | 884 | 
            `no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date  | 
          884 | 
            `no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date  | 
        
        
          | 885 | 
            `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed  | 
          885 | 
            `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed  | 
        
        
          | 886 | 
            `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib  | 
          886 | 
            `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib  | 
        
            
               | 
               | 
              887 | 
                `holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day  | 
            
        
          | 887 | 
            `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)  | 
          888 | 
            `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)  | 
        
        
          | 888 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
          889 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
        
        
          | 889 | 
            cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price  | 
          890 | 
            cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price  | 
        
  
    | 
      
            Lines 1897-1903
          DROP TABLE IF EXISTS `reserves`;
      
      
        Link Here
      
     | 
  
        
          | 1897 | 
          CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha  | 
          1898 | 
          CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha  | 
        
        
          | 1898 | 
            `reserve_id` int(11) NOT NULL auto_increment, -- primary key  | 
          1899 | 
            `reserve_id` int(11) NOT NULL auto_increment, -- primary key  | 
        
        
          | 1899 | 
            `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for  | 
          1900 | 
            `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for  | 
        
          
            
              | 1900 | 
                `reservedate` date default NULL, -- the date the hold was places  | 
              1901 | 
                `reservedate` date default NULL, -- the date the hold was placed  | 
            
        
          | 1901 | 
            `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on  | 
          1902 | 
            `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on  | 
        
        
          | 1902 | 
            `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at  | 
          1903 | 
            `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at  | 
        
        
          | 1903 | 
            `notificationdate` date default NULL, -- currently unused  | 
          1904 | 
            `notificationdate` date default NULL, -- currently unused  | 
        
            
              | 1904 | 
              -   | 
               | 
               |