From: Edward <edward@roojs.com>
Date: Thu, 8 Nov 2018 06:03:51 +0000 (+0800)
Subject: sql/core_group_member.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=ef8fcfeb4731927a6f63cdbe6f8c3f3b61f52f0c

sql/core_group_member.sql
---

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 (