DROP INDEX "uq_epc_property_property_portfolio";--> statement-breakpoint
ALTER TABLE "epc_property" ADD COLUMN "source" text DEFAULT 'lodged' NOT NULL;--> statement-breakpoint
CREATE INDEX "ix_epc_property_property_source" ON "epc_property" USING btree ("property_id","source");--> statement-breakpoint
CREATE UNIQUE INDEX "uq_epc_property_property_portfolio" ON "epc_property" USING btree ("property_id","portfolio_id","source");