BeBot - An Anarchy Online and Age Of Conan chat automaton

General => Feedback and Suggestions => Topic started by: Glarawyn on August 25, 2006, 07:27:45 pm

Title: Add a primary key to admin_members
Post by: Glarawyn on August 25, 2006, 07:27:45 pm

ALTER TABLE admin_members ADD PRIMARY KEY (name, admin_group);

This creates a composite primary key, forcing all parings of a name and group number to be unique. So Glarawyn cannot be a member of group 1 multiple times, but Glarawyn can be a member of group 1 and 2.

This change doesn't really change anything; it just prevents possibly annoying duplication. Also, admin_members looks to be the only default table without a primary key set, which I just don’t get because there is a primary key right there without adding extra data. :)

Title: Re: Add a primary key to admin_members
Post by: Khalem on August 26, 2006, 02:37:47 am

I'm just gonna leave this as is for 0.2.x, however it will be fixed in 0.3/0.4 as the table gets migrated to groups instead of admin_groups.
I'm gonna separate the two in the database, however i'll likely still let them have a shared end user interface, ie !admin