Lines 2990-2998
DROP TABLE IF EXISTS `erm_eholdings_packages_agreements`;
Link Here
|
2990 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
2990 |
CREATE TABLE `erm_eholdings_packages_agreements` ( |
2991 |
`package_id` INT(11) NOT NULL COMMENT 'link to the package', |
2991 |
`package_id` INT(11) NOT NULL COMMENT 'link to the package', |
2992 |
`agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement', |
2992 |
`agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement', |
2993 |
UNIQUE KEY `erm_eholdings_packages_agreements_uniq` (`package_id`, `agreement_id`), |
|
|
2994 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `erm_eholdings_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2993 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `erm_eholdings_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2995 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE |
2994 |
CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2995 |
PRIMARY KEY(`package_id`, `agreement_id`) |
2996 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2996 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2997 |
|
2997 |
|
2998 |
-- |
2998 |
-- |
2999 |
- |
|
|