CREATE TRIGGER tg_tournaments_teams_st_goals BEFORE INSERT ON match_data
FOR EACH ROW
BEGIN
   DECLARE teamIdofplayer INTEGER;
   DECLARE teamIdAwayMatch INTEGER;
   DECLARE teamIdHomeMatch INTEGER;
   DECLARE tournamentId INTEGER;
   CASE NEW.data_type WHEN 'goal'THEN
   SELECT team_id INTO teamIdofplayer FROM players WHERE id = NEW.player_id;
  END//


END//