salix/db/routines/vn/triggers/business_beforeInsert.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`business_beforeInsert`
	BEFORE INSERT ON `business`
	FOR EACH ROW
BEGIN
	SET NEW.editorFk = account.myUser_getId();
	
	IF NEW.ended IS NULL THEN
		SET NEW.payedHolidays = 0;
	END IF;
END$$
DELIMITER ;