From 935f431ee0da77dd26a78b959d3b9afb89665c0f Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Wed, 20 Dec 2017 15:58:51 +0000
Subject: 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.
---
 db/schema_0057-fetch-problems.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 db/schema_0057-fetch-problems.sql

(limited to 'db/schema_0057-fetch-problems.sql')

diff --git a/db/schema_0057-fetch-problems.sql b/db/schema_0057-fetch-problems.sql
new file mode 100644
index 000000000..7419eb032
--- /dev/null
+++ b/db/schema_0057-fetch-problems.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body ADD fetch_problems boolean default 'f' not null;
+
+COMMIT;
-- 
cgit v1.2.3

