Remove old migration files

1 files changed, 0 insertions, 88 deletions

diff --git a/server/initializers/migrations/0345-video-playlists.ts b/server/initializers/migrations/0345-video-playlists.ts
deleted file mode 100644
index 4bf3100e4..000000000
--- a/server/initializers/migrations/0345-video-playlists.ts
+++ /dev/null
@@ -1,88 +0,0 @@
-import * as Sequelize from 'sequelize'
-import { buildUUID } from '@shared/extra-utils'
-import { VideoPlaylistPrivacy, VideoPlaylistType } from '../../../shared/models/videos'
-import { WEBSERVER } from '../constants'
-
-async function up (utils: {
-  transaction: Sequelize.Transaction
-  queryInterface: Sequelize.QueryInterface
-  sequelize: Sequelize.Sequelize
-}): Promise<void> {
-  const transaction = utils.transaction
-
-  {
-    const query = `
-CREATE TABLE IF NOT EXISTS "videoPlaylist"
-(
-  "id"             SERIAL,
-  "name"           VARCHAR(255)             NOT NULL,
-  "description"    VARCHAR(255),
-  "privacy"        INTEGER                  NOT NULL,
-  "url"            VARCHAR(2000)            NOT NULL,
-  "uuid"           UUID                     NOT NULL,
-  "type"           INTEGER                  NOT NULL DEFAULT 1,
-  "ownerAccountId" INTEGER                  NOT NULL REFERENCES "account" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-  "videoChannelId" INTEGER REFERENCES "videoChannel" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-  "createdAt"      TIMESTAMP WITH TIME ZONE NOT NULL,
-  "updatedAt"      TIMESTAMP WITH TIME ZONE NOT NULL,
-  PRIMARY KEY ("id")
-);`
-    await utils.sequelize.query(query, { transaction })
-  }
-
-  {
-    const query = `
-CREATE TABLE IF NOT EXISTS "videoPlaylistElement"
-(
-  "id"              SERIAL,
-  "url"             VARCHAR(2000)            NOT NULL,
-  "position"        INTEGER                  NOT NULL DEFAULT 1,
-  "startTimestamp"  INTEGER,
-  "stopTimestamp"   INTEGER,
-  "videoPlaylistId" INTEGER                  NOT NULL REFERENCES "videoPlaylist" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-  "videoId"         INTEGER                  NOT NULL REFERENCES "video" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-  "createdAt"       TIMESTAMP WITH TIME ZONE NOT NULL,
-  "updatedAt"       TIMESTAMP WITH TIME ZONE NOT NULL,
-  PRIMARY KEY ("id")
-);`
-
-    await utils.sequelize.query(query, { transaction })
-  }
-
-  {
-    const userQuery = 'SELECT "username" FROM "user";'
-
-    const options = { transaction, type: Sequelize.QueryTypes.SELECT as Sequelize.QueryTypes.SELECT }
-    const userResult = await utils.sequelize.query<{ username: string }>(userQuery, options)
-    const usernames = userResult.map(r => r.username)
-
-    for (const username of usernames) {
-      const uuid = buildUUID()
-
-      const baseUrl = WEBSERVER.URL + '/video-playlists/' + uuid
-      const query = `
- INSERT INTO "videoPlaylist" ("url", "uuid", "name", "privacy", "type", "ownerAccountId", "createdAt", "updatedAt")
- SELECT '${baseUrl}' AS "url",
-         '${uuid}' AS "uuid",
-         'Watch later' AS "name",
-         ${VideoPlaylistPrivacy.PRIVATE} AS "privacy",
-         ${VideoPlaylistType.WATCH_LATER} AS "type",
-         "account"."id" AS "ownerAccountId",
-         NOW() as "createdAt",
-         NOW() as "updatedAt"
- FROM "user" INNER JOIN "account" ON "user"."id" = "account"."userId"
- WHERE "user"."username" = '${username}'`
-
-      await utils.sequelize.query(query, { transaction })
-    }
-  }
-}
-
-function down (options) {
-  throw new Error('Not implemented.')
-}
-
-export {
-  up,
-  down
-}