| 
      
            Lines 4063-4068
          CREATE TABLE `article_requests` (
      
      
        Link Here
      
     | 
  
        
          | 4063 | 
            `patron_notes` MEDIUMTEXT,  | 
          4063 | 
            `patron_notes` MEDIUMTEXT,  | 
        
        
          | 4064 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', | 
          4064 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', | 
        
        
          | 4065 | 
            `notes` MEDIUMTEXT,  | 
          4065 | 
            `notes` MEDIUMTEXT,  | 
        
            
               | 
               | 
              4066 | 
                `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', | 
            
            
              | 4067 | 
                `urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons  | 
            
        
          | 4066 | 
            `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL  | 
          4068 | 
            `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL  | 
        
        
          | 4067 | 
            `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
          4069 | 
            `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
        
        
          | 4068 | 
            PRIMARY KEY (`id`),  | 
          4070 | 
            PRIMARY KEY (`id`),  | 
        
            
              | 4069 | 
              -   | 
               | 
               |