From: Don Armstrong Date: Tue, 8 Aug 2017 18:50:04 +0000 (-0700) Subject: the bug status is only absent, found, fixed, and undef X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=7d03c7688ad03cc960cfb907af0ba282605d35b0 the bug status is only absent, found, fixed, and undef --- 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,