-- Upgrade for installs created before brief reconciliation was added.
ALTER TABLE products
  ADD COLUMN reconcile_state ENUM('pending','done','needs_review','proposed') NULL AFTER build_brief_hash,
  ADD COLUMN reconcile_log   JSON     AFTER reconcile_state,
  ADD COLUMN reconciled_at   DATETIME AFTER reconcile_log;
ALTER TABLE websites
  ADD COLUMN content_at DATETIME AFTER built_at;