CREATE TRIGGER prueba BEFORE UPDATE ON td_persona
FOR EACH ROW
BEGIN
DECLARE @maximo int(11);
SET @maximo =(SELECT MAX(audi_id) FROM ts_auditoria);
if(OLD.pers_rut <> :NEW.pers_rut)then
begin
INSERT INTO ts_auditoria
VALUES(@maximo,'255.255.255.0',(DATE_FORMAT(now(),'%Y/%m/%d')),'td_persona','pers_rut',:OLD.pers_rut,:NEW.pers_rut);
end;
if(:OLD.pers_dv <> :NEW.pers_dv)then
begin
INSERT INTO ts_auditoria
VALUES(@maximo,'255.255.255.0',(DATE_FORMAT(now(),'%Y/%m/%d')),'td_persona','pers_dv',:OLD.pers_dv,:NEW.pers_dv);
end;
END;