You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@spamassassin.apache.org by pa...@apache.org on 2005/08/03 03:29:59 UTC

svn commit: r227145 - /spamassassin/branches/3.1/sql/bayes_pg.sql

Author: parker
Date: Tue Aug  2 18:29:56 2005
New Revision: 227145

URL: http://svn.apache.org/viewcvs?rev=227145&view=rev
Log:
Bug 4510: Add missing UNIQUE index for bayes_vars

Modified:
    spamassassin/branches/3.1/sql/bayes_pg.sql

Modified: spamassassin/branches/3.1/sql/bayes_pg.sql
URL: http://svn.apache.org/viewcvs/spamassassin/branches/3.1/sql/bayes_pg.sql?rev=227145&r1=227144&r2=227145&view=diff
==============================================================================
--- spamassassin/branches/3.1/sql/bayes_pg.sql (original)
+++ spamassassin/branches/3.1/sql/bayes_pg.sql Tue Aug  2 18:29:56 2005
@@ -46,7 +46,7 @@
   PRIMARY KEY  (id)
 ) WITHOUT OIDS;
 
-CREATE INDEX bayes_vars_idx1 ON bayes_vars (username);
+CREATE UNIQUE INDEX bayes_vars_idx1 ON bayes_vars (username);
 
 CREATE OR REPLACE FUNCTION put_token(integer, bytea, integer, integer, integer) RETURNS bool AS ' 
 DECLARE