diff options
| author | friendica <info@friendica.com> | 2012-12-26 03:49:50 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-12-26 03:49:50 -0800 |
| commit | c8292b3cddf0a29236cb981111beb4587d7be411 (patch) | |
| tree | d9e5ed5afbf5ca90d04325c70949ea436a40c578 /install/database.sql | |
| parent | 1aeea64311d1ae104b8fe513bf13c6f7eeb4fa42 (diff) | |
| download | volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.tar.gz volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.tar.bz2 volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.zip | |
remove the private keywords stuff to reduce directory and search complexity
Diffstat (limited to 'install/database.sql')
| -rw-r--r-- | install/database.sql | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/install/database.sql b/install/database.sql index 5581a27c6..990399bc4 100644 --- a/install/database.sql +++ b/install/database.sql @@ -654,8 +654,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `sexual` char(255) NOT NULL, `politic` char(255) NOT NULL, `religion` char(255) NOT NULL, - `pub_keywords` text NOT NULL, - `prv_keywords` text NOT NULL, + `keywords` text NOT NULL, `likes` text NOT NULL, `dislikes` text NOT NULL, `about` text NOT NULL, @@ -687,9 +686,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( KEY `hide_friends` (`hide_friends`), KEY `postal_code` (`postal_code`), KEY `country_name` (`country_name`), - KEY `profile_guid` (`profile_guid`), - FULLTEXT KEY `pub_keywords` (`pub_keywords`), - FULLTEXT KEY `prv_keywords` (`prv_keywords`) + KEY `profile_guid` (`profile_guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `profile_check` ( |