MeNeedz Auth

[eluser]davidbehler[/eluser]
The problem for me is, that I don't know what kind of primary key the developer wants to use for this tables and that in the case of the group table it's even worth because he might not use the group table at all and have his groups in the config file with god knows what kind of key.

So I decided to make the group id a varchar(20) and keep it that way compatible to my example where the primary key of the groups are "user", "moderator" and "admin". If you know for sure that you won't use the groups in the config file, then you can choose smallint as datatype for the user_group field (even name it user_group_id) and change the primary key of the group table.