Diff of /spamassassin/branches/3.1/sql/bayes_pg.sql

Parent Directory | Revision Log | Patch

--- spamassassin/branches/3.1/sql/bayes_pg.sql	2005/08/03 01:28:22	227144
+++ spamassassin/branches/3.1/sql/bayes_pg.sql	2005/08/03 01:29:56	227145
@@ -46,7 +46,7 @@ CREATE TABLE bayes_vars (
   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