helpers/database_postgresql8_tmpl.sql
changeset 3 2fdc9cc89502
parent 1 6fceb66e1ad7
     1.1 --- a/helpers/database_postgresql8_tmpl.sql	Wed Jul 01 10:48:22 2009 +0200
     1.2 +++ b/helpers/database_postgresql8_tmpl.sql	Wed Jul 22 14:04:05 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