diff options
| author | Struan Donald <struan@exo.org.uk> | 2017-12-20 15:58:51 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-03-15 13:17:18 +0000 |
| commit | 935f431ee0da77dd26a78b959d3b9afb89665c0f (patch) | |
| tree | 68b4b80d88cfcd9f2915f091b16927a00f2a0680 /db/schema.sql | |
| parent | 40a3bfb7566b02db2eb6019adcbefeaa19ffb42f (diff) | |
fetch new problems over open311
This enables the display of existing reports from the back end on FMS
if the body is configured to do this.
Reports will not be created if they are missing an id, a lat or a long,
if the lat/long is outside the area covered by the body, if there is
already a report with a matching id, or if we can't parse out the
request time.
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 f2197dc52..9d212e1da 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -54,6 +54,7 @@ create table body ( suppress_alerts boolean not null default 'f', can_be_devolved boolean not null default 'f', send_extended_statuses boolean not null default 'f', + fetch_problems boolean not null default 'f', deleted boolean not null default 'f' ); |