From 0e764a2b3e2aed345750b87f4a77bee345598c69 Mon Sep 17 00:00:00 2001 From: Satsuki Yanagi <17376330+u1-liquid@users.noreply.github.com> Date: Fri, 3 May 2019 18:38:19 +0900 Subject: Fix external service authentication (#4846) --- migration/1556746559567-UserProfile.ts | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 migration/1556746559567-UserProfile.ts (limited to 'migration') diff --git a/migration/1556746559567-UserProfile.ts b/migration/1556746559567-UserProfile.ts new file mode 100644 index 0000000000..719f8e1ae0 --- /dev/null +++ b/migration/1556746559567-UserProfile.ts @@ -0,0 +1,23 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class UserProfile1556746559567 implements MigrationInterface { + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`UPDATE "user_profile" SET github = FALSE`); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "githubId"`); + await queryRunner.query(`ALTER TABLE "user_profile" ADD COLUMN "githubId" VARCHAR(64)`); + await queryRunner.query(`UPDATE "user_profile" SET discord = FALSE`); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordExpiresDate"`); + await queryRunner.query(`ALTER TABLE "user_profile" ADD COLUMN "discordExpiresDate" VARCHAR(64)`); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`UPDATE "user_profile" SET github = FALSE`); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "githubId"`); + await queryRunner.query(`ALTER TABLE "user_profile" ADD COLUMN "githubId" INTEGER`); + await queryRunner.query(`UPDATE "user_profile" SET discord = FALSE`); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordExpiresDate"`); + await queryRunner.query(`ALTER TABLE "user_profile" ADD COLUMN "discordExpiresDate" INTEGER`); + } + +} -- cgit v1.2.3-freya