-- CreateTable
CREATE TABLE "otp" (
    "id" BIGSERIAL NOT NULL,
    "otp" TEXT NOT NULL,
    "user_id" TEXT NOT NULL,
    "valid_until" TIMETZ(6) NOT NULL,
    "is_used" BOOLEAN DEFAULT false,
    "mobile" TEXT NOT NULL,

    PRIMARY KEY ("id")
);

-- AddForeignKey
ALTER TABLE "otp" ADD FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE;
