diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-10-01 16:00:30 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-10-01 17:38:26 +0100 |
| commit | 515190b62e24ab43e150c4d65b55c774682f2578 (patch) | |
| tree | 80da0015ec7bfb0fb8dec41d54f36d8d9f0fbbdf /db/schema.sql | |
| parent | 741abb421c66bdf91a60a988d7250feb59c6ca45 (diff) | |
tidy up status names in DB, improve tests a little
Diffstat (limited to 'db/schema.sql')
| -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 60ad8eda4..d714a463b 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -182,7 +182,7 @@ create table problem ( or state = 'partial' or state = 'action scheduled' or state = 'unable to fix' - or state = 'not councils responsibility' + or state = 'not responsible' or state = 'duplicate' ), lang text not null default 'en-gb', @@ -318,7 +318,7 @@ create table comment ( or problem_state = 'fixed - user' or problem_state = 'action scheduled' or problem_state = 'unable to fix' - or problem_state = 'not councils responsibility' + or problem_state = 'not responsible' or problem_state = 'duplicate' ), -- other fields? one to indicate whether this was written by the council |