From 1b72087884c1577f3abd0858c9cd575f7d9cb800 Mon Sep 17 00:00:00 2001 From: Struan Donald Date: Wed, 3 Oct 2012 16:33:58 +0100 Subject: order of conditions in constraints need to match exactly to make deployment schema test pass --- db/schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/schema.sql b/db/schema.sql index ef1bee624..437541898 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -174,13 +174,13 @@ create table problem ( or state = 'investigating' or state = 'planned' or state = 'in progress' + or state = 'action scheduled' or state = 'closed' or state = 'fixed' or state = 'fixed - council' or state = 'fixed - user' or state = 'hidden' or state = 'partial' - or state = 'action scheduled' or state = 'unable to fix' or state = 'not responsible' or state = 'duplicate' @@ -312,11 +312,11 @@ create table comment ( or problem_state = 'investigating' or problem_state = 'planned' or problem_state = 'in progress' + or problem_state = 'action scheduled' or problem_state = 'closed' or problem_state = 'fixed' or problem_state = 'fixed - council' or problem_state = 'fixed - user' - or problem_state = 'action scheduled' or problem_state = 'unable to fix' or problem_state = 'not responsible' or problem_state = 'duplicate' -- cgit v1.2.3