mysql> create table user_role (
    -> user_id int(11) not null default '0',
    -> role_id int(11) not null default '0',
    -> primary key (user_id, role_id),
    -> foreign key user_fk (user_id) references user (id),
    -> foreign key role_fk (role_id) references role (id) 
    -> );