L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 01, 2008, 02:23:42 PM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Development > Feedback and Suggestions > Topic: Add a primary key to admin_members
Pages: [1]   Go Down
« previous next »
Print
Author Topic: Add a primary key to admin_members  (Read 250 times)
0 Members and 1 Guest are viewing this topic.
Glarawyn
BeBot Developer
Champion
********
Offline Offline

Posts: 414



Add a primary key to admin_members
« on: August 25, 2006, 12: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. Smiley
Logged
Khalem
BeBot Founder
Administrator
Grandmaster
********
Offline Offline

Gender: Male
Posts: 670



WWW
Re: Add a primary key to admin_members
« Reply #1 on: August 25, 2006, 07:37:47 PM »

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
Logged

BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Development > Feedback and Suggestions > Topic: Add a primary key to admin_members
« previous next »
 
Jump to:  

Recent
[request] Raid timers
by Alreadythere
[Today at 11:42:32 AM]

Shared DB online list
by Temar
[Today at 01:55:47 AM]

relay colors
by Temar
[Today at 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]

Change to Bid.php
by Temar
[November 30, 2008, 11:41:44 AM]

OnlineOrg
by Jiheld
[November 29, 2008, 12:44:27 PM]

Silly Newbie Question.
by Temar
[November 29, 2008, 12:00:02 PM]

massive_pvp_time_table 1
by gerborg
[November 29, 2008, 06:55:35 AM]

Bot not see Guild Chat
by Delvar
[November 28, 2008, 08:30:34 AM]

Starting Bot
by Allisande
[November 28, 2008, 07:08:21 AM]
Stats
Members
Total Members: 1243
Latest: Whackoeng
Stats
Total Posts: 11143
Total Topics: 1505
Online Today: 21
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 1
Guests: 21
Total: 22

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.493 seconds with 28 queries. (Pretty URLs adds 0.021s, 4q)
Loading...