diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 0a718c8c2..114f0d3d9 100644 --- a/database.sql +++ b/database.sql @@ -315,7 +315,9 @@ CREATE TABLE IF NOT EXISTS `profile` ( `thumb` char(255) NOT NULL, `publish` tinyint(1) NOT NULL DEFAULT '0', `net-publish` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + FULLTEXT KEY `pub_keywords` (`pub_keywords`), + FULLTEXT KEY `prv_keywords` (`prv_keywords`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |