From 7d03c7688ad03cc960cfb907af0ba282605d35b0 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Tue, 8 Aug 2017 11:50:04 -0700 Subject: [PATCH] the bug status is only absent, found, fixed, and undef --- sql/debbugs_schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql index a9d2232..f2a420d 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -431,7 +431,7 @@ INSERT INTO column_comments VALUES ('src_associations','modified','Time this ent CREATE UNIQUE INDEX src_associations_source_suite ON src_associations(source,suite); -CREATE TYPE bug_status_type AS ENUM ('pending','forwarded','pending-fixed','fixed','absent','done'); +CREATE TYPE bug_status_type AS ENUM ('absent','found','fixed','undef'); CREATE TABLE bug_status_cache ( bug INT NOT NULL REFERENCES bug ON DELETE CASCADE ON UPDATE CASCADE, suite INT REFERENCES suite ON DELETE CASCADE ON UPDATE CASCADE, -- 2.39.2