| Lines 3301-3306
          CREATE TABLE `illrequestattributes` (
      
      
        Link Here | 
        
          | 3301 |   CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE | 3301 |   CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE | 
        
          | 3302 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 3302 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 3303 | /*!40101 SET character_set_client = @saved_cs_client */; | 3303 | /*!40101 SET character_set_client = @saved_cs_client */; | 
            
              |  |  | 3304 | -- | 
            
              | 3305 | -- Table structure for table `illbatch_statuses` | 
            
              | 3306 | -- | 
            
              | 3307 | DROP TABLE IF EXISTS `illbatch_statuses`; | 
            
              | 3308 | CREATE TABLE `illbatch_statuses` ( | 
            
              | 3309 |     `id` int(11) NOT NULL auto_increment, -- Status ID | 
            
              | 3310 |     `name` varchar(100) NOT NULL,         -- Name of status | 
            
              | 3311 |     `code` varchar(20) NOT NULL,          -- Unique, immutable code for status | 
            
              | 3312 |     `is_system` int(1),                   -- Is this status required for system operation | 
            
              | 3313 |     PRIMARY KEY (`id`), | 
            
              | 3314 |     UNIQUE KEY `u_illbatchstatuses__code` (`code`) | 
            
              | 3315 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
            
              | 3316 |  | 
            
              | 3317 | -- | 
            
              | 3318 | -- Table structure for table `illbatches` | 
            
              | 3319 | -- | 
            
              | 3320 | DROP TABLE IF EXISTS `illbatches`; | 
            
              | 3321 | CREATE TABLE `illbatches` ( | 
            
              | 3322 |     `id` int(11) NOT NULL auto_increment, -- Batch ID | 
            
              | 3323 |     `name` varchar(100) NOT NULL,         -- Unique name of batch | 
            
              | 3324 |     `backend` varchar(20) NOT NULL,       -- Name of batch backend | 
            
              | 3325 |     `borrowernumber` int(11),             -- Patron associated with batch | 
            
              | 3326 |     `branchcode` varchar(50),             -- Branch associated with batch | 
            
              | 3327 |     `statuscode` varchar(20),             -- Status of batch | 
            
              | 3328 |     PRIMARY KEY (`id`), | 
            
              | 3329 |     UNIQUE KEY `u_illbatches__name` (`name`), | 
            
              | 3330 |     CONSTRAINT `illbatches_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3331 |     CONSTRAINT `illbatches_bcfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              | 3332 |     CONSTRAINT `illbatches_sfk` FOREIGN KEY (`statuscode`) REFERENCES `illbatch_statuses` (`code`) ON DELETE SET NULL ON UPDATE CASCADE | 
            
              | 3333 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 3304 |  | 3334 |  | 
        
          | 3305 | -- | 3335 | -- | 
        
          | 3306 | -- Table structure for table `illrequests` | 3336 | -- Table structure for table `illrequests` | 
  
    | Lines 3330-3335
          CREATE TABLE `illrequests` (
      
      
        Link Here | 
        
          | 3330 |   `notesstaff` mediumtext DEFAULT NULL COMMENT 'Staff notes attached to request', | 3360 |   `notesstaff` mediumtext DEFAULT NULL COMMENT 'Staff notes attached to request', | 
        
          | 3331 |   `orderid` varchar(50) DEFAULT NULL COMMENT 'Backend id attached to request', | 3361 |   `orderid` varchar(50) DEFAULT NULL COMMENT 'Backend id attached to request', | 
        
          | 3332 |   `backend` varchar(20) DEFAULT NULL COMMENT 'The backend used to create request', | 3362 |   `backend` varchar(20) DEFAULT NULL COMMENT 'The backend used to create request', | 
            
              |  |  | 3363 |   `batch_id` int(11) COMMENT 'Optional ID of batch that this request belongs to', | 
        
          | 3333 |   PRIMARY KEY (`illrequest_id`), | 3364 |   PRIMARY KEY (`illrequest_id`), | 
        
          | 3334 |   KEY `illrequests_bnfk` (`borrowernumber`), | 3365 |   KEY `illrequests_bnfk` (`borrowernumber`), | 
        
          | 3335 |   KEY `illrequests_bcfk_2` (`branchcode`), | 3366 |   KEY `illrequests_bcfk_2` (`branchcode`), | 
  
    | Lines 3338-3344
          CREATE TABLE `illrequests` (
      
      
        Link Here | 
        
          | 3338 |   CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, | 3369 |   CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, | 
        
          | 3339 |   CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 3370 |   CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 
        
          | 3340 |   CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 3371 |   CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 
          
            
              | 3341 |   CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE | 3372 |   CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE, | 
            
              |  |  | 3373 |   CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE | 
        
          | 3342 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 3374 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 3343 | /*!40101 SET character_set_client = @saved_cs_client */; | 3375 | /*!40101 SET character_set_client = @saved_cs_client */; | 
        
          | 3344 |  | 3376 |  |