On 11/18/06, Micro Mega Dust <[EMAIL PROTECTED]> wrote:
I create a separate table for each group, in order to avoid redundant
data in the table. Your solution is interesting, but I think that
allow redundancy in "GroupUsers". For example:
+-------+---------+
|userId | groupIp |
+-------+---------+
| foo | groupA | <--- !
| bar | groupA |
| quux | groupC |
| foo | groupB |
(...)
| foo | groupA | <--- !
+-------+---------+
Why would that happen? This table exists only to express a single
relationship between a user and a group. You would not insert
duplicate data. It can be enforced with a UNIQUE constraint.
