|
Lines 5070-5077
DROP TABLE IF EXISTS `hold_groups`;
Link Here
|
| 5070 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5070 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5071 |
/*!40101 SET character_set_client = utf8 */; |
5071 |
/*!40101 SET character_set_client = utf8 */; |
| 5072 |
CREATE TABLE hold_groups ( |
5072 |
CREATE TABLE hold_groups ( |
| 5073 |
hold_group_id int unsigned NOT NULL AUTO_INCREMENT, |
5073 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 5074 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table', |
5074 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table', |
|
|
5075 |
`visual_hold_group_id` int(11) DEFAULT NULL COMMENT 'visual ID for this hold group, in the context of the related patron', |
| 5075 |
KEY `hold_groups_borrowernumber` (`borrowernumber`), |
5076 |
KEY `hold_groups_borrowernumber` (`borrowernumber`), |
| 5076 |
CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE, |
5077 |
CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE, |
| 5077 |
PRIMARY KEY (hold_group_id) |
5078 |
PRIMARY KEY (hold_group_id) |