/*
  Warnings:

  - You are about to drop the column `fieldId` on the `Opportunity` table. All the data in the column will be lost.
  - You are about to drop the `Activity` table. If the table is not empty, all the data it contains will be lost.

*/
-- DropForeignKey
ALTER TABLE "Opportunity" DROP CONSTRAINT "Opportunity_fieldId_fkey";

-- AlterTable
ALTER TABLE "Company" ADD COLUMN     "activitiesFamilies" TEXT[];

-- AlterTable
ALTER TABLE "Opportunity" DROP COLUMN "fieldId",
ADD COLUMN     "activities" TEXT[],
ADD COLUMN     "activitiesFamilies" TEXT[];

-- DropTable
DROP TABLE "Activity";

-- CreateTable
CREATE TABLE "ActivityFamily" (
    "id" TEXT NOT NULL,
    "name" VARCHAR(250) NOT NULL,

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