diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2023-03-20 20:12:38 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2023-03-20 20:12:38 +0900 |
| commit | 54630edb0f8cf91480e19f4e8e56c05158bc3a8f (patch) | |
| tree | e891f085a09ff3dcc1e54103222920f7544f6b0b /packages/backend/migration | |
| parent | fix(users/show): ユーザーが見つからなかった場合に404ステー... (diff) | |
| download | misskey-54630edb0f8cf91480e19f4e8e56c05158bc3a8f.tar.gz misskey-54630edb0f8cf91480e19f4e8e56c05158bc3a8f.tar.bz2 misskey-54630edb0f8cf91480e19f4e8e56c05158bc3a8f.zip | |
enhance: 使われてないアンテナは自動停止されるように
Resolve #9373
Diffstat (limited to 'packages/backend/migration')
| -rw-r--r-- | packages/backend/migration/1679309757174-antenna-active.js | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/packages/backend/migration/1679309757174-antenna-active.js b/packages/backend/migration/1679309757174-antenna-active.js new file mode 100644 index 0000000000..69e845c142 --- /dev/null +++ b/packages/backend/migration/1679309757174-antenna-active.js @@ -0,0 +1,17 @@ +export class antennaActive1679309757174 { + name = 'antennaActive1679309757174' + + async up(queryRunner) { + await queryRunner.query(`ALTER TABLE "antenna" ADD "lastUsedAt" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT 'now'`); + await queryRunner.query(`ALTER TABLE "antenna" ADD "isActive" boolean NOT NULL DEFAULT true`); + await queryRunner.query(`CREATE INDEX "IDX_084c2abb8948ef59a37dce6ac1" ON "antenna" ("lastUsedAt") `); + await queryRunner.query(`CREATE INDEX "IDX_36ef5192a1ce55ed0e40aa4db5" ON "antenna" ("isActive") `); + } + + async down(queryRunner) { + await queryRunner.query(`DROP INDEX "public"."IDX_36ef5192a1ce55ed0e40aa4db5"`); + await queryRunner.query(`DROP INDEX "public"."IDX_084c2abb8948ef59a37dce6ac1"`); + await queryRunner.query(`ALTER TABLE "antenna" DROP COLUMN "isActive"`); + await queryRunner.query(`ALTER TABLE "antenna" DROP COLUMN "lastUsedAt"`); + } +} |