diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-05-22 14:07:05 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-05-22 14:07:05 +0000 |
| commit | 6615b6f4d827811046564cd004bd167b4c3c38bf (patch) | |
| tree | a8b13babab0bb2741e9612f46d0e6a113bd29026 /engine/schema/mysql.sql | |
| parent | 18dd81e15a1159e73f0371e91b62640db3f5e9bf (diff) | |
| download | elgg-6615b6f4d827811046564cd004bd167b4c3c38bf.tar.gz elgg-6615b6f4d827811046564cd004bd167b4c3c38bf.tar.bz2 | |
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
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; |