From bb99a8917a9b7fc38f0c0847f45c68659791b54a Mon Sep 17 00:00:00 2001
From: Dave Arter <davea@mysociety.org>
Date: Wed, 14 Dec 2016 17:31:02 +0000
Subject: Add external_id field to ResponsePriority for use with Exor

---
 db/schema.sql                                          | 1 +
 db/schema_0049-response-priorities-add-external_id.sql | 6 ++++++
 2 files changed, 7 insertions(+)
 create mode 100644 db/schema_0049-response-priorities-add-external_id.sql

(limited to 'db')

diff --git a/db/schema.sql b/db/schema.sql
index e54c6b7b2..23db82b65 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -135,6 +135,7 @@ CREATE TABLE response_priorities (
     deleted boolean not null default 'f',
     name text not null,
     description text,
+    external_id text,
     unique(body_id, name)
 );
 
diff --git a/db/schema_0049-response-priorities-add-external_id.sql b/db/schema_0049-response-priorities-add-external_id.sql
new file mode 100644
index 000000000..1d8a1ba1e
--- /dev/null
+++ b/db/schema_0049-response-priorities-add-external_id.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE response_priorities
+    ADD COLUMN external_id TEXT;
+
+COMMIT;
-- 
cgit v1.2.3