diff options
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 ( |