diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2022-02-11 12:47:42 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2022-02-11 12:47:42 +0900 |
| commit | 91b2a169b4ddbf9a97be5eb635457cf88761bdd9 (patch) | |
| tree | 90a7ffdfb29365589922b87317177d489a264e41 /packages/backend | |
| parent | :art: (diff) | |
| download | misskey-91b2a169b4ddbf9a97be5eb635457cf88761bdd9.tar.gz misskey-91b2a169b4ddbf9a97be5eb635457cf88761bdd9.tar.bz2 misskey-91b2a169b4ddbf9a97be5eb635457cf88761bdd9.zip | |
enhance(server): add indexes for following host
Diffstat (limited to '')
| -rw-r--r-- | packages/backend/migration/1644551208096-following-indexes.js | 15 | ||||
| -rw-r--r-- | packages/backend/src/models/entities/following.ts | 2 |
2 files changed, 17 insertions, 0 deletions
diff --git a/packages/backend/migration/1644551208096-following-indexes.js b/packages/backend/migration/1644551208096-following-indexes.js new file mode 100644 index 0000000000..6c149d8069 --- /dev/null +++ b/packages/backend/migration/1644551208096-following-indexes.js @@ -0,0 +1,15 @@ +const { MigrationInterface, QueryRunner } = require("typeorm"); + +module.exports = class followingIndexes1644551208096 { + name = 'followingIndexes1644551208096' + + async up(queryRunner) { + await queryRunner.query(`CREATE INDEX "IDX_4ccd2239268ebbd1b35e318754" ON "following" ("followerHost") `); + await queryRunner.query(`CREATE INDEX "IDX_fcdafee716dfe9c3b5fde90f30" ON "following" ("followeeHost") `); + } + + async down(queryRunner) { + await queryRunner.query(`DROP INDEX "public"."IDX_fcdafee716dfe9c3b5fde90f30"`); + await queryRunner.query(`DROP INDEX "public"."IDX_4ccd2239268ebbd1b35e318754"`); + } +} diff --git a/packages/backend/src/models/entities/following.ts b/packages/backend/src/models/entities/following.ts index c3631e8501..ad387e5188 100644 --- a/packages/backend/src/models/entities/following.ts +++ b/packages/backend/src/models/entities/following.ts @@ -41,6 +41,7 @@ export class Following { public follower: User | null; //#region Denormalized fields + @Index() @Column('varchar', { length: 128, nullable: true, comment: '[Denormalized]', @@ -59,6 +60,7 @@ export class Following { }) public followerSharedInbox: string | null; + @Index() @Column('varchar', { length: 128, nullable: true, comment: '[Denormalized]', |