diff options
Diffstat (limited to 'modules/search/search.install')
| -rw-r--r-- | modules/search/search.install | 29 |
1 files changed, 28 insertions, 1 deletions
diff --git a/modules/search/search.install b/modules/search/search.install index d6ab2fb2b..eddde85d4 100644 --- a/modules/search/search.install +++ b/modules/search/search.install @@ -29,5 +29,32 @@ function search_install() { count float default NULL, PRIMARY KEY (word) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + break; + case 'pgsql': + db_query("CREATE TABLE {search_dataset} ( + sid uint NOT NULL default '0', + type varchar(16) default NULL, + data text NOT NULL + )"); + db_query("CREATE INDEX {search_dataset}_sid_type_idx ON {search_dataset} (sid, type)"); + + db_query("CREATE TABLE {search_index} ( + word varchar(50) NOT NULL default '', + sid uint NOT NULL default '0', + type varchar(16) default NULL, + fromsid uint NOT NULL default '0', + fromtype varchar(16) default NULL, + score float default NULL + )"); + db_query("CREATE INDEX {search_index}_sid_type_idx ON {search_index} (sid, type)"); + db_query("CREATE INDEX {search_index}_from_sid_type_idx ON {search_index} (fromsid, fromtype)"); + db_query("CREATE INDEX {search_index}_word_idx ON {search_index} (word)"); + + db_query("CREATE TABLE {search_total} ( + word varchar(50) NOT NULL default '', + count float default NULL, + PRIMARY KEY (word) + )"); + break; } -}
\ No newline at end of file +} |