-- AlterTable: add co-chair to stakeholders
ALTER TABLE "stakeholders" ADD COLUMN "co_chair" VARCHAR(150);

-- DropIndex: the old enum status index
DROP INDEX "issue_resolves_status_idx";

-- AlterTable: replace the enum status with a FK to issue_statuses
ALTER TABLE "issue_resolves" DROP COLUMN "status",
ADD COLUMN "issue_status_id" INTEGER;

-- DropEnum: IssueResolveStatus is no longer used
DROP TYPE "IssueResolveStatus";

-- CreateIndex
CREATE INDEX "issue_resolves_issue_status_id_idx" ON "issue_resolves"("issue_status_id");

-- AddForeignKey
ALTER TABLE "issue_resolves" ADD CONSTRAINT "issue_resolves_issue_status_id_fkey" FOREIGN KEY ("issue_status_id") REFERENCES "issue_statuses"("id") ON DELETE SET NULL ON UPDATE CASCADE;
