summaryrefslogtreecommitdiff
path: root/packages/backend/src/models/NoteDraft.ts
diff options
context:
space:
mode:
Diffstat (limited to 'packages/backend/src/models/NoteDraft.ts')
-rw-r--r--packages/backend/src/models/NoteDraft.ts10
1 files changed, 6 insertions, 4 deletions
diff --git a/packages/backend/src/models/NoteDraft.ts b/packages/backend/src/models/NoteDraft.ts
index 39d85e53dc..6483748bc2 100644
--- a/packages/backend/src/models/NoteDraft.ts
+++ b/packages/backend/src/models/NoteDraft.ts
@@ -12,11 +12,13 @@ import { MiNote } from './Note.js';
import type { MiDriveFile } from './DriveFile.js';
@Entity('note_draft')
+@Index('IDX_NOTE_DRAFT_FILE_IDS', { synchronize: false }) // GIN for fileIds in production
+@Index('IDX_NOTE_DRAFT_VISIBLE_USER_IDS', { synchronize: false }) // GIN for visibleUserIds in production
export class MiNoteDraft {
@PrimaryColumn(id())
public id: string;
- @Index()
+ @Index('IDX_NOTE_DRAFT_REPLY_ID')
@Column({
...id(),
nullable: true,
@@ -31,7 +33,7 @@ export class MiNoteDraft {
@JoinColumn()
public reply: MiNote | null;
- @Index()
+ @Index('IDX_NOTE_DRAFT_RENOTE_ID')
@Column({
...id(),
nullable: true,
@@ -57,7 +59,7 @@ export class MiNoteDraft {
})
public cw: string | null;
- @Index()
+ @Index('IDX_NOTE_DRAFT_USER_ID')
@Column({
...id(),
comment: 'The ID of author.',
@@ -108,7 +110,7 @@ export class MiNoteDraft {
})
public hashtag: string | null;
- @Index()
+ @Index('IDX_NOTE_DRAFT_CHANNEL_ID')
@Column({
...id(),
nullable: true,