server/initializers/migrations/0310-drop-unused-video-indexes.ts

   1 import * as Sequelize from 'sequelize'
   2
   3 async function up (utils: {
   4   transaction: Sequelize.Transaction
   5   queryInterface: Sequelize.QueryInterface
   6   sequelize: Sequelize.Sequelize
   7   db: any
   8 }): Promise<void> {
   9   const indexNames = [
  10     'video_category',
  11     'video_licence',
  12     'video_nsfw',
  13     'video_language',
  14     'video_wait_transcoding',
  15     'video_state',
  16     'video_remote',
  17     'video_likes'
  18   ]
  19
  20   for (const indexName of indexNames) {
  21     await utils.sequelize.query('DROP INDEX IF EXISTS "' + indexName + '";')
  22   }
  23 }
  24
  25 function down (options) {
  26   throw new Error('Not implemented.')
  27 }
  28
  29 export {
  30   up,
  31   down
  32 }