ALTER TABLE "keywords" ADD COLUMN "volume_primary" real GENERATED ALWAYS AS (((metrics -> primary_source ->> 'volume')::real)) STORED;--> statement-breakpoint
ALTER TABLE "keywords" ADD COLUMN "kd_primary" real GENERATED ALWAYS AS (((metrics -> primary_source ->> 'kd')::real)) STORED;--> statement-breakpoint
ALTER TABLE "keywords" ADD COLUMN "cpc_primary" real GENERATED ALWAYS AS (((metrics -> primary_source ->> 'cpc')::real)) STORED;--> statement-breakpoint
ALTER TABLE "keywords" ADD COLUMN "growth_primary" real GENERATED ALWAYS AS (((metrics -> primary_source ->> 'growthPct')::real)) STORED;--> statement-breakpoint
CREATE INDEX "keywords_site_volume_idx" ON "keywords" USING btree ("site_id","volume_primary" DESC NULLS LAST);--> statement-breakpoint
CREATE INDEX "keywords_site_kd_idx" ON "keywords" USING btree ("site_id","kd_primary");