diff options
| -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' |