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
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