diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-06-03 19:05:24 -0400 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-03 19:05:24 -0400 |
| commit | 99e3d4506232f13e311afe1a5bd942b721b2cabe (patch) | |
| tree | 249986229ae7f389ddb26b21f0093068ed059c22 /packages/backend/src/models/Note.ts | |
| parent | fix query plans with IDX_instance_host_key (diff) | |
| download | sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.tar.gz sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.tar.bz2 sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.zip | |
create IDX_note_for_timelines
Diffstat (limited to 'packages/backend/src/models/Note.ts')
| -rw-r--r-- | packages/backend/src/models/Note.ts | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/packages/backend/src/models/Note.ts b/packages/backend/src/models/Note.ts index b9a6f576dc..90b874f29a 100644 --- a/packages/backend/src/models/Note.ts +++ b/packages/backend/src/models/Note.ts @@ -13,6 +13,7 @@ import type { MiDriveFile } from './DriveFile.js'; @Index('IDX_724b311e6f883751f261ebe378', ['userId', 'id']) @Index('IDX_note_userHost_id', { synchronize: false }) // (userHost, id desc) +@Index('IDX_note_for_timelines', { synchronize: false }) // (id desc, channelId, visibility, userHost) @Entity('note') export class MiNote { @PrimaryColumn(id()) |