ALTER TABLE "es_site" ADD COLUMN "audit_cadence" text DEFAULT 'none' NOT NULL;--> statement-breakpoint
ALTER TABLE "es_site" ADD COLUMN "last_audit_at" timestamp with time zone;--> statement-breakpoint
ALTER TABLE "es_site" ADD COLUMN "next_audit_at" timestamp with time zone;--> statement-breakpoint
CREATE INDEX "idx_site_next_audit" ON "es_site" USING btree ("next_audit_at");