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/postgres_schema.sql | |
| 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/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 25 |
1 files changed, 25 insertions, 0 deletions
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 ( |