-- CreateEnum
CREATE TYPE "ExpenseCategory" AS ENUM ('OfficeRent', 'OperationalExpenses', 'Depreciation', 'IncomeTax', 'GSTAndStatutoryPayments');

-- CreateTable
CREATE TABLE "monthly_expenses" (
    "id" TEXT NOT NULL,
    "month" INTEGER NOT NULL,
    "year" INTEGER NOT NULL,
    "category" "ExpenseCategory" NOT NULL,
    "amount" DECIMAL(10,2) NOT NULL,
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

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

-- CreateIndex
CREATE UNIQUE INDEX "monthly_expenses_month_year_category_key" ON "monthly_expenses"("month", "year", "category");
