feiniao-site-node/migrations/20250227064224-add-article-to-table.js

'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up (queryInterface, Sequelize) {
     await queryInterface.addColumn('Articles', 'type', {
      type: Sequelize.INTEGER,
      allowNull: true, // 根据需要设置是否允许为空
    });

    await queryInterface.addColumn('Articles', 'img', {
      type: Sequelize.TEXT,
      allowNull: true, // 根据需要设置是否允许为空
    });

    await queryInterface.addColumn('Articles', 'date', {
      type: Sequelize.DATE,
      allowNull: true, // 根据需要设置是否允许为空
    });
  },

  async down (queryInterface, Sequelize) {
    await queryInterface.removeColumn('Articles', 'type');
    await queryInterface.removeColumn('Articles', 'img');
    await queryInterface.removeColumn('Articles', 'date');
  }
};