From 6615b6f4d827811046564cd004bd167b4c3c38bf Mon Sep 17 00:00:00 2001 From: marcus Date: Fri, 22 May 2009 14:07:05 +0000 Subject: Closes #1030: Group title and description search added, refs #965 git-svn-id: https://code.elgg.org/elgg/trunk@3300 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 4 +++- engine/schema/upgrades/2009052201.sql | 5 +++++ 2 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 engine/schema/upgrades/2009052201.sql (limited to 'engine/schema') 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; diff --git a/engine/schema/upgrades/2009052201.sql b/engine/schema/upgrades/2009052201.sql new file mode 100644 index 000000000..b825f9936 --- /dev/null +++ b/engine/schema/upgrades/2009052201.sql @@ -0,0 +1,5 @@ +ALTER TABLE `prefix_groups_entity` DROP KEY `name`; +ALTER TABLE `prefix_groups_entity` ADD KEY `name` (`name`(50)); + +ALTER TABLE `prefix_groups_entity` DROP KEY `description`; +ALTER TABLE `prefix_groups_entity` ADD KEY `description` (`description`(50)); -- cgit v1.2.3