From 5ccd5ad56e0cd013deb5f73de26aa3d298deec77 Mon Sep 17 00:00:00 2001 From: syuilo Date: Sat, 15 Feb 2020 04:29:57 +0900 Subject: Add driveFiles index --- migration/1581708415836-drive-user-folder-id-index.ts | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 migration/1581708415836-drive-user-folder-id-index.ts (limited to 'migration') diff --git a/migration/1581708415836-drive-user-folder-id-index.ts b/migration/1581708415836-drive-user-folder-id-index.ts new file mode 100644 index 0000000000..e7a7628ff0 --- /dev/null +++ b/migration/1581708415836-drive-user-folder-id-index.ts @@ -0,0 +1,14 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class driveUserFolderIdIndex1581708415836 implements MigrationInterface { + name = 'driveUserFolderIdIndex1581708415836' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`CREATE INDEX "IDX_55720b33a61a7c806a8215b825" ON "drive_file" ("userId", "folderId", "id") `, undefined); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`DROP INDEX "IDX_55720b33a61a7c806a8215b825"`, undefined); + } + +} -- cgit v1.2.3-freya