'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    // Add draft_content TEXT column after content
    await queryInterface.addColumn('pages', 'draft_content', {
      type: Sequelize.TEXT,
      allowNull: true,
      // Position the column after `content` for MySQL
      // Note: `after` is a dialect-specific option supported by MySQL
      after: 'content'
    });
  },

  async down(queryInterface, Sequelize) {
    // Remove draft_content column
    await queryInterface.removeColumn('pages', 'draft_content');
  }
};