-- +goose Up
CREATE INDEX IF NOT EXISTS idx_games_date ON public.games(date);
CREATE INDEX IF NOT EXISTS idx_competitions_zone_id ON public.competitions(zone_id);
CREATE INDEX IF NOT EXISTS idx_player_field_position ON public.players(field_position);

-- +goose Down
DROP INDEX IF EXISTS idx_games_date;
DROP INDEX IF EXISTS idx_competitions_zone_id;
DROP INDEX IF EXISTS idx_player_field_position;