1.1 --- a/helpers/database_postgresql8_tmpl.sql Fri Jun 26 16:48:50 2009 +0200
1.2 +++ b/helpers/database_postgresql8_tmpl.sql Wed Aug 12 13:03:23 2009 +0200
1.3 @@ -69,10 +69,11 @@
1.4 group_id INTEGER REFERENCES groups(group_id) ON DELETE CASCADE,
1.5 listaddress VARCHAR(255),
1.6
1.7 - PRIMARY KEY(group_id, listaddress),
1.8 - UNIQUE(listaddress)
1.9 + PRIMARY KEY(group_id, listaddress)
1.10 );
1.11
1.12 +CREATE INDEX listaddress_key ON groups2list USING btree(listaddress);
1.13 +
1.14 /*
1.15 Configuration table, containing key/value pairs
1.16