From 4c5fe7626d9fc482e2be8fa66090a99ad6a1141f Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Thu, 12 Jul 2012 17:25:52 +0100 Subject: add in external_source and external_source_id to schema --- db/schema.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'db/schema.sql') diff --git a/db/schema.sql b/db/schema.sql index 832104991..690b7080f 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -198,7 +198,11 @@ create table problem ( send_fail_timestamp timestamp, -- record send_method used, which can be used to infer usefulness of external_id - send_method_used text + send_method_used text, + + -- record details about messages from external sources, eg. message manager + external_source text, + external_source_id text ); create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude); create index problem_user_id_idx on problem ( user_id ); -- cgit v1.2.3