/*
  Warnings:

  - You are about to drop the column `city_id` on the `manual_specie` table. All the data in the column will be lost.
  - Added the required column `manual_id` to the `manual_specie` table without a default value. This is not possible if the table is not empty.

*/
-- DropForeignKey
ALTER TABLE "manual_specie" DROP CONSTRAINT "manual_specie_city_id_fkey";

-- AlterTable
ALTER TABLE "manual_specie" DROP COLUMN "city_id",
ADD COLUMN     "manual_id" INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE "manual_specie" ADD CONSTRAINT "manual_specie_manual_id_fkey" FOREIGN KEY ("manual_id") REFERENCES "manual"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
