diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2020-02-01 07:16:52 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2020-02-01 07:16:52 +0900 |
| commit | 7ed3448e13847f3ba807be1354e90c912fbefd9a (patch) | |
| tree | a9d91176e5a95f90e2af570ae900641f651e77aa /migration | |
| parent | Update gulpfile.ts (diff) | |
| download | misskey-7ed3448e13847f3ba807be1354e90c912fbefd9a.tar.gz misskey-7ed3448e13847f3ba807be1354e90c912fbefd9a.tar.bz2 misskey-7ed3448e13847f3ba807be1354e90c912fbefd9a.zip | |
Resolve #1669
Diffstat (limited to 'migration')
| -rw-r--r-- | migration/1580508795118-v12-12.ts | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/migration/1580508795118-v12-12.ts b/migration/1580508795118-v12-12.ts new file mode 100644 index 0000000000..99791b051b --- /dev/null +++ b/migration/1580508795118-v12-12.ts @@ -0,0 +1,46 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class v12121580508795118 implements MigrationInterface { + name = 'v12121580508795118' + + public async up(queryRunner: QueryRunner): Promise<any> { + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "twitter"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "twitterAccessToken"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "twitterAccessTokenSecret"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "twitterUserId"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "twitterScreenName"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "github"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "githubAccessToken"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "githubId"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "githubLogin"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discord"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordAccessToken"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordRefreshToken"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordExpiresDate"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordId"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordUsername"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "discordDiscriminator"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "integrations" jsonb NOT NULL DEFAULT '{}'`, undefined); + } + + public async down(queryRunner: QueryRunner): Promise<any> { + await queryRunner.query(`ALTER TABLE "user_profile" DROP COLUMN "integrations"`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordDiscriminator" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordUsername" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordId" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordExpiresDate" character varying(64)`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordRefreshToken" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discordAccessToken" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "discord" boolean NOT NULL DEFAULT false`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "githubLogin" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "githubId" character varying(64)`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "githubAccessToken" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "github" boolean NOT NULL DEFAULT false`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "twitterScreenName" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "twitterUserId" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "twitterAccessTokenSecret" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "twitterAccessToken" character varying(64) DEFAULT NULL`, undefined); + await queryRunner.query(`ALTER TABLE "user_profile" ADD "twitter" boolean NOT NULL DEFAULT false`, undefined); + } + +} |