From: Don Armstrong <don@donarmstrong.com>
Date: Sun, 30 Jun 2019 22:16:06 +0000 (-0700)
Subject: add msid to bug_status VIEW
X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=76d71b7cda3c62a89fab6431edd6f3d64c0ece93

add msid to bug_status VIEW
---

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,