| 
      
            Lines 1191-1196
          CREATE TABLE `issuingrules` ( -- circulation and fine rules
      
      
        Link Here
      
     | 
  
        
          | 1191 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
          1191 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
        
        
          | 1192 | 
            onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf  | 
          1192 | 
            onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf  | 
        
        
          | 1193 | 
            opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold  | 
          1193 | 
            opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold  | 
        
            
               | 
               | 
              1194 | 
                article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, | 
            
        
          | 1194 | 
            PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),  | 
          1195 | 
            PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),  | 
        
        
          | 1195 | 
            KEY `categorycode` (`categorycode`),  | 
          1196 | 
            KEY `categorycode` (`categorycode`),  | 
        
        
          | 1196 | 
            KEY `itemtype` (`itemtype`)  | 
          1197 | 
            KEY `itemtype` (`itemtype`)  | 
        
  
    | 
      
            Lines 3613-3619
          CREATE TABLE `article_requests` (
      
      
        Link Here
      
     | 
  
        
          | 3613 | 
            `date` text,  | 
          3614 | 
            `date` text,  | 
        
        
          | 3614 | 
            `pages` text,  | 
          3615 | 
            `pages` text,  | 
        
        
          | 3615 | 
            `chapters` text,  | 
          3616 | 
            `chapters` text,  | 
        
          
            
              | 3616 | 
                `status` enum('OPEN','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'OPEN', | 
              3617 | 
                `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', | 
            
        
          | 3617 | 
            `notes` text,  | 
          3618 | 
            `notes` text,  | 
        
        
          | 3618 | 
            `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
          3619 | 
            `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
        
        
          | 3619 | 
            `updated_on` timestamp NULL DEFAULT NULL,  | 
          3620 | 
            `updated_on` timestamp NULL DEFAULT NULL,  | 
        
            
              | 3620 | 
              -   | 
               | 
               |