X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_group_member.sql;h=5226157e2632ae1c03c3743755d61da27b7c0e6c;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=8375324ae15b0f84a64a18cef63624f1d40b3d95;hpb=a8790631e50b32c8e9b10f38f382439052b04480;p=Pman.Core

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
index 8375324a..5226157e 100644
--- a/sql/core_group_member.sql
+++ b/sql/core_group_member.sql
@@ -1,10 +1,31 @@
 -- BC name..
- 
+
 CREATE TABLE  core_group_member  (
     id int(11)  NOT NULL AUTO_INCREMENT,
     PRIMARY KEY (id)
 );
-ALTER TABLE core_group_member ADD COLUMN  group_id int(11) default NULL;
+
+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 ADD UNIQUE KEY `unique_group_user` (`group_id`,`user_id`);
+ALTER TABLE core_group_member ADD INDEX lookup_user_id (user_id);
+
+-- remove duplicates... (hopefully only one duplicate.. failes if > 2...)
+delete from  core_group_member where id in (
+        select mid FROM (
+            select
+                concat(group_id,'-',user_id) as uid,
+                max(id) as mid,
+                count(*) as n
+            from
+                core_group_member
+            group by
+                group_id,user_id
+            having n > 1
+        ) s
+);
+
+
+ALTER TABLE core_group_member ADD UNIQUE KEY  unique_group_user (group_id,user_id);