added can_display_external_id because external ids are not always useful for publishing, using send_method_used to determine that on a council-by-council basis

1 files changed, 4 insertions, 1 deletions

diff --git a/db/schema.sql b/db/schema.sql
index 5824b2d6d..e1205099d 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -194,7 +194,10 @@ create table problem (
     -- logging sending failures (used by webservices)
     send_fail_count integer not null default 0, 
     send_fail_reason text, 
-    send_fail_timestamp timestamp
+    send_fail_timestamp timestamp,
+    
+    -- record send_method used, which can be used to infer usefulness of external_id
+    send_method_used text
 );
 create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);
 create index problem_user_id_idx on problem ( user_id );