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

  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
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