diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0047---0046.sql | 6 | ||||
| -rw-r--r-- | db/schema.sql | 1 | ||||
| -rw-r--r-- | db/schema_0047-response-priorities-add-description.sql | 6 |
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; |