3 CREATE TABLE core_group_member (
4 id int(11) NOT NULL AUTO_INCREMENT,
8 ALTER TABLE core_group_member CHANGE COLUMN group_id group_id int(11) NOT NULL default 0;
9 ALTER TABLE core_group_member ADD COLUMN group_id int(11) NOT NULL default 0;
11 ALTER TABLE core_group_member ADD COLUMN user_id int(11) NOT NULL default 0;
13 ALTER TABLE core_group_member ADD INDEX lookup_user_id (user_id);
15 -- remove duplicates... (hopefully only one duplicate.. failes if > 2...)
16 delete from core_group_member where id in (
19 concat(group_id,'-',user_id) as uid,
31 ALTER TABLE core_group_member ADD UNIQUE KEY unique_group_user (group_id,user_id);