-- Upgrade for installs created before build briefs were added.
ALTER TABLE products
  ADD COLUMN build_brief      JSON     AFTER content_updated_at,
  ADD COLUMN build_brief_at   DATETIME AFTER build_brief,
  ADD COLUMN build_brief_hash CHAR(40) AFTER build_brief_at;
ALTER TABLE batches
  MODIFY type ENUM('research_market','generate_guide','generate_content','generate_brief') NOT NULL;