-- FAS 1b: Household activation milestones (spec §4.2)
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "first_scan_completed_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "fifth_item_confirmed_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "first_recipe_recommendation_viewed_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "first_recipe_saved_or_started_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "activated_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "first_cooking_session_completed_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "inventory_updated_after_cooking_at" timestamp with time zone;
ALTER TABLE "households" ADD COLUMN IF NOT EXISTS "value_confirmed_at" timestamp with time zone;