ALTER TYPE "property_status" ADD VALUE 'scoping';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'assessment';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'tendering';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'project underway';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'completion; status: on track';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'completion; status: delayed';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'completion; status: at risk';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'completion; status: completed';--> statement-breakpoint
ALTER TYPE "property_status" ADD VALUE 'needs review';--> statement-breakpoint
ALTER TABLE "property" ADD COLUMN "status" "property_status";