diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-10-03 16:33:58 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-10-03 16:33:58 +0100 |
| commit | 1b72087884c1577f3abd0858c9cd575f7d9cb800 (patch) | |
| tree | 9b07da5bdd58a4ac7fe5a1409cd6a4f63b840c66 /db | |
| parent | 2605d8578e622be0db48d3d234059e8e9951e813 (diff) | |
order of conditions in constraints need to match exactly to make deployment schema test pass
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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' |