<reponame>NASA-IMPACT/nasa-apt
-- Deploy nasa-apt:publication_checklist to pg
-- requires: tables

BEGIN;
ALTER TABLE apt.atbd_versions
  ADD COLUMN publication_checklist json DEFAULT '{"journal_editor": "<NAME>"}';

UPDATE
  apt.atbd_versions
SET
  publication_checklist = '{
    "journal_editor": "<NAME>"
  }'::jsonb;
COMMIT;
