diff options
| author | Satsuki Yanagi <17376330+u1-liquid@users.noreply.github.com> | 2019-05-03 18:38:19 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2019-05-03 18:38:19 +0900 |
| commit | 0e764a2b3e2aed345750b87f4a77bee345598c69 (patch) | |
| tree | 80eed4ef3749bb15c8d5a143e220f49d39afb8dc /migration | |
| parent | Some import and export fixes (#4842) (diff) | |
| download | sharkey-0e764a2b3e2aed345750b87f4a77bee345598c69.tar.gz sharkey-0e764a2b3e2aed345750b87f4a77bee345598c69.tar.bz2 sharkey-0e764a2b3e2aed345750b87f4a77bee345598c69.zip | |
Fix external service authentication (#4846)
Diffstat (limited to 'migration')
| -rw-r--r-- | migration/1556746559567-UserProfile.ts | 23 |
1 files changed, 23 insertions, 0 deletions
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<any> { + 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<any> { + 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`); + } + +} |