summaryrefslogtreecommitdiff
path: root/packages/backend/src/models
diff options
context:
space:
mode:
authorHazelnoot <acomputerdog@gmail.com>2025-06-03 19:08:20 -0400
committerHazelnoot <acomputerdog@gmail.com>2025-06-03 19:08:20 -0400
commitd34c4df031e9c03722af9a2743015fc53de58d73 (patch)
tree2be57f7d0337a46aacc46ac35007ac1834c2be53 /packages/backend/src/models
parentcreate IDX_note_for_timelines (diff)
downloadsharkey-d34c4df031e9c03722af9a2743015fc53de58d73.tar.gz
sharkey-d34c4df031e9c03722af9a2743015fc53de58d73.tar.bz2
sharkey-d34c4df031e9c03722af9a2743015fc53de58d73.zip
create IDX_instance_host_filters
Diffstat (limited to 'packages/backend/src/models')
-rw-r--r--packages/backend/src/models/Instance.ts3
1 files changed, 2 insertions, 1 deletions
diff --git a/packages/backend/src/models/Instance.ts b/packages/backend/src/models/Instance.ts
index 0022e58933..c9200e1e35 100644
--- a/packages/backend/src/models/Instance.ts
+++ b/packages/backend/src/models/Instance.ts
@@ -6,7 +6,8 @@
import { Entity, PrimaryColumn, Index, Column } from 'typeorm';
import { id } from './util/id.js';
-@Index('IDX_instance_host_key', { synchronize: false })
+@Index('IDX_instance_host_key', { synchronize: false }) // ((lower(reverse("host"::text)) || '.'::text)
+@Index('IDX_instance_host_filters', { synchronize: false }) // ("host", "isBlocked", "isSilenced", "isMediaSilenced", "isAllowListed", "isBubbled", "suspensionState")
@Entity('instance')
export class MiInstance {
@PrimaryColumn(id())