[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.21,1.22

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

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

Modified Files:
	mssql_schema.sql 
Log Message:
Altered wordlist table to ignore duplicates on the word_text index

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -r1.21 -r1.22
*** mssql_schema.sql	11 Feb 2002 13:11:36 -0000	1.21
--- mssql_schema.sql	11 Feb 2002 17:21:30 -0000	1.22
***************
*** 623,627 ****
  GO
  
!  CREATE  UNIQUE  INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) ON [PRIMARY]
  GO
  
--- 623,630 ----
  GO
  
!  CREATE  UNIQUE  INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
! GO
! 
!  CREATE  INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist]([word_common]) ON [PRIMARY]
  GO