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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`address_beforeUpdate`
	BEFORE UPDATE ON `address`
	FOR EACH ROW
BEGIN
	SET NEW.editorFk = account.myUser_getId();

	IF !(NEW.phone <=> OLD.phone) AND (NEW.phone <> '') THEN
		CALL pbx.phone_isValid(NEW.phone);
	END IF;

    IF !(NEW.mobile <=> OLD.mobile) AND (NEW.mobile <> '')THEN
		CALL pbx.phone_isValid(NEW.mobile);
	END IF;

	IF NOT (NEW.provinceFk <=> OLD.provinceFk)
		OR (NEW.postalCode <=> OLD.postalCode) THEN

		SET NEW.geoFk = address_getGeo(NEW.id);
	END IF;
END$$
DELIMITER ;