From e54912a7263cb5e4df3477944fe946c4b24c6d58 Mon Sep 17 00:00:00 2001 From: Madeline <46743919+MaddyUnderStars@users.noreply.github.com> Date: Thu, 5 Jan 2023 17:30:50 +1100 Subject: migration stuff again --- scripts/stagingMigration/postgres/1672815835837-staging.js | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'scripts') 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,10 +130,22 @@ 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`, ); @@ -145,5 +157,5 @@ module.exports = class staging1672815835837 { ); } - async down(queryRunner) {} + async down(queryRunner) { } }; -- cgit 1.4.1