-- ============================================================
--  Cancellation Requests — additive migration
--  Run once:  mysql -u buylocal -p buylocal < db/cancel-request.sql
-- ============================================================

ALTER TABLE `members`
    ADD COLUMN `cancel_request_at`     DATETIME  DEFAULT NULL
        COMMENT 'When member submitted a cancellation request'
        AFTER `cancel_effective_at`,
    ADD COLUMN `cancel_request_reason` TEXT      DEFAULT NULL
        COMMENT 'Reason the member gave for wanting to cancel'
        AFTER `cancel_request_at`;