create table user_profile ( uid varchar(255) not null, profile_id int(10) unsigned not null, primary key (uid, profile_id) ) comment='Link between user and profile table'; -- two possible level of privileges alter table `user` add column priv_level enum ('user', 'admin') default 'user';