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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3554-3562 CREATE TABLE `hold_groups` ( Link Here
3554
  `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3554
  `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3555
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table',
3555
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table',
3556
  `visual_hold_group_id` int(11) DEFAULT NULL COMMENT 'visual ID for this hold group, in the context of the related patron',
3556
  `visual_hold_group_id` int(11) DEFAULT NULL COMMENT 'visual ID for this hold group, in the context of the related patron',
3557
  PRIMARY KEY (`hold_group_id`),
3557
  KEY `hold_groups_borrowernumber` (`borrowernumber`),
3558
  KEY `hold_groups_borrowernumber` (`borrowernumber`),
3558
  CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE,
3559
  CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE
3559
  PRIMARY KEY (`hold_group_id`)
3560
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3560
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3561
/*!40101 SET character_set_client = @saved_cs_client */;
3561
/*!40101 SET character_set_client = @saved_cs_client */;
3562
3562
3563
- 

Return to bug 40517