diff options
| author | matthew <matthew> | 2009-03-10 12:25:10 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2009-03-10 12:25:10 +0000 |
| commit | 52afed45fda11d811e5250eea75c716400851fda (patch) | |
| tree | 57bc9c65a92d45d95e4b363e40b565046142a646 /db/schema.sql | |
| parent | 67621e3486e4c4eaa03ef7bd17c362bd4e688f89 (diff) | |
Add new index.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index efe6aefc2..95038b7d9 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -4,7 +4,7 @@ -- Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved. -- Email: matthew@mysociety.org; WWW: http://www.mysociety.org/ -- --- $Id: schema.sql,v 1.43 2008-11-10 10:14:09 root Exp $ +-- $Id: schema.sql,v 1.44 2009-03-10 12:25:10 matthew Exp $ -- -- secret @@ -284,6 +284,7 @@ create table alert_sent ( parameter text, -- e.g. Update ID for new updates whenqueued timestamp not null default ms_current_timestamp() ); +create index alert_sent_alert_id_parameter_idx on alert_sent(alert_id, parameter); -- To record details of people who submit via Flickr/ iPhone/ etc. create table partial_user ( |