From fbee20dd5eac49e0c6ad7b6ffefec20409bc54f6 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Thu, 30 Jun 2011 18:06:46 +0100 Subject: rename constraint in line with how postgres would name it --- db/schema_0007-add-comment-problem-state.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db/schema_0007-add-comment-problem-state.sql') 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' -- cgit v1.2.3