diff options
| author | anatawa12 <anatawa12@icloud.com> | 2025-08-25 10:04:35 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-08-25 10:04:35 +0900 |
| commit | 41b5677f01db37d60a53dc9671465f6f53d511c0 (patch) | |
| tree | 4cb479075b836636d89cc481427a1b43168107d2 | |
| parent | Bump version to 2025.8.0-beta.4 (diff) | |
| download | misskey-41b5677f01db37d60a53dc9671465f6f53d511c0.tar.gz misskey-41b5677f01db37d60a53dc9671465f6f53d511c0.tar.bz2 misskey-41b5677f01db37d60a53dc9671465f6f53d511c0.zip | |
fix: Pages will be deleted when eye-catching image is moved (#16455)
| -rw-r--r-- | packages/backend/migration/1756062689648-NonCascadingPageEyeCatching.js | 18 | ||||
| -rw-r--r-- | packages/backend/src/models/Page.ts | 2 |
2 files changed, 19 insertions, 1 deletions
diff --git a/packages/backend/migration/1756062689648-NonCascadingPageEyeCatching.js b/packages/backend/migration/1756062689648-NonCascadingPageEyeCatching.js new file mode 100644 index 0000000000..8554cc4304 --- /dev/null +++ b/packages/backend/migration/1756062689648-NonCascadingPageEyeCatching.js @@ -0,0 +1,18 @@ +/* + * SPDX-FileCopyrightText: syuilo and misskey-project + * SPDX-License-Identifier: AGPL-3.0-only + */ + +export class NonCascadingPageEyeCatching1756062689648 { + name = 'NonCascadingPageEyeCatching1756062689648' + + async up(queryRunner) { + await queryRunner.query(`ALTER TABLE "page" DROP CONSTRAINT "FK_a9ca79ad939bf06066b81c9d3aa"`); + await queryRunner.query(`ALTER TABLE "page" ADD CONSTRAINT "FK_a9ca79ad939bf06066b81c9d3aa" FOREIGN KEY ("eyeCatchingImageId") REFERENCES "drive_file"("id") ON DELETE SET NULL ON UPDATE NO ACTION`); + } + + async down(queryRunner) { + await queryRunner.query(`ALTER TABLE "page" DROP CONSTRAINT "FK_a9ca79ad939bf06066b81c9d3aa"`); + await queryRunner.query(`ALTER TABLE "page" ADD CONSTRAINT "FK_a9ca79ad939bf06066b81c9d3aa" FOREIGN KEY ("eyeCatchingImageId") REFERENCES "drive_file"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); + } +} diff --git a/packages/backend/src/models/Page.ts b/packages/backend/src/models/Page.ts index 0b59e7a92c..d112a66c04 100644 --- a/packages/backend/src/models/Page.ts +++ b/packages/backend/src/models/Page.ts @@ -69,7 +69,7 @@ export class MiPage { public eyeCatchingImageId: MiDriveFile['id'] | null; @ManyToOne(type => MiDriveFile, { - onDelete: 'CASCADE', + onDelete: 'SET NULL', }) @JoinColumn() public eyeCatchingImage: MiDriveFile | null; |