Add ResponseTemplate.external_status_code field

5 files changed, 16 insertions, 2 deletions

diff --git a/bin/update-schema b/bin/update-schema
index 9660837c6..cfc963e75 100755
--- a/bin/update-schema
+++ b/bin/update-schema
@@ -212,6 +212,7 @@ else {
 # (assuming schema change files are never half-applied, which should be the case)
 sub get_db_version {
     return 'EMPTY' if ! table_exists('problem');
+    return '0059' if column_exists('response_templates', 'external_status_code');
     return '0058' if column_exists('body', 'blank_updates_permitted');
     return '0057' if column_exists('body', 'fetch_problems');
     return '0056' if column_exists('users', 'email_verified');
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;
diff --git a/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm b/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm
index 5a2029eb1..73e0d898e 100644
--- a/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm
+++ b/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm
@@ -35,6 +35,8 @@ __PACKAGE__->add_columns(
   { data_type => "boolean", default_value => \"false", is_nullable => 0 },
   "state",
   { data_type => "text", is_nullable => 1 },
+  "external_status_code",
+  { data_type => "text", is_nullable => 1 },
 );
 __PACKAGE__->set_primary_key("id");
 __PACKAGE__->add_unique_constraint("response_templates_body_id_title_key", ["body_id", "title"]);
@@ -52,8 +54,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07035 @ 2016-12-01 15:10:52
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ySPzQpFwJNki8XBjCNiqZQ
+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2018-03-22 11:18:36
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p0+/jFma6H9eZ3MZAJQRaQ
 
 __PACKAGE__->many_to_many( contacts => 'contact_response_templates', 'contact' );