alter table users
    modify name varchar(50) null;

alter table users
    modify surname varchar(50) null;

alter table users
    drop column country;

alter table users
    add locale_id smallint unsigned null after country_id;

alter table users
    modify region varchar(50) null;

alter table users
    modify city varchar(50) null;

alter table users
    modify zip varchar(20) null;

alter table users
    modify address varchar(100) null;

alter table users
    add test boolean default false not null after deleted;

alter table users
    add last_activity datetime default current_timestamp null after test;

alter table users
    add constraint users_locales_id_fk
        foreign key (locale_id) references locales (id);