aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2012-10-03 15:23:31 +0100
committerStruan Donald <struan@exo.org.uk>2012-10-03 15:23:31 +0100
commit9c9fb7456d614c7d96881751a14f2dfff5c4225d (patch)
tree9d11778e850a6cb869e209464a58ee0b16e10b18 /db
parentd41c0531baf3f76528668323c7ddb20735e598bb (diff)
add send_extended_statuses conf option and use in send-comments
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql3
-rw-r--r--db/schema_0026-add_send_extended_comments_to_open311conf.sql6
2 files changed, 8 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index d714a463b..ef1bee624 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -446,5 +446,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',
+ send_extended_statuses boolean not null default 'f'
);
diff --git a/db/schema_0026-add_send_extended_comments_to_open311conf.sql b/db/schema_0026-add_send_extended_comments_to_open311conf.sql
new file mode 100644
index 000000000..ee7b44b75
--- /dev/null
+++ b/db/schema_0026-add_send_extended_comments_to_open311conf.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER table open311conf
+ ADD column send_extended_statuses BOOL NOT NULL DEFAULT 'f';
+
+commit;