CREATE DEFINER =yfy_cloud@%TRIGGERubulAFTER INSERT ON无标题` FOR EACH ROW BEGIN
DELETE FROM base_userrelation WHERE F_UserId = new.F_Id;
INSERT INTO base_userrelation(F_Id,F_UserId,F_ObjectType,F_ObjectId) SELECT UUID() F_Id,new.F_Id F_UserId,'Position' F_ObjectType,id F_ObjectId FROM base_positions WHERE FIND_IN_SET(id,new.F_PositionId);
END;
CREATE DEFINER = yfy_cloud@% TRIGGER ubul2 AFTER UPDATE ON 无标题 FOR EACH ROW BEGIN
DELETE FROM base_userrelation WHERE F_UserId = new.F_Id;
INSERT INTO base_userrelation(F_Id,F_UserId,F_ObjectType,F_ObjectId) SELECT UUID() F_Id,new.F_Id F_UserId,'Position' F_ObjectType,id F_ObjectId FROM base_positions WHERE FIND_IN_SET(id,new.F_PositionId);
END;
`