-- AlterTable
ALTER TABLE "processes" ADD COLUMN     "bia_status" TEXT NOT NULL DEFAULT 'offen',
ADD COLUMN     "catalog_code" TEXT,
ADD COLUMN     "data_protection_relevant" BOOLEAN NOT NULL DEFAULT false,
ADD COLUMN     "deputy_owner_id" TEXT,
ADD COLUMN     "in_scope" BOOLEAN NOT NULL DEFAULT true,
ADD COLUMN     "interfaces" TEXT,
ADD COLUMN     "legal_basis" TEXT,
ADD COLUMN     "parent_id" TEXT,
ADD COLUMN     "prototype_relevant" BOOLEAN NOT NULL DEFAULT false,
ADD COLUMN     "purpose" TEXT;

-- CreateIndex
CREATE INDEX "processes_tenant_id_parent_id_idx" ON "processes"("tenant_id", "parent_id");

-- AddForeignKey
ALTER TABLE "processes" ADD CONSTRAINT "processes_parent_id_fkey" FOREIGN KEY ("parent_id") REFERENCES "processes"("id") ON DELETE SET NULL ON UPDATE CASCADE;