diff options
| author | Friendika <info@friendika.com> | 2011-03-22 16:34:12 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-03-22 16:34:12 -0700 |
| commit | e0202d82a1e33dc2c2ed5b8fcec46440cc905d3f (patch) | |
| tree | 09eed96c46fd65feac695d806121d037012546a9 /database.sql | |
| parent | 8f31935b7da523ba03b51459d7596fc5e6eb2854 (diff) | |
| download | volse-hubzilla-e0202d82a1e33dc2c2ed5b8fcec46440cc905d3f.tar.gz volse-hubzilla-e0202d82a1e33dc2c2ed5b8fcec46440cc905d3f.tar.bz2 volse-hubzilla-e0202d82a1e33dc2c2ed5b8fcec46440cc905d3f.zip | |
add fulltext index on keywords, missed some directory localisations
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; -- -------------------------------------------------------- |