sequelize.js - 为什么我不能在 sequelize-cli 中添加新列？

Question

向名为 'vdo' 的表添加新列 'avatar'

我只是创建一个迁移文件并运行它:

module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.addColumn('vdo', 'avatar', {
      type: Sequelize.STRING,
    });
  },

  down: (queryInterface, Sequelize) => {
  },
};

但是出现了这样的错误:

Sequelize CLI [Node: 12.16.1, CLI: 5.5.1, ORM: 5.21.11]

Loaded configuration file "database\config.json".
Using environment "development".
(node:9656) [SEQUELIZE0004] DeprecationWarning: A boolean value was passed to options.operatorsAliases. This is a no-op with v5 and should be removed.
== 20200603081223-add-column: migrating =======

ERROR: Table 'vdo.vdo' doesn't exist

Answer 1

只要表名像这样，您就应该指示模式:

addColumn({ schema: '<your_schema_name_here>', tableName: 'vdo' }, 'avatar', ...