List:General Discussion« Previous MessageNext Message »
From:Caroline Jen Date:January 2 2004 9:28am
Subject:Multiple Roles
View as plain text  
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
Thread
Multiple RolesCaroline Jen2 Jan
  • Re: Multiple RolesEli Hen2 Jan
  • Re: Multiple RolesMartijn Tonies2 Jan
  • Re: Multiple RolesTobias Asplund2 Jan
  • Re: Multiple RolesEd Leafe2 Jan
  • Re: Multiple RolesRoger Baklund2 Jan