ALTER TABLE "property" ALTER COLUMN "uprn" SET DATA TYPE bigint;--> statement-breakpoint
ALTER TABLE "property" ALTER COLUMN "building_reference_number" SET DATA TYPE bigint;--> statement-breakpoint
ALTER TABLE "property_details_meter" ALTER COLUMN "uprn" SET DATA TYPE bigint;--> statement-breakpoint
ALTER TABLE "property_details_meter" ALTER COLUMN "uprn" DROP NOT NULL;