diff options
author | Dave Whiteland <dave@mysociety.org> | 2012-05-02 19:39:19 +0100 |
---|---|---|
committer | Dave Whiteland <dave@mysociety.org> | 2012-05-02 19:39:19 +0100 |
commit | 794f32474a78d3eefcc68ef57370bba74b5625aa (patch) | |
tree | e469eb8007b561ea7efbb77c09ed4c9df45b60a2 /db/schema.sql | |
parent | a7e64618f5a14a4fa73db0450b5ec2b6c33ec5a5 (diff) | |
parent | 16061e060354affb25701a8c6111ee30df2ac19c (diff) |
Merge branch 'barnet-integration'
Diffstat (limited to 'db/schema.sql')
-rw-r--r-- | db/schema.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql index 395d1c07b..5824b2d6d 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -189,7 +189,12 @@ create table problem ( send_questionnaire boolean not null default 't', extra text, -- extra fields required for open311 flagged boolean not null default 'f', - geocode bytea + geocode bytea, + + -- logging sending failures (used by webservices) + send_fail_count integer not null default 0, + send_fail_reason text, + send_fail_timestamp timestamp ); create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude); create index problem_user_id_idx on problem ( user_id ); @@ -419,5 +424,6 @@ create table open311conf ( area_id integer not null unique, endpoint text not null, jurisdiction text, - api_key text + api_key text, + send_method text ); |