diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-10-03 16:25:53 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-10-03 16:25:53 +0100 |
| commit | 2605d8578e622be0db48d3d234059e8e9951e813 (patch) | |
| tree | 3f28f32c3220fa3aa5cb2400d45c25f030dfbbd5 /db | |
| parent | 9c9fb7456d614c7d96881751a14f2dfff5c4225d (diff) | |
correct name of comment state constraint
Diffstat (limited to 'db')
| -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' |