sorarebuddy/db/migrations/00008_indexes_on_games.sql

7 lines
316 B
MySQL
Raw Permalink Normal View History

2024-06-06 05:52:54 +00:00
-- +goose Up
CREATE INDEX IF NOT EXISTS idx_games_away_team_slug_date ON games(away_team_slug, date);
CREATE INDEX IF NOT EXISTS idx_games_home_team_slug_date ON games(home_team_slug, date);
-- +goose Down
DROP INDEX IF EXISTS idx_games_away_team_slug_date;
DROP INDEX IF EXISTS idx_games_home_team_slug_date;