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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`client_beforeInsert`
	BEFORE INSERT ON `client`
	FOR EACH ROW
BEGIN
	SET NEW.editorFk = account.myUser_getId();
	SET NEW.accountingAccount = 4300000000 + NEW.id;
    SET NEW.lastSalesPersonFk = NEW.salesPersonFk;
	SET NEW.geoFk = client_getGeo(NEW.id);

	IF (NEW.phone <> '') THEN
		CALL pbx.phone_isValid(NEW.phone);
	END IF;

	IF (NEW.mobile <> '') THEN
		CALL pbx.phone_isValid(NEW.mobile);
	END IF;
END$$
DELIMITER ;