Lines 5189-5194
CREATE TABLE `user_permissions` (
Link Here
|
5189 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
5189 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
5190 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5190 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5191 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5191 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
5192 |
PRIMARY KEY (`borrowernumber`,`module_bit`,`code`), |
5192 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
5193 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
5193 |
KEY `user_permissions_ibfk_2` (`module_bit`,`code`), |
5194 |
KEY `user_permissions_ibfk_2` (`module_bit`,`code`), |
5194 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5195 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5195 |
- |
|
|