-- V9__add_manuscript_hash_to_papers.sql
ALTER TABLE papers
    ADD COLUMN manuscript_hash VARCHAR(64);

COMMENT ON COLUMN papers.manuscript_hash IS
  'Lowercase hex SHA-256 of the manuscript bytes at upload time. NULL for papers submitted before V9 (forward-only; no backfill).';