aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2012-03-22 17:34:29 +0000
committerStruan Donald <struan@exo.org.uk>2012-03-22 17:34:29 +0000
commit420c6becdb08d90da03f222a492893cd993772a1 (patch)
treefc67d3fe3a313a4671d488c929a17504e932339e /db
parent42efc3998a3e91cb03454c86c0615dfa84c8ae91 (diff)
add in send method code
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql3
-rw-r--r--db/schema_0013-add_send_method_column_to_open311conf.sql7
2 files changed, 9 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index d54cecd5a..ab323ee1a 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -420,5 +420,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
);
diff --git a/db/schema_0013-add_send_method_column_to_open311conf.sql b/db/schema_0013-add_send_method_column_to_open311conf.sql
new file mode 100644
index 000000000..516fdd698
--- /dev/null
+++ b/db/schema_0013-add_send_method_column_to_open311conf.sql
@@ -0,0 +1,7 @@
+
+begin;
+
+ALTER table open311conf
+ ADD column send_method TEXT;
+
+commit;