diff options
| -rw-r--r-- | db/schema_0025-add_more_statuses_to_problem.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/schema_0025-add_more_statuses_to_problem.sql b/db/schema_0025-add_more_statuses_to_problem.sql index 300f12619..9c49c8566 100644 --- a/db/schema_0025-add_more_statuses_to_problem.sql +++ b/db/schema_0025-add_more_statuses_to_problem.sql @@ -21,9 +21,9 @@ BEGIN; ); - ALTER TABLE comment DROP CONSTRAINT problem_state_check; + ALTER TABLE comment DROP CONSTRAINT comment_problem_state_check; - ALTER TABLE comment ADD CONSTRAINT problem_state_check CHECK ( + ALTER TABLE comment ADD CONSTRAINT comment_problem_state_check CHECK ( problem_state = 'confirmed' or problem_state = 'investigating' or problem_state = 'planned' |