2024-10-08 14:06:38 +00:00
|
|
|
ALTER TABLE `vn`.`operator`
|
|
|
|
|
ADD COLUMN `machineFk` int(11) DEFAULT NULL,
|
|
|
|
|
ADD CONSTRAINT `operator_machine_FK` FOREIGN KEY (`machineFk`) REFERENCES `vn`.`machine` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
|
2024-10-15 07:45:14 +00:00
|
|
|
|
|
|
|
|
INSERT INTO salix.ACL (model,property,accessType,permission,principalType,principalId)
|
|
|
|
|
VALUES ('Machine','*','*','ALLOW','ROLE','productionBoss');
|
