Sql

ALTER TABLE user CHANGE name username VARCHAR(50) NOT NULL;

ALTER TABLE groups AUTO_INCREMENT = 1;

CREATE VIEW role AS SELECT gr.id,

       name,
       description,
       appcode,
       created  AS created_when,
       created_by,
       modified AS modified_when,
       modified_by

FROM groups gr JOIN tmp_role_adone tra ON gr.id = tra.id;

ALTER TABLE user ADD UNIQUE (name);

ALTER TABLE user ADD CONSTRAINT fk_user_group

 FOREIGN KEY (group_id)
 REFERENCES groups(id);