ideas-generator/server/migrations/migrate.js

require('dotenv').config();
const { sequelize } = require('../config/database');
const { testConnection } = require('../config/database');
require('../models');

const migrate = async () => {
  try {
    console.log('🔄 Starting database migration...');
    
    await testConnection();
    
    await sequelize.sync({ force: false, alter: true });
    
    console.log('✅ Database migration completed successfully!');
    console.log('📊 All models synchronized with database');
    
    process.exit(0);
  } catch (error) {
    console.error('❌ Migration failed:', error);
    process.exit(1);
  }
};

if (require.main === module) {
  migrate();
}

module.exports = migrate;