|
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 |
- |
|
|