aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorMatthew Somerville <matthew-github@dracos.co.uk>2017-08-22 16:27:32 +0100
committerMatthew Somerville <matthew-github@dracos.co.uk>2017-08-31 15:37:09 +0100
commit27110ac506f071ad0c5925ef74de1321514c23c8 (patch)
tree61699c019d14a0b6abf4db20734b93f7c09d6093 /db/schema.sql
parentb43813d8f3c5bae07f0c7b9fe120bff32611d8bb (diff)
Remove hardcoded states from Problem model.
We keep the internal states hardcoded, plus the core open (confirmed) and closed ones, but the remainder are moved to the database.
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 12e66b53a..fedab2b9d 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -519,6 +519,6 @@ CREATE TABLE report_extra_fields (
CREATE TABLE state (
id serial not null primary key,
label text not null unique,
- type text not null check (type = 'open' OR type = 'closed'),
+ type text not null check (type = 'open' OR type = 'closed' OR type = 'fixed'),
name text not null unique
);