From: edward <edward@roojs.com>
Date: Thu, 20 Oct 2016 05:00:12 +0000 (+0800)
Subject: sql/core_enum.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=748bdd7438657e187656c33636bb4fe66effc90b

sql/core_enum.sql
---

diff --git a/sql/core_enum.sql b/sql/core_enum.sql
index eb3f18b8..90c97445 100644
--- a/sql/core_enum.sql
+++ b/sql/core_enum.sql
@@ -16,6 +16,7 @@ ALTER TABLE core_enum ADD COLUMN is_system_enum INT(2) NOT NULL DEFAULT 0;
 ALTER TABLE core_enum CHANGE COLUMN display_name display_name TEXT NOT NULL;
 
 alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
+alter table  core_enum ADD  INDEX lookup_etype_active(etype, active);
 
 
 UPDATE core_enum SET display_name = name WHERE display_name = '';