View | Details | Raw Unified | Return to bug 32162
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 2977-2985 DROP TABLE IF EXISTS `erm_eholdings_packages_agreements`; Link Here
2977
CREATE TABLE `erm_eholdings_packages_agreements` (
2977
CREATE TABLE `erm_eholdings_packages_agreements` (
2978
    `package_id` INT(11) NOT NULL COMMENT 'link to the package',
2978
    `package_id` INT(11) NOT NULL COMMENT 'link to the package',
2979
    `agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement',
2979
    `agreement_id` INT(11) NOT NULL COMMENT 'link to the agreement',
2980
    UNIQUE KEY `erm_eholdings_packages_agreements_uniq` (`package_id`, `agreement_id`),
2981
    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_1` FOREIGN KEY (`package_id`) REFERENCES `erm_eholdings_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2982
    CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE
2981
    CONSTRAINT `erm_eholdings_packages_agreements_ibfk_2` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2982
    PRIMARY KEY(`package_id`, `agreement_id`)
2983
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2983
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2984
2984
2985
--
2985
--
2986
- 

Return to bug 32162