From 58684be7a9b8fec8c90e6f94ecea0c21c3ae5e59 Mon Sep 17 00:00:00 2001
From: Dave Arter <davea@mysociety.org>
Date: Mon, 17 Oct 2016 16:52:49 +0100
Subject: =?UTF-8?q?Add=20=E2=80=98description=E2=80=99=20field=20to=20Resp?=
 =?UTF-8?q?onsePriority=20model?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Used internally to provide more details about when a priority is applicable.
---
 db/downgrade_0047---0046.sql                           | 6 ++++++
 db/schema.sql                                          | 1 +
 db/schema_0047-response-priorities-add-description.sql | 6 ++++++
 3 files changed, 13 insertions(+)
 create mode 100644 db/downgrade_0047---0046.sql
 create mode 100644 db/schema_0047-response-priorities-add-description.sql

(limited to 'db')

diff --git a/db/downgrade_0047---0046.sql b/db/downgrade_0047---0046.sql
new file mode 100644
index 000000000..2f07c44ea
--- /dev/null
+++ b/db/downgrade_0047---0046.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE response_priorities
+    DROP COLUMN description;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index fe45fb4aa..d3bb5040e 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -134,6 +134,7 @@ CREATE TABLE response_priorities (
     body_id int references body(id) not null,
     deleted boolean not null default 'f',
     name text not null,
+    description text,
     unique(body_id, name)
 );
 
diff --git a/db/schema_0047-response-priorities-add-description.sql b/db/schema_0047-response-priorities-add-description.sql
new file mode 100644
index 000000000..1aa856d75
--- /dev/null
+++ b/db/schema_0047-response-priorities-add-description.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE response_priorities
+    ADD COLUMN description TEXT;
+
+COMMIT;
-- 
cgit v1.2.3