From 55751b48ca0cd977bf1d58ed600eff22bf5e8e81 Mon Sep 17 00:00:00 2001 From: Dave Whiteland Date: Wed, 11 Jul 2012 19:03:38 +0100 Subject: added Message Manager ID (mm_msg_id) column and used it --- db/schema_0021-add_mm_msg_id_to_problem.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 db/schema_0021-add_mm_msg_id_to_problem.sql (limited to 'db') diff --git a/db/schema_0021-add_mm_msg_id_to_problem.sql b/db/schema_0021-add_mm_msg_id_to_problem.sql new file mode 100644 index 000000000..12c981ed3 --- /dev/null +++ b/db/schema_0021-add_mm_msg_id_to_problem.sql @@ -0,0 +1,6 @@ +begin; + +ALTER table problem + ADD column mm_msg_id INTEGER; + +commit; -- cgit v1.2.3 From 8c297f3f178dc8e3678ab28d5d686d2ee542d96c Mon Sep 17 00:00:00 2001 From: Dave Whiteland Date: Thu, 12 Jul 2012 11:50:58 +0100 Subject: changed mm_msg_id to external_source_id, and added external_source col --- db/schema_0021-add_external_source_columns_to_problem.sql | 8 ++++++++ db/schema_0021-add_mm_msg_id_to_problem.sql | 6 ------ 2 files changed, 8 insertions(+), 6 deletions(-) create mode 100644 db/schema_0021-add_external_source_columns_to_problem.sql delete mode 100644 db/schema_0021-add_mm_msg_id_to_problem.sql (limited to 'db') diff --git a/db/schema_0021-add_external_source_columns_to_problem.sql b/db/schema_0021-add_external_source_columns_to_problem.sql new file mode 100644 index 000000000..4105ebb39 --- /dev/null +++ b/db/schema_0021-add_external_source_columns_to_problem.sql @@ -0,0 +1,8 @@ +begin; + +ALTER table problem + ADD column external_source TEXT; +ALTER table problem + ADD column external_source_id INTEGER; + +commit; diff --git a/db/schema_0021-add_mm_msg_id_to_problem.sql b/db/schema_0021-add_mm_msg_id_to_problem.sql deleted file mode 100644 index 12c981ed3..000000000 --- a/db/schema_0021-add_mm_msg_id_to_problem.sql +++ /dev/null @@ -1,6 +0,0 @@ -begin; - -ALTER table problem - ADD column mm_msg_id INTEGER; - -commit; -- cgit v1.2.3 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') 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 From 411e5fb12dae9a577eb3924e0f14de171930de27 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Thu, 12 Jul 2012 17:37:54 +0100 Subject: make external_source_id text for flexibility --- db/schema_0021-add_external_source_columns_to_problem.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/schema_0021-add_external_source_columns_to_problem.sql b/db/schema_0021-add_external_source_columns_to_problem.sql index 4105ebb39..a74bcce7d 100644 --- a/db/schema_0021-add_external_source_columns_to_problem.sql +++ b/db/schema_0021-add_external_source_columns_to_problem.sql @@ -3,6 +3,6 @@ begin; ALTER table problem ADD column external_source TEXT; ALTER table problem - ADD column external_source_id INTEGER; + ADD column external_source_id TEXT; commit; -- cgit v1.2.3 From ee7770bb0130e2e0483af203c7410dad8269bdd7 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Thu, 23 Aug 2012 12:45:18 +0100 Subject: initial crude add support option for a problem --- db/schema.sql | 5 ++++- db/schema_0022-add_interest_count_to_problems.sql | 6 ++++++ 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 db/schema_0022-add_interest_count_to_problems.sql (limited to 'db') diff --git a/db/schema.sql b/db/schema.sql index 690b7080f..571c71bcd 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -202,7 +202,10 @@ create table problem ( -- record details about messages from external sources, eg. message manager external_source text, - external_source_id text + external_source_id text, + + -- number of me toos + interest_count integer ); create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude); create index problem_user_id_idx on problem ( user_id ); diff --git a/db/schema_0022-add_interest_count_to_problems.sql b/db/schema_0022-add_interest_count_to_problems.sql new file mode 100644 index 000000000..62092aa0a --- /dev/null +++ b/db/schema_0022-add_interest_count_to_problems.sql @@ -0,0 +1,6 @@ +begin; + +ALTER table problem + ADD COLUMN interest_count integer; + +commit; -- cgit v1.2.3 From 0fad1a7b85ac83dce778b7dd22cd9d74f524ce23 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Wed, 29 Aug 2012 17:43:22 +0100 Subject: allow endpoints to be configured at a category level default cobrand now checks for endpoint configuration and only extra fallbacks are in UK cobrand --- db/schema.sql | 9 ++++++++- db/schema_0023-add_can_be_devolved_and_category_config.sql | 13 +++++++++++++ 2 files changed, 21 insertions(+), 1 deletion(-) create mode 100644 db/schema_0023-add_can_be_devolved_and_category_config.sql (limited to 'db') diff --git a/db/schema.sql b/db/schema.sql index 571c71bcd..819a6c0be 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -82,6 +82,12 @@ create table contacts ( -- extra fields required for open311 extra text + + -- per contact endpoint configuration + endpoint text, + jurisdiction text default '', + api_key text default '', + send_method text ); create unique index contacts_area_id_category_idx on contacts(area_id, category); @@ -445,5 +451,6 @@ create table open311conf ( send_method text, send_comments boolean not null default 'f', comment_user_id int references users(id), - suppress_alerts boolean not null default 'f' + suppress_alerts boolean not null default 'f', + can_be_devolved boolean not null default 'f' ); diff --git a/db/schema_0023-add_can_be_devolved_and_category_config.sql b/db/schema_0023-add_can_be_devolved_and_category_config.sql new file mode 100644 index 000000000..6eba0919a --- /dev/null +++ b/db/schema_0023-add_can_be_devolved_and_category_config.sql @@ -0,0 +1,13 @@ +begin; + +ALTER table open311conf + ADD column can_be_devolved BOOL NOT NULL DEFAULT 'f'; + +ALTER table contacts + ADD column endpoint TEXT, + ADD column jurisdiction TEXT DEFAULT '', + ADD column api_key TEXT DEFAULT '', + ADD column send_method TEXT +; + +commit; -- cgit v1.2.3 From 77bdc1e160163846a2431d64b553f5386103d501 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Wed, 26 Sep 2012 14:45:20 +0100 Subject: correct syntax error in schema --- db/schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/schema.sql b/db/schema.sql index 819a6c0be..a4323f880 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -81,7 +81,7 @@ create table contacts ( note text not null, -- extra fields required for open311 - extra text + extra text, -- per contact endpoint configuration endpoint text, -- cgit v1.2.3