Lines 2880-2892
CREATE TABLE `erm_agreement_periods` (
Link Here
|
2880 |
|
2880 |
|
2881 |
DROP TABLE IF EXISTS `erm_user_roles`; |
2881 |
DROP TABLE IF EXISTS `erm_user_roles`; |
2882 |
CREATE TABLE `erm_user_roles` ( |
2882 |
CREATE TABLE `erm_user_roles` ( |
|
|
2883 |
`user_role_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
2883 |
`agreement_id` INT(11) NULL COMMENT 'link to the agreement', |
2884 |
`agreement_id` INT(11) NULL COMMENT 'link to the agreement', |
2884 |
`license_id` INT(11) NULL COMMENT 'link to the license', |
2885 |
`license_id` INT(11) NULL COMMENT 'link to the license', |
2885 |
`user_id` INT(11) NOT NULL COMMENT 'link to the user', |
2886 |
`user_id` INT(11) NOT NULL COMMENT 'link to the user', |
2886 |
`role` VARCHAR(80) NOT NULL COMMENT 'role of the user', |
2887 |
`role` VARCHAR(80) NOT NULL COMMENT 'role of the user', |
2887 |
CONSTRAINT `erm_user_roles_ibfk_1` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2888 |
CONSTRAINT `erm_user_roles_ibfk_1` FOREIGN KEY (`agreement_id`) REFERENCES `erm_agreements` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2888 |
CONSTRAINT `erm_user_roles_ibfk_2` FOREIGN KEY (`license_id`) REFERENCES `erm_licenses` (`license_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2889 |
CONSTRAINT `erm_user_roles_ibfk_2` FOREIGN KEY (`license_id`) REFERENCES `erm_licenses` (`license_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2889 |
CONSTRAINT `erm_user_roles_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2890 |
CONSTRAINT `erm_user_roles_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2891 |
PRIMARY KEY(`user_role_id`) |
2890 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2892 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2891 |
|
2893 |
|
2892 |
-- |
2894 |
-- |
2893 |
- |
|
|