// Script to drop categories table
const { sequelize } = require('../models');

async function dropCategoriesTable() {
  try {
    console.log('Connecting to database...');
    await sequelize.authenticate();
    console.log('✅ Database connected');

    console.log('\nDropping categories table...');
    await sequelize.query('DROP TABLE IF EXISTS categories');
    console.log('✅ Categories table dropped successfully');

    await sequelize.close();
    console.log('\n✅ Database connection closed');
    process.exit(0);
  } catch (error) {
    console.error('❌ Error:', error.message);
    await sequelize.close();
    process.exit(1);
  }
}

dropCategoriesTable();