-- CreateTable
CREATE TABLE "manual_specie" (
    "id" SERIAL NOT NULL,
    "city_id" INTEGER NOT NULL,
    "specie_id" INTEGER NOT NULL,
    "allowed" BOOLEAN NOT NULL DEFAULT true,

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

-- AddForeignKey
ALTER TABLE "manual_specie" ADD CONSTRAINT "manual_specie_city_id_fkey" FOREIGN KEY ("city_id") REFERENCES "city"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "manual_specie" ADD CONSTRAINT "manual_specie_specie_id_fkey" FOREIGN KEY ("specie_id") REFERENCES "species"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
