DELIMITER // CREATE TRIGGER tg_tournaments_teams_st BEFORE INSERT ON tournaments_teams FOR EACH ROW BEGIN INSERT INTO tournaments_teams_st VALUES(null,NEW.tournament_id,NEW.team_id,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,now(),now()); END // DELIMITER ;