Add ResponseTemplate.external_status_code field

3 files changed, 11 insertions, 0 deletions

diff --git a/db/downgrade_0059---0058.sql b/db/downgrade_0059---0058.sql
new file mode 100644
index 000000000..d312f10b4
--- /dev/null
+++ b/db/downgrade_0059---0058.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE response_templates DROP external_status_code;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index 739090480..7d4b90d3d 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -472,6 +472,7 @@ create table response_templates (
     created timestamp not null default current_timestamp,
     auto_response boolean NOT NULL DEFAULT 'f',
     state text,
+    external_status_code text,
     unique(body_id, title)
 );
 
diff --git a/db/schema_0059-response-templates-external_status_code.sql b/db/schema_0059-response-templates-external_status_code.sql
new file mode 100644
index 000000000..38b000a26
--- /dev/null
+++ b/db/schema_0059-response-templates-external_status_code.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE response_templates ADD external_status_code text;
+
+COMMIT;