aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql9
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;