|
Lines 3560-3565
CREATE TABLE `hold_groups` (
Link Here
|
| 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 |
-- |
| 3564 |
-- Table structure for table `hold_groups_target_holds` |
| 3565 |
-- |
| 3566 |
|
| 3567 |
DROP TABLE IF EXISTS `hold_groups_target_holds`; |
| 3568 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 3569 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 3570 |
CREATE TABLE `hold_groups_target_holds` ( |
| 3571 |
`hold_group_id` int(10) unsigned NOT NULL COMMENT 'foreign key, linking this to the hold_groups table', |
| 3572 |
`reserve_id` int(11) NOT NULL COMMENT 'foreign key, linking this to the reserves table', |
| 3573 |
PRIMARY KEY (`hold_group_id`,`reserve_id`), |
| 3574 |
UNIQUE KEY `uq_hold_group_target_holds_hold_group_id` (`hold_group_id`), |
| 3575 |
UNIQUE KEY `uq_hold_group_target_holds_reserve_id` (`reserve_id`), |
| 3576 |
CONSTRAINT `hold_group_target_holds_ibfk_1` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE CASCADE, |
| 3577 |
CONSTRAINT `hold_group_target_holds_ibfk_2` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE CASCADE |
| 3578 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3579 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3580 |
|
| 3563 |
-- |
3581 |
-- |
| 3564 |
-- Table structure for table `housebound_profile` |
3582 |
-- Table structure for table `housebound_profile` |
| 3565 |
-- |
3583 |
-- |
|
Lines 5113-5133
CREATE TABLE `old_issues` (
Link Here
|
| 5113 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5131 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5114 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5132 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5115 |
|
5133 |
|
| 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 |
PRIMARY KEY (`hold_group_id`, `reserve_id`), |
| 5126 |
CONSTRAINT `hold_group_target_holds_ibfk_1` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_groups` (`hold_group_id`) ON DELETE CASCADE, |
| 5127 |
CONSTRAINT `hold_group_target_holds_ibfk_2` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE CASCADE |
| 5128 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5129 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5130 |
|
| 5131 |
-- |
5134 |
-- |
| 5132 |
-- Table structure for table `old_reserves` |
5135 |
-- Table structure for table `old_reserves` |
| 5133 |
-- |
5136 |
-- |
| 5134 |
- |
|
|