diff -r 6fceb66e1ad7 -r 41d6c0cac8b3 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 Oct 13 03:09:22 2011 +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