helpers/database_postgresql8_tmpl.sql
changeset 90 2ed2497d4559
parent 1 6fceb66e1ad7
     1.1 --- a/helpers/database_postgresql8_tmpl.sql	Fri Jun 26 16:48:50 2009 +0200
     1.2 +++ b/helpers/database_postgresql8_tmpl.sql	Mon Oct 17 19:12:42 2011 +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