looking at the table, if you leave it as is and only update based on charid?
on a #bot saveraid
delete * from botgroups where charid=<current charid>
then save the new raid info
the on a #bot spawnraid pull data based on the current char id.
the sql to change the table is pretty simple
Code:
alter table botgroups drop primary key
if you really want to have a primary key somewhere you could do
Code:
alter table botgroups add column `entry` int(11) not null auto_increment primary key
it won't add it at the beginning (couldn't figure out how/why) but it'll be there.