diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-08-19 15:44:02 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-08-19 15:46:16 +0100 |
| commit | efa106c52e2668715d17b860a8afa71501691185 (patch) | |
| tree | 510aba995e818f5500b980b2a904a3e790b0b1c8 /db/schema.sql | |
| parent | ad81d87a957b5590fbcba3f2325526a9cddcbb7f (diff) | |
Move "missing" handling to separate column.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql index 609a1445d..5d42d57cf 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -132,6 +132,7 @@ create table problem ( latitude double precision not null, longitude double precision not null, bodies_str text, -- the body(s) we'll report this problem to + bodies_missing text, -- the body(s) we had no contact details for areas text not null, -- the mapit areas this location is in category text not null default 'Other', title text not null, |