All pastes #50594 Raw Edit

Stuff

public text v1 · immutable
#50594 ·published 2006-04-22 22:36 UTC
rendered paste body
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
/*!50003 SET SESSION SQL_MODE="" */;
/*!50003 CREATE TRIGGER `trigg_astaccount` BEFORE UPDATE ON `astaccount` FOR EACH ROW BEGIN
  IF OLD.regseconds <> NEW.regseconds THEN
    SET NEW.reg_changed = Now();
    END IF;
  IF OLD.ipaddr <> NEW.ipaddr THEN
    SET NEW.reg_changed = Now();
    END IF;
  IF OLD.port <> NEW.port THEN
    SET NEW.reg_changed = Now();
    END IF;
  END */;

/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;