From 748bdd7438657e187656c33636bb4fe66effc90b Mon Sep 17 00:00:00 2001 From: edward Date: Thu, 20 Oct 2016 13:00:12 +0800 Subject: [PATCH] sql/core_enum.sql --- sql/core_enum.sql | 1 + 1 file changed, 1 insertion(+) 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 = ''; -- 2.39.2