-- Add OTP fields to users table
ALTER TABLE "users" ADD COLUMN "otp_code" VARCHAR(10);
ALTER TABLE "users" ADD COLUMN "otp_expires_at" TIMESTAMP;
ALTER TABLE "users" ADD COLUMN "otp_attempts" INTEGER DEFAULT 0;
ALTER TABLE "users" ADD COLUMN "is_otp_verified" BOOLEAN DEFAULT false;

-- Mark existing users as verified (they already registered before OTP was implemented)
UPDATE "users" SET "is_otp_verified" = true WHERE "email_verified" = true;