From 911c833b12ff2f456e436ad399481098247700ae Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Fri, 9 Nov 2001 18:28:46 +0000 Subject: Schema updates for search changes git-svn-id: file:///svn/phpbb/trunk@1300 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 28 ++++++++++++++++++++++++++++ phpBB/db/postgres_schema.sql | 25 +++++++++++++++++++++++++ 2 files changed, 53 insertions(+) (limited to 'phpBB/db') diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 9efe409650..d061e56b70 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -266,6 +266,34 @@ CREATE TABLE phpbb_search_results ( ); +# -------------------------------------------------------- +# +# Table structure for table `phpbb_search_wordlist` +# +DROP TABLE IF EXISTS phpbb_search_wordlist; +CREATE TABLE phpbb_search_wordlist ( + word_id int(11) NOT NULL auto_increment, + word_text varchar(100) NOT NULL default '', + word_weight tinyint(4) NOT NULL default '0', + PRIMARY KEY (word_id), + KEY word_text (word_text) +) + + +# -------------------------------------------------------- +# +# Table structure for table `phpbb_search_wordmatch` +# +DROP TABLE IF EXISTS phpbb_search_wordmatch; +CREATE TABLE phpbb_search_wordmatch ( + post_id int(11) NOT NULL default '0', + word_id int(11) NOT NULL default '0', + word_count smallint(6) NOT NULL default '0', + title_match tinyint(1) NOT NULL default '0', + KEY word_id (word_id) +) + + # -------------------------------------------------------- # # Table structure for table 'phpbb_session' diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index f91f01d1c7..2597b0e9b7 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -13,6 +13,7 @@ CREATE SEQUENCE phpbb_forums_id_seq start 1 increment 1 maxvalue 2147483647 minv CREATE SEQUENCE phpbb_posts_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_privmsgs_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_ranks_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE phpbb_search_wordlist_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_smilies_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_themes_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_topics_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; @@ -248,6 +249,30 @@ CREATE TABLE phpbb_search_results ( CREATE INDEX session_id_phpbb_search_results ON phpbb_search_results (session_id); +/* -------------------------------------------------------- + Table structure for table phpbb_search_wordlist +-------------------------------------------------------- */ +CREATE TABLE phpbb_search_wordlist ( + word_id int4 DEFAULT nextval('phpbb_search_wordlist_id_seq'::text) NOT NULL, + word_text varchar(100) NOT NULL default '', + word_weight int2 NOT NULL default '0', + CONSTRAINT phpbb_search_results_pkey PRIMARY KEY (word_id), +) +CREATE INDEX word_text_phpbb_search_wordlist ON phpbb_search_wordlist (word_text); + + +/* -------------------------------------------------------- + Table structure for table phpbb_search_wordmatch +-------------------------------------------------------- */ +CREATE TABLE phpbb_search_wordmatch ( + post_id int4 NOT NULL default '0', + word_id int4 NOT NULL default '0', + word_count int2 NOT NULL default '0', + title_match int2 NOT NULL default '0' +) +CREATE INDEX word_id_phpbb_search_wordmatch ON phpbb_search_wordmatch (word_id); + + /* -------------------------------------------------------- Table structure for table phpbb_sessions -------------------------------------------------------- */ -- cgit v1.2.1