mysql-and

delimiter $$
drop trigger if exists PURCHASE_HEADER_UpdateActionAfterUpdate;
CREATE TRIGGER PURCHASE_HEADER_UpdateActionAfterUpdate
After Update ON PURCHASE_HEADER
FOR EACH ROW
BEGIN
IF (NEW.SIGNED_PO!=OLD.SIGNED_PO and NEW.SIGNED_PO!='') THEN
INSERT INTO MESSAGE_HEADER(
STATUS, DATE,ACTION,DOCUMENT, USER_RECORDID, USER,
RECORDID, PARENT_RECORDID,CONTENT)
VALUES
('U','1753-1-1','Upload','PO',NEW.USER_RECORDID,NEW.USER,
round(unix_timestamp(now())*10+rand()*10000,0),
NEW.RECORDID,NEW.SIGNED_PO)
;
END IF;
END;
$$
delimiter ;