ALTER TABLE "auction_lots" ADD COLUMN "estimate_low_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "estimate_high_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "current_bid_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "hammer_price_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "fx_rate" real;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "fx_date" date;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "buyer_premium_rate" real;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "fee_basis" text;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "all_in_bid_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "all_in_estimate_low_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "all_in_estimate_high_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "riv_usd_at_assessment" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "bid_vs_riv" real;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "estimate_vs_riv" real;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "assessment_verdict" text;--> statement-breakpoint
ALTER TABLE "auction_lots" ADD COLUMN "assessed_at" timestamp with time zone;--> statement-breakpoint
ALTER TABLE "sales" ADD COLUMN "all_in_usd" numeric(18, 4);--> statement-breakpoint
ALTER TABLE "sales" ADD COLUMN "fee_basis" text;--> statement-breakpoint
ALTER TABLE "sales" ADD COLUMN "buyer_premium_rate" real;--> statement-breakpoint
CREATE INDEX "auction_lots_status_ends_idx" ON "auction_lots" USING btree ("status","ends_at");--> statement-breakpoint
CREATE INDEX "auction_lots_bid_vs_riv_idx" ON "auction_lots" USING btree ("bid_vs_riv") WHERE bid_vs_riv is not null and status in ('live','upcoming');