This repository has been archived on 2024-07-22. You can view files and clone it, but cannot push or open issues or pull requests.
Zaimki/migrations/039-more-indexes.sql

16 lines
397 B
SQL

-- Up
CREATE INDEX "profiles_teamName" ON "profiles" ("teamName");
CREATE INDEX "profiles_footerName" ON "profiles" ("footerName");
CREATE INDEX "profiles_footerAreas" ON "profiles" ("footerAreas");
CREATE INDEX "reports_userId" ON "reports" ("userId");
-- Down
DROP INDEX "profiles_teamName";
DROP INDEX "profiles_footerName";
DROP INDEX "profiles_footerAreas";
DROP INDEX "reports_userId";