stacker.news/prisma/migrations/20241009200148_wallet_streaks/migration.sql

27 lines
757 B
SQL

-- CreateEnum
CREATE TYPE "StreakType" AS ENUM ('COWBOY_HAT', 'GUN', 'HORSE');
-- AlterTable
ALTER TABLE "Streak" ADD COLUMN "type" "StreakType" NOT NULL DEFAULT 'COWBOY_HAT';
-- AlterTable
ALTER TABLE "users" ADD COLUMN "gunStreak" INTEGER,
ADD COLUMN "horseStreak" INTEGER;
-- CreateIndex
CREATE INDEX "Streak_type_idx" ON "Streak"("type");
-- CreateIndex
CREATE INDEX "users_streak_idx" ON "users"("streak");
-- CreateIndex
CREATE INDEX "users_gunStreak_idx" ON "users"("gunStreak");
-- CreateIndex
CREATE INDEX "users_horseStreak_idx" ON "users"("horseStreak");
-- DropIndex
DROP INDEX "Streak.startedAt_userId_unique";
-- CreateIndex
CREATE UNIQUE INDEX "Streak_startedAt_userId_type_key" ON "Streak"("startedAt", "userId", "type");