permit blank updates to be fetched over Open311

Add a per body configuration option to allow Open311 updates to contain
only a status change, rather than emitting a warning when this happens.

3 files changed, 11 insertions, 0 deletions

diff --git a/db/downgrade_0058---0057.sql b/db/downgrade_0058---0057.sql
new file mode 100644
index 000000000..1ce8f527c
--- /dev/null
+++ b/db/downgrade_0058---0057.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body DROP blank_updates_permitted;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index 9d212e1da..739090480 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -55,6 +55,7 @@ create table body (
     can_be_devolved boolean not null default 'f',
     send_extended_statuses boolean not null default 'f',
     fetch_problems boolean not null default 'f',
+    blank_updates_permitted boolean not null default 'f',
     deleted boolean not null default 'f'
 );
 
diff --git a/db/schema_0058-blank-updates-permitted.sql b/db/schema_0058-blank-updates-permitted.sql
new file mode 100644
index 000000000..8b6710bc0
--- /dev/null
+++ b/db/schema_0058-blank-updates-permitted.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body ADD blank_updates_permitted boolean default 'f' not null;
+
+COMMIT;