10 lines
408 B
SQL
10 lines
408 B
SQL
-- +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;
|