| 
      
            Lines 4078-4083
          CREATE TABLE `article_requests` (
      
      
        Link Here
      
     | 
  
        
          | 4078 | 
            `patron_notes` MEDIUMTEXT,  | 
          4078 | 
            `patron_notes` MEDIUMTEXT,  | 
        
        
          | 4079 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', | 
          4079 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', | 
        
        
          | 4080 | 
            `notes` MEDIUMTEXT,  | 
          4080 | 
            `notes` MEDIUMTEXT,  | 
        
            
               | 
               | 
              4081 | 
                `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', | 
            
            
              | 4082 | 
                `urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons  | 
            
        
          | 4081 | 
            `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL  | 
          4083 | 
            `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL  | 
        
        
          | 4082 | 
            `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
          4084 | 
            `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  | 
        
        
          | 4083 | 
            PRIMARY KEY (`id`),  | 
          4085 | 
            PRIMARY KEY (`id`),  | 
        
            
              | 4084 | 
              -   | 
               | 
               |