Guest User

Untitled

a guest
Dec 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. DELIMITER $$
  2. CREATE TRIGGER Pc_Auditoria
  3. AFTER UPDATE ON pcTotal
  4. FOR EACH ROW
  5. INSERT INTO auditoria (pc, personaAnterior, horario, persona, fecha_mod)
  6. VALUES (NEW.pc, OLD.persona, NEW.horario, NEW.persona, NOW());
  7. DELIMITER ;
  8.  
  9. DELIMITER $$
  10. CREATE TRIGGER Pc_Auditoria AFTER UPDATE ON pcTotal
  11. FOR EACH ROW
  12. BEGIN
  13. IF <tu condición aca> THEN BEGIN
  14. INSERT INTO auditoria (pc, personaAnterior, horario, persona, fecha_mod)
  15. VALUES (NEW.pc, OLD.persona, NEW.horario, NEW.persona, NOW());
  16. END; END IF;
  17. END$$
  18. DELIMITER ;
  19.  
  20. IF NEW.persona IS NOT NULL THEN
  21.  
  22. DELIMITER $$
  23. CREATE TRIGGER Pc_Auditoria BEFORE UPDATE ON pcTotal
  24. FOR EACH ROW
  25. BEGIN
  26. IF COALESCE(NEW.coordinador, '') != '' THEN BEGIN
  27. INSERT INTO auditoria (pc, personaAnterior, horario, persona, fecha_mod)
  28. VALUES (NEW.pc, OLD.persona, NEW.horario, NEW.persona, NOW());
  29. END; END IF;
  30. END$$
  31. DELIMITER ;
Add Comment
Please, Sign In to add comment