Guest User

Untitled

a guest
May 23rd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. DROP TRIGGER IF EXISTS `placasptc`.`update_bds`//
  2. CREATE TRIGGER `placasptc`.`update_bds` BEFORE UPDATE ON `placasptc`.`bds`
  3. FOR EACH ROW begin
  4. insert into historico
  5. set hist_action ='update',
  6. bkp_ID = old.ID,
  7. bkp_empresa = old.empresa,
  8. bkp_prefixo = old.prefixo,
  9. bkp_placa = old.placa,
  10. hist_modificado = now(),
  11. hist_usuario = Current_user();
  12. end
Add Comment
Please, Sign In to add comment