-- DropIndex DROP INDEX "Game_mName_idx"; -- DropIndex DROP INDEX "GameTag_name_idx"; -- AlterTable ALTER TABLE "ApplicationSettings" ADD COLUMN "mLogoObjectId" TEXT, ADD COLUMN "serverName" TEXT NOT NULL DEFAULT 'Drop'; -- CreateIndex CREATE INDEX "Game_mName_idx" ON "Game" USING GIST ("mName" gist_trgm_ops(siglen=32)); -- CreateIndex CREATE INDEX "GameTag_name_idx" ON "GameTag" USING GIST ("name" gist_trgm_ops(siglen=32));