34 lines
1.4 KiB
MySQL
34 lines
1.4 KiB
MySQL
|
-- Up
|
||
|
|
|
||
|
|
CREATE UNIQUE INDEX "users_username" ON "users" ("username");
|
||
|
|
CREATE UNIQUE INDEX "users_email" ON "users" ("email");
|
||
|
|
|
||
|
|
CREATE UNIQUE INDEX "users_usernameNorm" ON "users" ("usernameNorm");
|
||
|
|
CREATE INDEX "authenticators_type" ON "authenticators" ("type");
|
||
|
|
CREATE INDEX "authenticators_userId" ON "authenticators" ("userId");
|
||
|
|
CREATE INDEX "nouns_locale" ON "nouns" ("locale");
|
||
|
|
CREATE INDEX "nouns_masc" ON "nouns" ("masc");
|
||
|
|
CREATE INDEX "inclusive_locale" ON "inclusive" ("locale");
|
||
|
|
CREATE INDEX "inclusive_insteadOf" ON "inclusive" ("insteadOf");
|
||
|
|
CREATE INDEX "terms_locale" ON "terms" ("locale");
|
||
|
|
CREATE INDEX "terms_term" ON "terms" ("term");
|
||
|
|
CREATE INDEX "profiles_locale" ON "profiles" ("locale");
|
||
|
|
CREATE INDEX "profiles_userId" ON "profiles" ("userId");
|
||
|
|
CREATE INDEX "profiles_locale_userId" ON "profiles" ("locale", "userId");
|
||
|
|
CREATE INDEX "sources_locale" ON "sources" ("locale");
|
||
|
|
|
||
|
|
CREATE INDEX "reports_isAutomatic" ON "reports" ("isAutomatic");
|
||
|
|
CREATE INDEX "reports_isHandled" ON "reports" ("isHandled");
|
||
|
|
|
||
|
|
CREATE INDEX "names_name_locale" ON "names" ("locale", "name");
|
||
|
|
CREATE INDEX "names_name" ON "names" ("name");
|
||
|
|
CREATE INDEX "names_locale" ON "names" ("locale");
|
||
|
|
|
||
|
|
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
|
||
|
|
|