From: Edward Date: Thu, 8 Nov 2018 06:03:22 +0000 (+0800) Subject: sql/core_group.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=97b2cd167b49300549225721ca211d80475140ba sql/core_group.sql --- diff --git a/sql/core_group.sql b/sql/core_group.sql index 3bea6f30..05e00871 100644 --- a/sql/core_group.sql +++ b/sql/core_group.sql @@ -14,3 +14,4 @@ ALTER TABLE core_group ADD COLUMN type int(11) NOT NULL DEFAULT 0; ALTER TABLE core_group ADD COLUMN leader int(11) NOT NULL default 0; ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0; +ALTER TABLE core_group ADD INDEX lookup_leader (leader); \ No newline at end of file