/*
  Warnings:

  - You are about to drop the `cliamte_data` table. If the table is not empty, all the data it contains will be lost.

*/
-- DropTable
DROP TABLE "cliamte_data";

-- CreateTable
CREATE TABLE "climate_data" (
    "id" SERIAL NOT NULL,
    "district" TEXT NOT NULL,
    "month" TEXT NOT NULL,
    "province" TEXT NOT NULL,
    "tehsil" TEXT NOT NULL,
    "year" INTEGER NOT NULL,
    "rainfall_mm" DOUBLE PRECISION NOT NULL,
    "temperature_2m_C" DOUBLE PRECISION NOT NULL,

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