diff options
| author | Dave Arter <davea@mysociety.org> | 2016-12-01 16:51:04 +0000 |
|---|---|---|
| committer | Dave Arter <davea@mysociety.org> | 2017-01-10 10:55:19 +0000 |
| commit | d7c3106d64f8237a4f6388a0e51dcd29bae93ec8 (patch) | |
| tree | e5d18a2c72f11b0ab434cda9305d17eb06661587 | |
| parent | 7eb758ab64d6d179d28dd8ac0acb33c91593e82f (diff) | |
Add ‘state’ field to ResponseTemplate model
| -rw-r--r-- | db/schema.sql | 1 | ||||
| -rw-r--r-- | db/schema_0048-response-templates-add-state.sql | 6 | ||||
| -rw-r--r-- | perllib/FixMyStreet/DB/Result/ResponseTemplate.pm | 6 |
3 files changed, 11 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql index d3bb5040e..e54c6b7b2 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -486,6 +486,7 @@ create table response_templates ( text text not null, created timestamp not null default current_timestamp, auto_response boolean NOT NULL DEFAULT 'f', + state text, unique(body_id, title) ); diff --git a/db/schema_0048-response-templates-add-state.sql b/db/schema_0048-response-templates-add-state.sql new file mode 100644 index 000000000..1bc95ee6d --- /dev/null +++ b/db/schema_0048-response-templates-add-state.sql @@ -0,0 +1,6 @@ +BEGIN; + +ALTER TABLE response_templates + ADD COLUMN state TEXT; + +COMMIT; diff --git a/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm b/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm index 0d4377dba..5a2029eb1 100644 --- a/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm +++ b/perllib/FixMyStreet/DB/Result/ResponseTemplate.pm @@ -33,6 +33,8 @@ __PACKAGE__->add_columns( }, "auto_response", { data_type => "boolean", default_value => \"false", is_nullable => 0 }, + "state", + { data_type => "text", is_nullable => 1 }, ); __PACKAGE__->set_primary_key("id"); __PACKAGE__->add_unique_constraint("response_templates_body_id_title_key", ["body_id", "title"]); @@ -50,8 +52,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07035 @ 2016-08-24 11:29:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KRm0RHbtrzuxzH0S/UAsdw +# Created by DBIx::Class::Schema::Loader v0.07035 @ 2016-12-01 15:10:52 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ySPzQpFwJNki8XBjCNiqZQ __PACKAGE__->many_to_many( contacts => 'contact_response_templates', 'contact' ); |