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;
14 -- remove duplicates... (hopefully only one duplicate.. failes if > 2...)
15 delete from core_group_member where id in (
18 concat(group_id,'-',user_id) as uid,
30 ALTER TABLE core_group_member ADD UNIQUE KEY unique_group_user (group_id,user_id);