aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0020-add_suppress_alerts_to_open311.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2012-05-11 13:23:42 +0100
committerStruan Donald <struan@exo.org.uk>2012-05-11 13:23:42 +0100
commitbb5f5ee3b87bc5d468dd6926e2a81fa91000cd11 (patch)
tree20d06875d78783bf719a194a94a97055c4fdd153 /db/schema_0020-add_suppress_alerts_to_open311.sql
parent2b93b526a5e8acf48e4ee112e2f5feb8436be1d2 (diff)
add in schema update file for suppress_alerts
Diffstat (limited to 'db/schema_0020-add_suppress_alerts_to_open311.sql')
-rw-r--r--db/schema_0020-add_suppress_alerts_to_open311.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/db/schema_0020-add_suppress_alerts_to_open311.sql b/db/schema_0020-add_suppress_alerts_to_open311.sql
new file mode 100644
index 000000000..26fc54617
--- /dev/null
+++ b/db/schema_0020-add_suppress_alerts_to_open311.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER table open311conf
+ ADD column suppress_alerts BOOL NOT NULL DEFAULT 'f';
+
+commit;