From 348c2ce3ff3fe2f25a31f08bfb36c88723a0ce46 Mon Sep 17 00:00:00 2001
From: Chocobozzz <me@florianbigard.com>
Date: Mon, 21 Mar 2022 14:54:29 +0100
Subject: Remove old migration files

---
 .../migrations/0275-video-file-unique.ts           | 40 ----------------------
 1 file changed, 40 deletions(-)
 delete mode 100644 server/initializers/migrations/0275-video-file-unique.ts

(limited to 'server/initializers/migrations/0275-video-file-unique.ts')

diff --git a/server/initializers/migrations/0275-video-file-unique.ts b/server/initializers/migrations/0275-video-file-unique.ts
deleted file mode 100644
index e321ecb04..000000000
--- a/server/initializers/migrations/0275-video-file-unique.ts
+++ /dev/null
@@ -1,40 +0,0 @@
-import * as Sequelize from 'sequelize'
-
-async function up (utils: {
-  transaction: Sequelize.Transaction
-  queryInterface: Sequelize.QueryInterface
-  sequelize: Sequelize.Sequelize
-}): Promise<any> {
-  // Delete duplicated keys
-  {
-    const query = 'DELETE FROM "server" s1 USING "server" s2 WHERE s1.id < s2.id AND s1."host" = s2."host"'
-    await utils.sequelize.query(query)
-  }
-
-  {
-    const query = 'DELETE FROM "videoFile" vf1 USING "videoFile" vf2 WHERE vf1.id < vf2.id ' +
-      'AND vf1."videoId" = vf2."videoId" AND vf1.resolution = vf2.resolution AND vf1.fps IS NULL'
-    await utils.sequelize.query(query)
-  }
-
-  {
-    const query = 'UPDATE "videoFile" SET fps = -1 WHERE fps IS NULL;'
-    await utils.sequelize.query(query)
-  }
-
-  {
-    const data = {
-      type: Sequelize.INTEGER,
-      allowNull: false,
-      defaultValue: -1
-    }
-    await utils.queryInterface.changeColumn('videoFile', 'fps', data)
-  }
-
-}
-
-function down (options) {
-  throw new Error('Not implemented.')
-}
-
-export { up, down }
-- 
cgit v1.2.3