diff options
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`); + } + +} |