diff options
author | TheArcaneBrony <myrainbowdash949@gmail.com> | 2022-08-15 11:13:21 +0200 |
---|---|---|
committer | TheArcaneBrony <myrainbowdash949@gmail.com> | 2022-08-15 11:13:21 +0200 |
commit | 1a94fb1208bf0e4c669cad16aff5f57dc0bf7a3c (patch) | |
tree | 1035116ddbaacc5fcc5ae250a6592eb88f78f75c /src/util/migrations/postgres/1660549242936-fix_nullables.ts | |
parent | Do the funny thing (make user->invite cascade delet) (diff) | |
parent | change dev panel path, we missed this one... (diff) | |
download | server-1a94fb1208bf0e4c669cad16aff5f57dc0bf7a3c.tar.xz |
Merge branch 'dev/restructure' into staging
Diffstat (limited to 'src/util/migrations/postgres/1660549242936-fix_nullables.ts')
-rw-r--r-- | src/util/migrations/postgres/1660549242936-fix_nullables.ts | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/src/util/migrations/postgres/1660549242936-fix_nullables.ts b/src/util/migrations/postgres/1660549242936-fix_nullables.ts new file mode 100644 index 00000000..b9a0194d --- /dev/null +++ b/src/util/migrations/postgres/1660549242936-fix_nullables.ts @@ -0,0 +1,30 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class fixNullables1660549242936 implements MigrationInterface { + name = 'fixNullables1660549242936' + + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` + ALTER TABLE "users" + ALTER COLUMN "bio" DROP NOT NULL + `); + await queryRunner.query(` + ALTER TABLE "users" + ALTER COLUMN "mfa_enabled" DROP NOT NULL + `); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` + ALTER TABLE "users" + ALTER COLUMN "mfa_enabled" + SET NOT NULL + `); + await queryRunner.query(` + ALTER TABLE "users" + ALTER COLUMN "bio" + SET NOT NULL + `); + } + +} |