diff options
| author | Struan Donald <struan@exo.org.uk> | 2011-06-30 18:06:46 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2011-06-30 18:06:46 +0100 |
| commit | fbee20dd5eac49e0c6ad7b6ffefec20409bc54f6 (patch) | |
| tree | 01a296b2325aba1c145282871ae8530bf7c219c3 | |
| parent | 63809a2ec855076deeaf79fe5b57e7173b6a79f8 (diff) | |
rename constraint in line with how postgres would name it
| -rw-r--r-- | db/schema_0007-add-comment-problem-state.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema_0007-add-comment-problem-state.sql b/db/schema_0007-add-comment-problem-state.sql index 8fa361d83..2a3a95ada 100644 --- a/db/schema_0007-add-comment-problem-state.sql +++ b/db/schema_0007-add-comment-problem-state.sql @@ -2,7 +2,7 @@ begin; ALTER TABLE comment ADD column problem_state text; - 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' |