diff options
author | TheArcaneBrony <myrainbowdash949@gmail.com> | 2022-08-15 09:47:49 +0200 |
---|---|---|
committer | TheArcaneBrony <myrainbowdash949@gmail.com> | 2022-08-15 09:47:49 +0200 |
commit | 6d9ea1a7bc9d44a547fe1566393e122ae252eb8c (patch) | |
tree | 801bb36025a4610bf1861f038c008bbb8f9ace53 /src/util/migrations/mariadb | |
parent | oops.. move migrations to right folder (diff) | |
download | server-6d9ea1a7bc9d44a547fe1566393e122ae252eb8c.tar.xz |
Fix nullables, fix user settings hanging stuff
Diffstat (limited to 'src/util/migrations/mariadb')
-rw-r--r-- | src/util/migrations/mariadb/1660549252130-fix_nullables.ts | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/src/util/migrations/mariadb/1660549252130-fix_nullables.ts b/src/util/migrations/mariadb/1660549252130-fix_nullables.ts new file mode 100644 index 00000000..c9456b54 --- /dev/null +++ b/src/util/migrations/mariadb/1660549252130-fix_nullables.ts @@ -0,0 +1,30 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class fixNullables1660549252130 implements MigrationInterface { + name = 'fixNullables1660549252130' + + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` + DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\` + `); + await queryRunner.query(` + ALTER TABLE \`users\` CHANGE \`bio\` \`bio\` varchar(255) NULL + `); + await queryRunner.query(` + ALTER TABLE \`users\` CHANGE \`mfa_enabled\` \`mfa_enabled\` tinyint NULL + `); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` + ALTER TABLE \`users\` CHANGE \`mfa_enabled\` \`mfa_enabled\` tinyint NOT NULL + `); + await queryRunner.query(` + ALTER TABLE \`users\` CHANGE \`bio\` \`bio\` varchar(255) NOT NULL + `); + await queryRunner.query(` + CREATE UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`) + `); + } + +} |