Files

6 lines
301 B
SQL

ALTER TABLE "users"
ADD COLUMN IF NOT EXISTS "two_factor_enabled" BOOLEAN NOT NULL DEFAULT false,
ADD COLUMN IF NOT EXISTS "two_factor_secret_encrypted" TEXT,
ADD COLUMN IF NOT EXISTS "two_factor_pending_secret_encrypted" TEXT,
ADD COLUMN IF NOT EXISTS "two_factor_confirmed_at" TIMESTAMP(3);