[Phpbb-checkins] CVS: phpBB2/db mysql_schema.sql,1.82,1.83 postgres_schema.sql,1.55,1.56

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/db
In directory usw-pr-cvs1:/tmp/cvs-serv28036/db

Modified Files:
	mysql_schema.sql postgres_schema.sql 
Log Message:
Schema updates for search changes

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/mysql_schema.sql,v
retrieving revision 1.82
retrieving revision 1.83
diff -C2 -r1.82 -r1.83
*** mysql_schema.sql	2001/10/11 22:01:11	1.82
--- mysql_schema.sql	2001/11/09 18:28:46	1.83
***************
*** 269,272 ****
--- 269,300 ----
  # --------------------------------------------------------
  #
+ # 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'
  #

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/postgres_schema.sql,v
retrieving revision 1.55
retrieving revision 1.56
diff -C2 -r1.55 -r1.56
*** postgres_schema.sql	2001/10/11 22:01:11	1.55
--- postgres_schema.sql	2001/11/09 18:28:46	1.56
***************
*** 14,17 ****
--- 14,18 ----
  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;
***************
*** 247,250 ****
--- 248,275 ----
  );
  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);