diff options
| author | root <root> | 2008-11-10 10:14:09 +0000 |
|---|---|---|
| committer | root <root> | 2008-11-10 10:14:09 +0000 |
| commit | b726413016ee6a229b41a30e49f2551a669f65df (patch) | |
| tree | 5a2af3223f1da47caed7500f54aa26e515e96c5e | |
| parent | d9363642a135c38cb7af1f65610101ca2af92a4f (diff) | |
New index.
| -rw-r--r-- | db/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index d80fb5a7b..efe6aefc2 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.42 2008-10-24 09:52:42 matthew Exp $ +-- $Id: schema.sql,v 1.43 2008-11-10 10:14:09 root Exp $ -- -- secret @@ -167,6 +167,8 @@ create table questionnaire ( new_state text ); +create index questionnaire_problem_id_idx on questionnaire using btree (problem_id); + -- angle_between A1 A2 -- Given two angles A1 and A2 on a circle expressed in radians, return the -- smallest angle between them. |