On Wed, 11 Jun 2003 22:17:09 -0230, "JJ" <[EMAIL PROTECTED]> wrote: [...] | *************** | * The second idea is to create two tables. | *************** | table groups | groupName varchar primary key | groupDescription text | | table groupRelations | groupName | groupMember | | -----> ex: | groups table: | groupOne First test group | groupTwo Second test group | | groupRelations: | groupOne member1 | groupOne member3 | groupTwo member2 | groupTwo member3 | | Like I said before, I'm not very happy with either method. If anyone else | has any better ideas they wouldn't mind sharing, I'd really appreciate it!
This scheme will give you the most flexibility. There is no limit as to how many people can be in a group or how many groups a person can be in. You will want to create a joined unique key on the group_id and member_id. Have Fun! Michael -- Michael Brunson 504.200.2222 [EMAIL PROTECTED] ICQ: 83163789 Data Center Manager -- www.zipa.com -- Zipa, LLC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
