From c8292b3cddf0a29236cb981111beb4587d7be411 Mon Sep 17 00:00:00 2001 From: friendica Date: Wed, 26 Dec 2012 03:49:50 -0800 Subject: remove the private keywords stuff to reduce directory and search complexity --- install/database.sql | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) (limited to 'install/database.sql') 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` ( -- cgit v1.2.3