-- Run once if you imported the database before these features.
-- phpMyAdmin: select smartledger database -> SQL tab -> paste -> Go.
ALTER TABLE staff
  ADD COLUMN ui_theme VARCHAR(20) NOT NULL DEFAULT 'daylight' AFTER last_login_at,
  ADD COLUMN password_changed_at DATETIME NULL AFTER ui_theme,
  ADD COLUMN must_change_password TINYINT(1) NOT NULL DEFAULT 0 AFTER password_changed_at;
ALTER TABLE otp_code MODIFY COLUMN purpose ENUM('login','verify_phone','verify_email','register') NOT NULL DEFAULT 'login';