| 
      
            Lines 766-771
          CREATE TABLE `article_requests` (
      
      
        Link Here
      
     | 
  
        
          | 766 | 
            `patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          766 | 
            `patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
        
          | 767 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', | 
          767 | 
            `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', | 
        
        
          | 768 | 
            `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
          768 | 
            `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,  | 
        
            
               | 
               | 
              769 | 
                `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', | 
            
            
              | 770 | 
                `urls` MEDIUMTEXT,  | 
            
        
          | 769 | 
            `created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL',  | 
          771 | 
            `created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL',  | 
        
        
          | 770 | 
            `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),  | 
          772 | 
            `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),  | 
        
        
          | 771 | 
            PRIMARY KEY (`id`),  | 
          773 | 
            PRIMARY KEY (`id`),  | 
        
            
              | 772 | 
              -   | 
               | 
               |