aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
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;