DELIMITER //
DROP TRIGGER IF EXISTS tg_tournaments_teams_st //
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 //

DROP TRIGGER IF EXISTS cosa  //
CREATE TRIGGER cosa BEFORE INSERT ON tournaments_teams
FOR EACH ROW BEGIN 
 SET NEW.cosa = 3
END //
DELIMITER ;