ALTER TABLE "portfolio" ADD COLUMN "epc_breakdown_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "epc_breakdown_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "n_units_to_retrofit" integer;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "co2_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "co2_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "energy_bill_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "energy_bill_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "energy_consumption_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "energy_consumption_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "valuation_improvement_per_unit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "cost_per_unit" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "cost_per_co2_saved" text;--> statement-breakpoint
ALTER TABLE "portfolio" ADD COLUMN "cost_per_sap_point" text;