allow endpoints to be configured at a category level

default cobrand now checks for endpoint configuration and only
extra fallbacks are in UK cobrand

2 files changed, 21 insertions, 1 deletions

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;