ALTER TABLE "scenario" ADD COLUMN "cost" real;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "total_work_hours" real;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_savings" real;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "co2_equivalent_savings" real;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_cost_savings" real;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "epc_breakdown_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "epc_breakdown_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "number_of_properties" integer;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "n_units_to_retrofit" integer;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "co2_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "co2_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_bill_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_bill_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_consumption_per_unit_pre_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "energy_consumption_per_unit_post_retrofit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "valuation_improvement_per_unit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "cost_per_unit" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "cost_per_co2_saved" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "cost_per_sap_point" text;--> statement-breakpoint
ALTER TABLE "scenario" ADD COLUMN "valuation_return_on_investment" text;