-- BC name..
-RENAME TABLE Group_Members TO group_members;
-CREATE TABLE group_members (
+CREATE TABLE core_group_member (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
);
-ALTER TABLE group_members ADD COLUMN group_id int(11) default NULL;
-ALTER TABLE group_members ADD COLUMN user_id int(11) NOT NULL default 0;
-
\ No newline at end of file
+ALTER TABLE core_group_member CHANGE COLUMN group_id group_id int(11) NOT NULL default 0;
+ALTER TABLE core_group_member ADD COLUMN group_id int(11) NOT NULL default 0;
+
+ALTER TABLE core_group_member ADD COLUMN user_id int(11) NOT NULL default 0;
+
+ALTER TABLE core_group_member ADD UNIQUE KEY unique_group_user (group_id,user_id);