diff -r 6fceb66e1ad7 -r 4ae6ada7ea23 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 20 22:18:45 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