c
public sql v1 · immutableDELIMITER //DROP TRIGGER IF EXISTS tg_tournaments_teams_st //CREATE TRIGGER tg_tournaments_teams_st BEFORE INSERT ON tournaments_teamsFOR 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_teamsFOR EACH ROW BEGIN SET NEW.cosa = 3END //DELIMITER ;