/*!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 */;