DELIMITER $$ CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`zone_beforeInsert` BEFORE INSERT ON `zone` FOR EACH ROW BEGIN SET NEW.editorFk = account.myUser_getId(); IF NEW.priceOptimum = 0 THEN SET NEW.priceOptimum = NEW.price; END IF; END$$ DELIMITER ;