|
Lines 2975-2983
DROP TABLE IF EXISTS `erm_eholdings_packages_agreements`;
Link Here
|
| 2975 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
2975 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
| 2976 |
`package_id` INT(11) NOT NULL COMMENT 'link to the package', |
2976 |
`package_id` INT(11) NOT NULL COMMENT 'link to the package', |
| 2977 |
`agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement', |
2977 |
`agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement', |
| 2978 |
UNIQUE KEY `erm_eholdings_packages_agreements_uniq` (`package_id`, `agreement_id`), |
|
|
| 2979 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `erm_eholdings_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2978 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `erm_eholdings_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2980 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE |
2979 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2980 |
PRIMARY KEY(`package_id`, `agreement_id`) |
| 2981 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2981 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2982 |
|
2982 |
|
| 2983 |
-- |
2983 |
-- |
| 2984 |
- |
|
|