-- ---------------------------------------------------------------------------
-- Post-submission instructions
-- Table: application_period  (new column: post_submission_instructions)
--
-- Holds the styled instructions shown to an applicant on the "Application
-- Summary" page after they submit and before a response is published. Content
-- is authored per application period in the SAT legacy application; this portal
-- only reads it and renders it through PackageContentHtml::purify(), which is
-- the sanitising boundary for all admin-authored HTML here.
--
-- NULL / blank is a supported state: the applicant-facing view falls back to
-- built-in instructions when no content has been authored for the period.
--
-- Run manually against the `satdb_sat` database. Schema in this project is
-- maintained directly in MySQL (there is no migration runner).
--
-- Already applied to `satdb_sat`; this script exists so other environments
-- (e.g. `satdb_sattest`) can be brought in line.
-- ---------------------------------------------------------------------------

ALTER TABLE `application_period`
  ADD COLUMN `post_submission_instructions` LONGTEXT NULL DEFAULT NULL;
