diff options
Diffstat (limited to 'engine/schema/mysql.sql')
-rw-r--r-- | engine/schema/mysql.sql | 4 |
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; |