migration.sql 344 B

1234567891011
  1. -- CreateEnum
  2. CREATE TYPE "UserRole" AS ENUM ('ADMIN', 'USER');
  3. -- AlterTable
  4. ALTER TABLE "session" ADD COLUMN "impersonatedBy" TEXT;
  5. -- AlterTable
  6. ALTER TABLE "user" ADD COLUMN "banExpires" TIMESTAMP(3),
  7. ADD COLUMN "banReason" TEXT,
  8. ADD COLUMN "banned" BOOLEAN DEFAULT false,
  9. ADD COLUMN "role" "UserRole" DEFAULT 'USER';