From: Alan Knowles <alan@roojs.com>
Date: Mon, 10 Sep 2018 02:43:50 +0000 (+0800)
Subject: sql/core_group_member.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=03278cab4726f3b45b83e48353f2f0d80a20dfc8

sql/core_group_member.sql
---

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
index 90beac9f..4a5eebfc 100644
--- a/sql/core_group_member.sql
+++ b/sql/core_group_member.sql
@@ -11,7 +11,7 @@ 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;
 
 
--- remove duplicates...
+-- remove duplicates... (hopefully only one duplicate.. failes if > 2...)
 delete from  core_group_member where id in (
         select mid FROM (
             select
@@ -24,7 +24,7 @@ delete from  core_group_member where id in (
                 group_id,user_id
             having n > 1
         ) s
-)
+);
 
 
 ALTER TABLE core_group_member ADD UNIQUE KEY  unique_group_user (group_id,user_id);