| 
      
            Lines 1741-1747
          CREATE TABLE `issues` ( -- information related to check outs or issues
      
      
        Link Here
      
     | 
  
        
          | 1741 | 
            `branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out  | 
          1741 | 
            `branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out  | 
        
        
          | 1742 | 
            `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues  | 
          1742 | 
            `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues  | 
        
        
          | 1743 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
          1743 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
        
            
              | 1744 | 
                `return` varchar(4) default NULL,  | 
               | 
               | 
            
        
          | 1745 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
          1744 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
        
        
          | 1746 | 
            `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
          1745 | 
            `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
        
        
          | 1747 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1746 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
  
    | 
      
            Lines 1770-1776
          CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
      
      
        Link Here
      
     | 
  
        
          | 1770 | 
            `branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out  | 
          1769 | 
            `branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out  | 
        
        
          | 1771 | 
            `returndate` datetime default NULL, -- date the item was returned  | 
          1770 | 
            `returndate` datetime default NULL, -- date the item was returned  | 
        
        
          | 1772 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
          1771 | 
            `lastreneweddate` datetime default NULL, -- date the item was last renewed  | 
        
            
              | 1773 | 
                `return` varchar(4) default NULL,  | 
               | 
               | 
            
        
          | 1774 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
          1772 | 
            `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed  | 
        
        
          | 1775 | 
            `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
          1773 | 
            `auto_renew` BOOLEAN default FALSE, -- automatic renewal  | 
        
        
          | 1776 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
          1774 | 
            `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched  | 
        
            
              | 1777 | 
              -   | 
               | 
               |