add_customer_status.js

Go to the documentation of this file.

// Migration script placed inside backend so it can reuse backend's node_modules and dotenv
const pool = require('../services/db');
 
(async function run(){
  try {
    console.log('Running backend migration: add status column to customers');
    const sql = "ALTER TABLE customers ADD COLUMN IF NOT EXISTS status VARCHAR(50) DEFAULT 'active';";
    await pool.query(sql);
    console.log('Migration applied successfully');
  } catch (err) {
    console.error('Migration failed:', err);
    process.exitCode = 1;
  } finally {
    try { await pool.end(); } catch(e){}
  }
})();