diff options
| author | Aleksandr Nogikh <nogikh@google.com> | 2025-06-28 17:30:50 +0200 |
|---|---|---|
| committer | Aleksandr Nogikh <nogikh@google.com> | 2025-07-02 09:13:24 +0000 |
| commit | 8eca022fb899f81facfd753a892d33ad794e2846 (patch) | |
| tree | 38e3deed52689f467241e50c885c1c59582d75a0 /syz-cluster/pkg/db/migrations/1_initialize.up.sql | |
| parent | d6d4e158298e946390e54d87a0a808a4238a24b4 (diff) | |
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.
Diffstat (limited to 'syz-cluster/pkg/db/migrations/1_initialize.up.sql')
| -rw-r--r-- | syz-cluster/pkg/db/migrations/1_initialize.up.sql | 2 |
1 files changed, 0 insertions, 2 deletions
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 ( |