From 5301e7762b340367323cbb76d68953c35b909634 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Tue, 22 Feb 2022 14:49:23 +0100 Subject: Fix video file storage column consistency --- .../migrations/0680-files-storage-default.ts | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 server/initializers/migrations/0680-files-storage-default.ts (limited to 'server/initializers/migrations') diff --git a/server/initializers/migrations/0680-files-storage-default.ts b/server/initializers/migrations/0680-files-storage-default.ts new file mode 100644 index 000000000..087bc8790 --- /dev/null +++ b/server/initializers/migrations/0680-files-storage-default.ts @@ -0,0 +1,20 @@ +import * as Sequelize from 'sequelize' + +async function up (utils: { + transaction: Sequelize.Transaction + queryInterface: Sequelize.QueryInterface + sequelize: Sequelize.Sequelize + db: any +}): Promise { + await utils.sequelize.query('ALTER TABLE "videoFile" ALTER COLUMN "storage" SET DEFAULT 0') + await utils.sequelize.query('ALTER TABLE "videoStreamingPlaylist" ALTER COLUMN "storage" SET DEFAULT 0') +} + +function down (options) { + throw new Error('Not implemented.') +} + +export { + up, + down +} -- cgit v1.2.3