ALTER TABLE loan_proposals
    ADD COLUMN proposal_number VARCHAR(80) NULL AFTER external_reference,
    ADD UNIQUE KEY uq_loan_proposals_proposal_number (proposal_number);