From d7c3106d64f8237a4f6388a0e51dcd29bae93ec8 Mon Sep 17 00:00:00 2001
From: Dave Arter <davea@mysociety.org>
Date: Thu, 1 Dec 2016 16:51:04 +0000
Subject: =?UTF-8?q?Add=20=E2=80=98state=E2=80=99=20field=20to=20ResponseTe?=
 =?UTF-8?q?mplate=20model?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema.sql                                   | 1 +
 db/schema_0048-response-templates-add-state.sql | 6 ++++++
 2 files changed, 7 insertions(+)
 create mode 100644 db/schema_0048-response-templates-add-state.sql

(limited to 'db')

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;
-- 
cgit v1.2.3