/*
  Warnings:

  - You are about to drop the column `objectiveArray` on the `missions` table. All the data in the column will be lost.

*/
-- AlterTable
ALTER TABLE `missions` DROP COLUMN `objectiveArray`;

-- AlterTable
ALTER TABLE `objectives` ADD COLUMN `missionsId` INTEGER NULL;

-- AddForeignKey
ALTER TABLE `objectives` ADD CONSTRAINT `objectives_missionsId_fkey` FOREIGN KEY (`missionsId`) REFERENCES `missions`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;