-- For existing portal DB only; make a verified backup before running.
ALTER TABLE portal_requests
  MODIFY COLUMN status enum('new','waiting_pool','waiting_offline_request','ready_for_offline_request','waiting_offline_signing','issued','rejected') NOT NULL DEFAULT 'new',
  ADD COLUMN authority_license_id varchar(120) NULL,
  ADD COLUMN authority_company_id char(36) NULL,
  ADD COLUMN offline_request_nonce binary(24) NULL,
  ADD COLUMN offline_request_encrypted MEDIUMBLOB NULL,
  ADD COLUMN offline_submitted_at datetime NULL;