summaryrefslogtreecommitdiff
path: root/packages/backend/src/models/Emoji.ts
diff options
context:
space:
mode:
Diffstat (limited to 'packages/backend/src/models/Emoji.ts')
-rw-r--r--packages/backend/src/models/Emoji.ts2
1 files changed, 2 insertions, 0 deletions
diff --git a/packages/backend/src/models/Emoji.ts b/packages/backend/src/models/Emoji.ts
index d62b6e9f6f..8dff8fd153 100644
--- a/packages/backend/src/models/Emoji.ts
+++ b/packages/backend/src/models/Emoji.ts
@@ -8,6 +8,7 @@ import { id } from './util/id.js';
@Entity('emoji')
@Index(['name', 'host'], { unique: true })
+@Index('IDX_EMOJI_ROLE_IDS', { synchronize: false }) // GIN for roleIdsThatCanBeUsedThisEmojiAsReaction in production
export class MiEmoji {
@PrimaryColumn(id())
public id: string;
@@ -32,6 +33,7 @@ export class MiEmoji {
@Column('varchar', {
length: 128, nullable: true,
})
+ @Index('IDX_EMOJI_CATEGORY')
public category: string | null;
@Column('varchar', {