START TRANSACTION;

ALTER TABLE users
  ADD COLUMN photo_url VARCHAR(255) DEFAULT NULL AFTER role;

COMMIT;