diff options
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 ( |