aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations/0470-cleaup-indexes.ts
blob: 7365c30f8a985ae2cf4c13c1f90a1c73aefac8d9 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import * as Sequelize from 'sequelize'

async function up (utils: {
  transaction: Sequelize.Transaction
  queryInterface: Sequelize.QueryInterface
  sequelize: Sequelize.Sequelize
  db: any
}): Promise<void> {
  await utils.sequelize.query('DROP INDEX IF EXISTS video_share_account_id;')
  await utils.sequelize.query('DROP INDEX IF EXISTS video_published_at;')

  await utils.sequelize.query('ALTER TABLE "avatar" DROP COLUMN IF EXISTS "avatarId"')
}

function down (options) {
  throw new Error('Not implemented.')
}

export {
  up,
  down
}