From 348c2ce3ff3fe2f25a31f08bfb36c88723a0ce46 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Mon, 21 Mar 2022 14:54:29 +0100 Subject: Remove old migration files --- .../migrations/0205-user-nsfw-policy.ts | 46 ---------------------- 1 file changed, 46 deletions(-) delete mode 100644 server/initializers/migrations/0205-user-nsfw-policy.ts (limited to 'server/initializers/migrations/0205-user-nsfw-policy.ts') diff --git a/server/initializers/migrations/0205-user-nsfw-policy.ts b/server/initializers/migrations/0205-user-nsfw-policy.ts deleted file mode 100644 index 9c2786f12..000000000 --- a/server/initializers/migrations/0205-user-nsfw-policy.ts +++ /dev/null @@ -1,46 +0,0 @@ -import * as Sequelize from 'sequelize' - -async function up (utils: { - transaction: Sequelize.Transaction - queryInterface: Sequelize.QueryInterface - sequelize: Sequelize.Sequelize -}): Promise { - - { - const data = { - type: Sequelize.ENUM('do_not_list', 'blur', 'display'), - allowNull: true, - defaultValue: null - } - await utils.queryInterface.addColumn('user', 'nsfwPolicy', data) - } - - { - const query = 'UPDATE "user" SET "nsfwPolicy" = \'do_not_list\'' - await utils.sequelize.query(query) - } - - { - const query = 'UPDATE "user" SET "nsfwPolicy" = \'display\' WHERE "displayNSFW" = true' - await utils.sequelize.query(query) - } - - { - const query = 'ALTER TABLE "user" ALTER COLUMN "nsfwPolicy" SET NOT NULL' - await utils.sequelize.query(query) - } - - { - await utils.queryInterface.removeColumn('user', 'displayNSFW') - } - -} - -function down (options) { - throw new Error('Not implemented.') -} - -export { - up, - down -} -- cgit v1.2.3