1 files changed, 3 insertions, 1 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index e8d823a3b..941f46c2a 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -165,7 +165,9 @@ CREATE TABLE `prefix_groups_entity` (
   `name` text NOT NULL,
   `description` text NOT NULL,
    
-  PRIMARY KEY  (`guid`),
+  PRIMARY KEY  (`guid`),
+  KEY `name` (`name`(50)),
+  KEY `description` (`description`(50)),
   FULLTEXT KEY (`name`,`description`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;