Crawl/backend/migrations/011_icon.sql

-- Migration 011: add icon field to price_snapshot and scrape_results
SET search_path TO crawl;

ALTER TABLE price_snapshot
    ADD COLUMN IF NOT EXISTS icon TEXT;

ALTER TABLE scrape_results
    ADD COLUMN IF NOT EXISTS icon TEXT;