diff options
Diffstat (limited to 'modules/search/search.install')
| -rw-r--r-- | modules/search/search.install | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/modules/search/search.install b/modules/search/search.install new file mode 100644 index 000000000..61481d5ed --- /dev/null +++ b/modules/search/search.install @@ -0,0 +1,32 @@ +<?php + +function search_install() { + switch ($GLOBALS['db_type']) { + case 'mysql': + case 'mysqli': + db_query("CREATE TABLE {search_dataset} ( + sid int(10) unsigned NOT NULL default '0', + type varchar(16) default NULL, + data longtext NOT NULL, + KEY sid_type (sid, type) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + + db_query("CREATE TABLE {search_index} ( + word varchar(50) NOT NULL default '', + sid int(10) unsigned NOT NULL default '0', + type varchar(16) default NULL, + fromsid int(10) unsigned NOT NULL default '0', + fromtype varchar(16) default NULL, + score float default NULL, + KEY sid_type (sid, type), + KEY from_sid_type (fromsid, fromtype), + KEY word (word) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + + db_query("CREATE TABLE {search_total} ( + word varchar(50) NOT NULL default '', + count float default NULL, + PRIMARY KEY (word) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + } +}
\ No newline at end of file |