From ef8fcfeb4731927a6f63cdbe6f8c3f3b61f52f0c Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:03:51 +0800 Subject: [PATCH] sql/core_group_member.sql --- sql/core_group_member.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql index 4a5eebfc..5226157e 100644 --- a/sql/core_group_member.sql +++ b/sql/core_group_member.sql @@ -10,6 +10,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; +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 ( -- 2.39.2