scripts/migrate.js

import 'dotenv/config';
import pg from 'pg';
const { Pool } = pg;

const db = new Pool({
  connectionString: process.env.DATABASE_URL,
  ssl: { rejectUnauthorized: false }
});

async function migrate() {
  try {
    console.log("Applying migrations...");
    await db.query(`ALTER TABLE users ADD COLUMN IF NOT EXISTS "deviceId" TEXT;`);
    await db.query(`ALTER TABLE users ADD COLUMN IF NOT EXISTS "deviceToken" TEXT;`);
    console.log("✓ Database Migration Successful");
  } catch (err) {
    console.error("Migration failed:", err);
  } finally {
    await db.end();
  }
}

migrate();