-- AlterTable
ALTER TABLE "projects" ADD COLUMN     "branch" TEXT,
ADD COLUMN     "leadsConverted" INTEGER,
ADD COLUMN     "leadsGenerated" INTEGER;

-- AlterTable
ALTER TABLE "users" ADD COLUMN     "branch" TEXT,
ADD COLUMN     "location" TEXT;

-- CreateTable
CREATE TABLE "password_reset_tokens" (
    "id" TEXT NOT NULL,
    "email" TEXT NOT NULL,
    "token" TEXT NOT NULL,
    "expiresAt" TIMESTAMP(3) NOT NULL,
    "used" BOOLEAN NOT NULL DEFAULT false,
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT "password_reset_tokens_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE UNIQUE INDEX "password_reset_tokens_token_key" ON "password_reset_tokens"("token");

-- CreateIndex
CREATE INDEX "password_reset_tokens_email_idx" ON "password_reset_tokens"("email");
