diff options
| -rwxr-xr-x | bin/update-schema | 1 | ||||
| -rw-r--r-- | db/downgrade_0059---0058.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 1 | ||||
| -rw-r--r-- | db/schema_0059-response-templates-external_status_code.sql | 5 | ||||
| -rw-r--r-- | perllib/FixMyStreet/DB/Result/ResponseTemplate.pm | 6 |
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' ); |