From a81d4ca4ffb35bf344444880815f2da02ac2c78a Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Tue, 7 Mar 2017 18:59:41 -0800 Subject: [PATCH] add recv correspondent type --- 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 e7a88906..95f742ed 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -511,7 +511,7 @@ INSERT INTO table_comments VALUES ('correspondent_full_name','Full names of BTS INSERT INTO column_comments VALUES ('correspondent_full_name','correspondent','Correspondent ID (matches correspondent)'); INSERT INTO column_comments VALUES ('correspondent_full_name','full_name','Correspondent full name (includes e-mail address)'); -CREATE TYPE message_correspondent_type AS ENUM ('to','from','envfrom','cc'); +CREATE TYPE message_correspondent_type AS ENUM ('to','from','envfrom','cc','recv'); CREATE TABLE message_correspondent ( message INT NOT NULL REFERENCES message ON DELETE CASCADE ON UPDATE CASCADE, -- 2.39.5