diff options
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index c981b0a56..749ee5bcf 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -104,7 +104,8 @@ CREATE TABLE `prefix_objects_entity` ( `title` text NOT NULL,
`description` text NOT NULL,
- PRIMARY KEY (`guid`)
+ PRIMARY KEY (`guid`), + FULLTEXT KEY (`title`,`description`)
) ;
-- Extra information relating to "sites"
@@ -116,7 +117,8 @@ CREATE TABLE `prefix_sites_entity` ( `url` varchar(255) NOT NULL,
PRIMARY KEY (`guid`),
- UNIQUE KEY (`url`)
+ UNIQUE KEY (`url`), + FULLTEXT KEY (`name`,`description`, `url`)
) ;
-- Extra information relating to "users"
@@ -138,7 +140,8 @@ CREATE TABLE `prefix_users_entity` ( PRIMARY KEY (`guid`),
KEY `password` (`password`),
- FULLTEXT KEY `name` (`name`)
+ FULLTEXT KEY `name` (`name`), + FULLTEXT KEY (`name`,`username`)
) ENGINE=MyISAM;
|