| 
      
            Lines 3011-3017
          CREATE TABLE `issues` (
      
      
        Link Here
      
     | 
  
        
          | 3011 | 
            `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',  | 
          3011 | 
            `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',  | 
        
        
          | 3012 | 
            `returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues',  | 
          3012 | 
            `returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues',  | 
        
        
          | 3013 | 
            `lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',  | 
          3013 | 
            `lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',  | 
        
          
            
              | 3014 | 
                `renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',  | 
              3014 | 
                `renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',  | 
            
        
          | 3015 | 
            `unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',  | 
          3015 | 
            `unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',  | 
        
        
          | 3016 | 
            `auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal',  | 
          3016 | 
            `auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal',  | 
        
        
          | 3017 | 
            `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error',  | 
          3017 | 
            `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error',  | 
        
  
    | 
      
            Lines 3910-3916
          CREATE TABLE `old_issues` (
      
      
        Link Here
      
     | 
  
        
          | 3910 | 
            `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',  | 
          3910 | 
            `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',  | 
        
        
          | 3911 | 
            `returndate` datetime DEFAULT NULL COMMENT 'date the item was returned',  | 
          3911 | 
            `returndate` datetime DEFAULT NULL COMMENT 'date the item was returned',  | 
        
        
          | 3912 | 
            `lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',  | 
          3912 | 
            `lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',  | 
        
          
            
              | 3913 | 
                `renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',  | 
              3913 | 
                `renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',  | 
            
        
          | 3914 | 
            `unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',  | 
          3914 | 
            `unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',  | 
        
        
          | 3915 | 
            `auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal',  | 
          3915 | 
            `auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal',  | 
        
        
          | 3916 | 
            `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error',  | 
          3916 | 
            `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error',  |