...
create table user (
id int not null auto_increment,
account_expired boolean not null,
account_locked boolean not null,
enabled boolean not null,
password varchar(25563) not null,
password_expired boolean not null,
username varchar(25563) not null,
unique(username),
primary key(id)
) Engine=InnoDB;
create table role (
id int not null auto_increment,
authority varchar(25563) not null,
unique(authority),
primary key(id)
) Engine=InnoDB;
...