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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`duaTax_beforeUpdate`
	BEFORE UPDATE ON `duaTax`
	FOR EACH ROW
BEGIN
	SET NEW.rate = duaTax_getRate(NEW.duaFk, NEW.taxClassFk);
	SET NEW.tax = NEW.base * NEW.rate / 100;
END$$
DELIMITER ;