alter table user
  add username varchar(255) not null after password,
  add unique key(username);

truncate table user;
alter table user
  add username varchar(255) not null after password,
  add unique key(username);

Truncate table in patch to avoid duplicate null values.
Truncate table in patch to avoid duplicate null values.
