-- Rename mapStatus to projectStage and migrate legacy values
ALTER TABLE "Project" RENAME COLUMN "mapStatus" TO "projectStage";

UPDATE "Project" SET "projectStage" = 'under_development' WHERE "projectStage" = 'pipeline';
UPDATE "Project" SET "projectStage" = 'operational' WHERE "projectStage" IN ('delivery', 'operational');
