ALTER TABLE users
  ADD COLUMN api_token VARCHAR(64) NULL AFTER password_hash,
  ADD COLUMN preferences_json JSON NULL AFTER lang,
  ADD UNIQUE KEY uq_users_api_token (api_token);