   uid smallint,
   preference varchar(128),
   value varchar(128),
-  UNIQUE (preference, uid)
+  UNIQUE (uid, preference)
 ) WITHOUT OIDS;

/* $Id: pgsql_objects.sql,v 1.7 2005/04/11 00:58:27 jonz Exp $ */

CREATE TABLE dspam_token_data (
  uid smallint,

  spam_hits int,
  innocent_hits int,
  last_hit date,
  UNIQUE (uid, token)
) WITHOUT OIDS;

CREATE TABLE dspam_signature_data (
  uid smallint,
