tourrism_site/database/apply-image-fix.js

import db from '../src/config/database.js';
import fs from 'fs';
import path from 'path';
import { fileURLToPath } from 'url';
import { dirname } from 'path';

const __filename = fileURLToPath(import.meta.url);
const __dirname = dirname(__filename);

async function applyImageTriggersFix() {
  try {
    console.log('🖼️ Applying image triggers fix migration...');
    
    const migrationPath = path.join(__dirname, 'image-triggers-fix.sql');
    const sql = fs.readFileSync(migrationPath, 'utf8');
    
    await db.query(sql);
    console.log('✅ Image triggers fix applied successfully');
    
  } catch (error) {
    console.log('ℹ️ Some changes may already be applied:', error.message);
  }
  
  process.exit(0);
}

applyImageTriggersFix();