add_user_theme.js

Go to the documentation of this file.

// Migration to add theme column to users table
const pool = require('../../backend/services/db');
 
(async function run(){
  try {
    console.log('Running backend migration: add theme column to users');
    const sql = "ALTER TABLE users ADD COLUMN IF NOT EXISTS theme VARCHAR(50);";
    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){}
  }
})();