|
Lines 5113-5118
CREATE TABLE `old_issues` (
Link Here
|
| 5113 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5113 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5114 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5114 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5115 |
|
5115 |
|
|
|
5116 |
-- |
| 5117 |
-- Table structure for table `hold_group_target_holds` |
| 5118 |
-- |
| 5119 |
DROP TABLE IF EXISTS `hold_group_target_holds`; |
| 5120 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5121 |
/*!40101 SET character_set_client = utf8 */; |
| 5122 |
CREATE TABLE hold_group_target_holds ( |
| 5123 |
`hold_group_id` int unsigned NOT NULL UNIQUE COMMENT 'foreign key, linking this to the hold_groups table', |
| 5124 |
`reserve_id` int(11) DEFAULT NULL UNIQUE COMMENT 'foreign key, linking this to the reserves table', |
| 5125 |
CONSTRAINT `hold_group_target_holds_ibfk_1` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE CASCADE, |
| 5126 |
CONSTRAINT `hold_group_target_holds_ibfk_2` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE CASCADE |
| 5127 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5128 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5129 |
|
| 5116 |
-- |
5130 |
-- |
| 5117 |
-- Table structure for table `old_reserves` |
5131 |
-- Table structure for table `old_reserves` |
| 5118 |
-- |
5132 |
-- |