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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 3551-3556 DROP TABLE IF EXISTS `hold_groups`; Link Here
3551
/*!40101 SET character_set_client = utf8mb4 */;
3551
/*!40101 SET character_set_client = utf8mb4 */;
3552
CREATE TABLE `hold_groups` (
3552
CREATE TABLE `hold_groups` (
3553
  `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3553
  `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3554
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table',
3555
  KEY `hold_groups_borrowernumber` (`borrowernumber`),
3556
  CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE,
3554
  PRIMARY KEY (`hold_group_id`)
3557
  PRIMARY KEY (`hold_group_id`)
3555
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3558
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3556
/*!40101 SET character_set_client = @saved_cs_client */;
3559
/*!40101 SET character_set_client = @saved_cs_client */;
3557
- 

Return to bug 40517