From 76d71b7cda3c62a89fab6431edd6f3d64c0ece93 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Sun, 30 Jun 2019 15:16:06 -0700 Subject: [PATCH] add msid to bug_status VIEW --- sql/debbugs_schema.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql index 4b15478..5e37594 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -573,6 +573,8 @@ CREATE VIEW bug_status --(id,bug_num,tags,subject, JOIN src_pkg sp ON bsp.src_pkg=sp.id WHERE bsp.bug=b.id) AS package ) AS package, + (SELECT msgid FROM message m LEFT JOIN bug_message bm ON bm.message=m.id + WHERE bm.bug=b.id ORDER BY m.sent_date ASC limit 1) AS message_id, b.submitter_full AS originator, EXTRACT(EPOCH FROM b.log_modified) AS log_modified, EXTRACT(EPOCH FROM b.creation) AS date, -- 2.39.2