diff -r 6fceb66e1ad7 -r bb1c8a7b774c 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 Wed Dec 31 12:07:40 2014 +0100 @@ -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