| 
      
            Lines 1123-1128
          CREATE TABLE `issues` ( -- information related to check outs or issues
      
      
        Link Here
      
     | 
  
        
          | 1123 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
          1123 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
        
        
          | 1124 | 
            `return` varchar(4) default NULL,  | 
          1124 | 
            `return` varchar(4) default NULL,  | 
        
        
          | 1125 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
          1125 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
        
            
               | 
               | 
              1126 | 
                `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
            
        
          | 1126 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1127 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
        
          | 1127 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
          1128 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
        
        
          | 1128 | 
            KEY `issuesborridx` (`borrowernumber`),  | 
          1129 | 
            KEY `issuesborridx` (`borrowernumber`),  | 
        
  
    | 
      
            Lines 1160-1165
          CREATE TABLE `issuingrules` ( -- circulation and fine rules
      
      
        Link Here
      
     | 
  
        
          | 1160 | 
            `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed  | 
          1161 | 
            `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed  | 
        
        
          | 1161 | 
            `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit  | 
          1162 | 
            `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit  | 
        
        
          | 1162 | 
            `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit  | 
          1163 | 
            `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit  | 
        
            
               | 
               | 
              1164 | 
                `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
            
        
          | 1163 | 
            `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed  | 
          1165 | 
            `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed  | 
        
        
          | 1164 | 
            `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)  | 
          1166 | 
            `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)  | 
        
        
          | 1165 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
          1167 | 
            overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine  | 
        
  
    | 
      
            Lines 1594-1599
          CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
      
      
        Link Here
      
     | 
  
        
          | 1594 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
          1596 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
        
        
          | 1595 | 
            `return` varchar(4) default NULL,  | 
          1597 | 
            `return` varchar(4) default NULL,  | 
        
        
          | 1596 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
          1598 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
        
            
               | 
               | 
              1599 | 
                `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
            
        
          | 1597 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1600 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
        
          | 1598 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
          1601 | 
            `issuedate` datetime default NULL, -- date the item was checked out or issued  | 
        
        
          | 1599 | 
            KEY `old_issuesborridx` (`borrowernumber`),  | 
          1602 | 
            KEY `old_issuesborridx` (`borrowernumber`),  |