
diff -r 6fceb66e1ad7 -r ad210aa137a4 helpers/database_postgresql8_tmpl.sql
--- a/helpers/database_postgresql8_tmpl.sql	Fri Jun 26 16:48:50 2009 +0200
+++ b/helpers/database_postgresql8_tmpl.sql	Thu Aug 06 18:34:10 2009 +0200
@@ -69,10 +69,11 @@
   group_id   INTEGER REFERENCES groups(group_id) ON DELETE CASCADE,
   listaddress VARCHAR(255),
 
-  PRIMARY KEY(group_id, listaddress),
-  UNIQUE(listaddress)
+  PRIMARY KEY(group_id, listaddress)
 );
 
+CREATE INDEX listaddress_key ON groups2list USING btree(listaddress);
+
 /* 
   Configuration table, containing key/value pairs 
 




