DROP TRIGGER IF EXISTS `changePosition`;
DELIMITER ;;
CREATE TRIGGER `changePosition` AFTER UPDATE ON `bswork_position_info` FOR EACH ROW BEGIN
if new.id!=old.id then
insert into bswork_position_change(code,oid,nid,date) values(new.code,old.id,new.id,now());
END if;
END
;;
DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `changePosition` AFTER UPDATE ON `bswork_position_info` FOR EACH ROW BEGIN
if new.id!=old.id then
insert into bswork_position_change(code,oid,nid,date) values(new.code,old.id,new.id,now());
END if;
END
;;
DELIMITER ;