salix/db/versions/11312-navyAralia/00-firstScript.sql

ALTER TABLE vn.workerRelatives DROP FOREIGN KEY workerRelatives_disabilityGradeFk;
ALTER TABLE vn.workerRelatives DROP FOREIGN KEY workerRelatives_workerFk;

INSERT INTO salix.ACL (model,property,accessType,permission,principalType,principalId)
	VALUES
		('WorkerRelative','updateAttributes','*','ALLOW','ROLE','hr'),
		('WorkerRelative','crud','WRITE','ALLOW','ROLE','hr'),
		('WorkerRelative','findById','*','ALLOW','ROLE','hr'),
		('WorkerRelative','find','*','ALLOW','ROLE','hr'),
		('WorkerRelative','upsert','*','ALLOW','ROLE','hr'),
		('WorkerRelative','filter','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','updateAttributes','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','crud','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','findById','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','find','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','upsert','*','ALLOW','ROLE','hr'),
		('WorkerIrpf','filter','*','ALLOW','ROLE','hr'),
		('DisabilityGrade','updateAttributes','*','ALLOW','ROLE','hr'),
		('DisabilityGrade','crud','*','ALLOW','ROLE','hr'),
		('DisabilityGrade','findById','*','ALLOW','ROLE','hr'),
		('DisabilityGrade','find','*','ALLOW','ROLE','hr'),
		('DisabilityGrade','upsert','*','ALLOW','ROLE','hr');