dodil/erp-brick-projects
src/brick_projects/migrations/00004_submitted_sub/up.sql
-- 00004_submitted_sub (v0.1.4): the submitter's sub beside their email, so the accept_own gate holds for either
-- identity. At the END of pj_item's CREATE in schema.sql (a new bucket) and added here for a bucket on 00003.
-- erp-migrate marks an ADD COLUMN DISRUPTIVE: migrate the test copy first, the live one at a quiet hour.
ALTER TABLE pj_item ADD COLUMN submitted_sub VARCHAR;