
diff -r 6fceb66e1ad7 -r 60c237bb677a 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	Sat May 01 18:51:57 2010 +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 
 




