Add ‘description’ field to ResponsePriority model

Used internally to provide more details about when a priority is applicable.

3 files changed, 13 insertions, 0 deletions

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;