In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate the roles?
John Dole author, editor
2. How do I create the table for the second case (see
below)?
create table user_roles (
user_name varchar(15) not null,
role_name varchar(15) not null, varchar(15) null
);
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
