diff -r 6fceb66e1ad7 -r e4345a26f81f 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 Aug 26 10:55:59 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