diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-11-09 18:28:46 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-11-09 18:28:46 +0000 |
| commit | 911c833b12ff2f456e436ad399481098247700ae (patch) | |
| tree | 6fda5891cffa9b257d281ea53773930a9aad3284 /phpBB/db | |
| parent | d265bbc317f299bdb0137f678d6050ad302136ff (diff) | |
| download | forums-911c833b12ff2f456e436ad399481098247700ae.tar forums-911c833b12ff2f456e436ad399481098247700ae.tar.gz forums-911c833b12ff2f456e436ad399481098247700ae.tar.bz2 forums-911c833b12ff2f456e436ad399481098247700ae.tar.xz forums-911c833b12ff2f456e436ad399481098247700ae.zip | |
Schema updates for search changes
git-svn-id: file:///svn/phpbb/trunk@1300 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 28 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 25 |
2 files changed, 53 insertions, 0 deletions
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 @@ -268,6 +268,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' # # Note that if you're running 3.23.x you may want to make 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; @@ -249,6 +250,30 @@ CREATE INDEX session_id_phpbb_search_results ON phpbb_search_results (session_i /* -------------------------------------------------------- + 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 -------------------------------------------------------- */ CREATE TABLE phpbb_sessions ( |