diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0059---0058.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 1 | ||||
| -rw-r--r-- | db/schema_0059-response-templates-external_status_code.sql | 5 |
3 files changed, 11 insertions, 0 deletions
diff --git a/db/downgrade_0059---0058.sql b/db/downgrade_0059---0058.sql new file mode 100644 index 000000000..d312f10b4 --- /dev/null +++ b/db/downgrade_0059---0058.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE response_templates DROP external_status_code; + +COMMIT; diff --git a/db/schema.sql b/db/schema.sql index 739090480..7d4b90d3d 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -472,6 +472,7 @@ create table response_templates ( created timestamp not null default current_timestamp, auto_response boolean NOT NULL DEFAULT 'f', state text, + external_status_code text, unique(body_id, title) ); diff --git a/db/schema_0059-response-templates-external_status_code.sql b/db/schema_0059-response-templates-external_status_code.sql new file mode 100644 index 000000000..38b000a26 --- /dev/null +++ b/db/schema_0059-response-templates-external_status_code.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE response_templates ADD external_status_code text; + +COMMIT; |