From 7c5ac2cbb407fbcdd06f7561ccbcff56c9da6a14 Mon Sep 17 00:00:00 2001 From: syuilo Date: Fri, 14 Aug 2020 15:24:55 +0900 Subject: perf(server): Add isSensitive index to improve query performance --- src/models/entities/drive-file.ts | 1 + 1 file changed, 1 insertion(+) (limited to 'src') diff --git a/src/models/entities/drive-file.ts b/src/models/entities/drive-file.ts index c02b9f3636..680a40bc06 100644 --- a/src/models/entities/drive-file.ts +++ b/src/models/entities/drive-file.ts @@ -145,6 +145,7 @@ export class DriveFile { @JoinColumn() public folder: DriveFolder | null; + @Index() @Column('boolean', { default: false, comment: 'Whether the DriveFile is NSFW.' -- cgit v1.2.3-freya