diff options
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 28 |
1 files changed, 28 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 |