15 lines
478 B
SQL
15 lines
478 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
CREATE INDEX IF NOT EXISTS idx_downloaded_subtitles_created
|
|
ON downloaded_subtitles (created_at DESC);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_downloaded_subtitles_provider_created
|
|
ON downloaded_subtitles (provider, created_at DESC);
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
DROP INDEX IF EXISTS idx_downloaded_subtitles_provider_created;
|
|
DROP INDEX IF EXISTS idx_downloaded_subtitles_created;
|
|
-- +goose StatementEnd
|