summary refs log tree commit diff
path: root/scripts/stagingMigration/postgres/1672815835837-staging.js
diff options
context:
space:
mode:
authorMadeline <46743919+MaddyUnderStars@users.noreply.github.com>2023-01-05 17:30:50 +1100
committerMadeline <46743919+MaddyUnderStars@users.noreply.github.com>2023-01-05 17:30:50 +1100
commite54912a7263cb5e4df3477944fe946c4b24c6d58 (patch)
treef460a3fd7562faa2b9ef5cef76dcf9f1ad349db3 /scripts/stagingMigration/postgres/1672815835837-staging.js
parentPrettier (diff)
downloadserver-e54912a7263cb5e4df3477944fe946c4b24c6d58.tar.xz
migration stuff again
Diffstat (limited to 'scripts/stagingMigration/postgres/1672815835837-staging.js')
-rw-r--r--scripts/stagingMigration/postgres/1672815835837-staging.js14
1 files changed, 13 insertions, 1 deletions
diff --git a/scripts/stagingMigration/postgres/1672815835837-staging.js b/scripts/stagingMigration/postgres/1672815835837-staging.js

index 60609dae..675f84ca 100644 --- a/scripts/stagingMigration/postgres/1672815835837-staging.js +++ b/scripts/stagingMigration/postgres/1672815835837-staging.js
@@ -130,11 +130,23 @@ module.exports = class staging1672815835837 { await queryRunner.query( `ALTER TABLE "members" ADD "premium_since" bigint`, ); + await queryRunner.query( + `ALTER TABLE members ADD theme_colors text` + ); + await queryRunner.query( + `ALTER TABLE members ADD pronouns varchar` + ); await queryRunner.query(`UPDATE users SET bio = '' WHERE bio IS NULL`); await queryRunner.query( `ALTER TABLE users ALTER COLUMN bio SET NOT NULL`, ); await queryRunner.query( + `ALTER TABLE users ADD theme_colors text` + ); + await queryRunner.query( + `ALTER TABLE users ADD pronouns varchar` + ); + await queryRunner.query( `UPDATE users SET mfa_enabled = false WHERE mfa_enabled IS NULL`, ); await queryRunner.query( @@ -145,5 +157,5 @@ module.exports = class staging1672815835837 { ); } - async down(queryRunner) {} + async down(queryRunner) { } };