salix/db/versions/10976-greenCamellia/00-firstScript.sql

CREATE OR REPLACE TEMPORARY TABLE tmp.claimsWithHasToPickUp
	SELECT id
		FROM vn.claim
		WHERE hasToPickUp;

ALTER TABLE vn.claim CHANGE hasToPickUp pickup ENUM('agency', 'delivery') DEFAULT NULL;

UPDATE vn.claim c
		JOIN tmp.claimsWithHasToPickUp tmp ON tmp.id = c.id
	SET c.pickup = 'delivery';

-- Solved bug empty value
UPDATE vn.claim
	SET pickup = NULL
	WHERE pickup = '';

DROP TEMPORARY TABLE tmp.claimsWithHasToPickUp;

INSERT INTO salix.ACL (model,property,accessType,principalId)
	VALUES ('Application','getEnumValues','*','employee');