View | Details | Raw Unified | Return to bug 40504
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3808-3823 CREATE TABLE `illrequests` ( Link Here
3808
  `batch_id` int(11) DEFAULT NULL COMMENT 'Optional ID of batch that this request belongs to',
3808
  `batch_id` int(11) DEFAULT NULL COMMENT 'Optional ID of batch that this request belongs to',
3809
  PRIMARY KEY (`illrequest_id`),
3809
  PRIMARY KEY (`illrequest_id`),
3810
  KEY `illrequests_bnfk` (`borrowernumber`),
3810
  KEY `illrequests_bnfk` (`borrowernumber`),
3811
  KEY `illrequests_manfk` (`managedby`),
3812
  KEY `illrequests_bcfk_2` (`branchcode`),
3811
  KEY `illrequests_bcfk_2` (`branchcode`),
3813
  KEY `illrequests_safk` (`status_alias`),
3812
  KEY `illrequests_safk` (`status_alias`),
3814
  KEY `illrequests_bibfk` (`biblio_id`),
3813
  KEY `illrequests_bibfk` (`biblio_id`),
3815
  KEY `illrequests_ibfk` (`batch_id`),
3814
  KEY `illrequests_ibfk` (`batch_id`),
3815
  KEY `illrequests_manfk` (`managedby`),
3816
  CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
3816
  CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
3817
  CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3817
  CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3818
  CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3818
  CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3819
  CONSTRAINT `illrequests_manfk` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3820
  CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`ill_batch_id`) ON DELETE SET NULL ON UPDATE CASCADE,
3819
  CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`ill_batch_id`) ON DELETE SET NULL ON UPDATE CASCADE,
3820
  CONSTRAINT `illrequests_manfk` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3821
  CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE
3821
  CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE
3822
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3822
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3823
/*!40101 SET character_set_client = @saved_cs_client */;
3823
/*!40101 SET character_set_client = @saved_cs_client */;
3824
- 

Return to bug 40504