-- Place your SQL code here
ALTER TABLE vn.absenceType ADD isFestiveEligible BOOL DEFAULT 1 NOT NULL COMMENT 'Para marcar un tipo de absence';

UPDATE vn.absenceType
SET isFestiveEligible = 0
WHERE code = 'holiday';

UPDATE vn.absenceType
	SET isFestiveEligible=0
	WHERE code = 'halfHoliday';