diff options
| author | matthew <matthew> | 2007-08-24 00:24:14 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2007-08-24 00:24:14 +0000 |
| commit | d0d0d5dfbb520bed61c0f99b508421a1cb108836 (patch) | |
| tree | cc260553d458bdb88a98190a95dd741db3bd0786 /db/schema.sql | |
| parent | 0d540c056e0e22a9411b5ea090a6b58739ae7e4d (diff) | |
Store all voting areas of problems.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql index eea52a777..4078421e8 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.36 2007-07-11 16:28:13 matthew Exp $ +-- $Id: schema.sql,v 1.37 2007-08-24 00:24:14 matthew Exp $ -- -- secret @@ -123,7 +123,8 @@ create table problem ( postcode text not null, easting double precision not null, northing double precision not null, - council text, -- integer references contacts(area_id), + council text, -- the council(s) we'll report this problem to + areas text not null, -- the voting areas this location is in category text not null default 'Other', title text not null, detail text not null, |