diff options
Diffstat (limited to 'db/schema_0054-add-state-table.sql')
| -rw-r--r-- | db/schema_0054-add-state-table.sql | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/db/schema_0054-add-state-table.sql b/db/schema_0054-add-state-table.sql index c052f145a..c4be36015 100644 --- a/db/schema_0054-add-state-table.sql +++ b/db/schema_0054-add-state-table.sql @@ -3,10 +3,20 @@ BEGIN; 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 ); +INSERT INTO state (label, type, name) VALUES ('investigating', 'open', 'Investigating'); +INSERT INTO state (label, type, name) VALUES ('in progress', 'open', 'In progress'); +INSERT INTO state (label, type, name) VALUES ('planned', 'open', 'Planned'); +INSERT INTO state (label, type, name) VALUES ('action scheduled', 'open', 'Action scheduled'); +INSERT INTO state (label, type, name) VALUES ('unable to fix', 'closed', 'No further action'); +INSERT INTO state (label, type, name) VALUES ('not responsible', 'closed', 'Not responsible'); +INSERT INTO state (label, type, name) VALUES ('duplicate', 'closed', 'Duplicate'); +INSERT INTO state (label, type, name) VALUES ('internal referral', 'closed', 'Internal referral'); +INSERT INTO state (label, type, name) VALUES ('fixed', 'fixed', 'Fixed'); + ALTER TABLE problem DROP CONSTRAINT problem_state_check; ALTER TABLE comment DROP CONSTRAINT comment_problem_state_check; |