From 03278cab4726f3b45b83e48353f2f0d80a20dfc8 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 10 Sep 2018 10:43:50 +0800 Subject: [PATCH] sql/core_group_member.sql --- sql/core_group_member.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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); -- 2.39.2