From 8eca022fb899f81facfd753a892d33ad794e2846 Mon Sep 17 00:00:00 2001 From: Aleksandr Nogikh Date: Sat, 28 Jun 2025 17:30:50 +0200 Subject: syz-cluster: make report reply tracking more flexible Replace an UpdateReport() call with a RecordReply(). This will eventually allow us to support the email sender implementations for which we do not immediately know the MessageID of the reported message. --- syz-cluster/pkg/db/migrations/1_initialize.up.sql | 2 -- 1 file changed, 2 deletions(-) (limited to 'syz-cluster/pkg/db/migrations/1_initialize.up.sql') diff --git a/syz-cluster/pkg/db/migrations/1_initialize.up.sql b/syz-cluster/pkg/db/migrations/1_initialize.up.sql index baec817cb..139a9c21f 100644 --- a/syz-cluster/pkg/db/migrations/1_initialize.up.sql +++ b/syz-cluster/pkg/db/migrations/1_initialize.up.sql @@ -107,14 +107,12 @@ CREATE TABLE SessionReports ( SessionID STRING(36) NOT NULL, -- UUID ReportedAt TIMESTAMP, Moderation BOOL, - MessageID STRING(512), Reporter STRING(256), CONSTRAINT FK_SessionReports FOREIGN KEY (SessionID) REFERENCES Sessions (ID), ) PRIMARY KEY(ID); CREATE UNIQUE INDEX NoDupSessionReports ON SessionReports(SessionID, Moderation); CREATE INDEX SessionReportsByStatus ON SessionReports (Reporter, ReportedAt); -CREATE INDEX SessionReportsByMessageID ON SessionReports(Reporter, MessageID); -- Replies on a session report. CREATE TABLE ReportReplies ( -- cgit mrf-deployment