diff options
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 20 |
1 files changed, 17 insertions, 3 deletions
diff --git a/db/schema.sql b/db/schema.sql index 6e9396f45..7cb2f3257 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -84,7 +84,13 @@ create table contacts ( extra text, -- for things like missed bin collections - non_public boolean default 'f' + non_public boolean default 'f', + + -- 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); @@ -204,7 +210,14 @@ create table problem ( send_method_used text, -- for things like missed bin collections - non_public BOOLEAN default 'f' + non_public BOOLEAN default 'f', + + -- record details about messages from external sources, eg. message manager + external_source text, + external_source_id text, + + -- number of me toos + interest_count integer default 0 ); create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude); create index problem_user_id_idx on problem ( user_id ); @@ -444,5 +457,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' ); |