Lines 5161-5166
CREATE TABLE `user_permissions` (
Link Here
|
5161 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
5161 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
5162 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5162 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5163 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5163 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
5164 |
PRIMARY KEY (`borrowernumber`,`module_bit`,`code`), |
5164 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
5165 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
5165 |
KEY `user_permissions_ibfk_2` (`module_bit`,`code`), |
5166 |
KEY `user_permissions_ibfk_2` (`module_bit`,`code`), |
5166 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5167 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5167 |
- |
|
|