src/db/migrate.js

// Firestore is schemaless — no DDL to run.
// Composite indexes are defined in firestore.indexes.json (deploy with the Firebase CLI:
//   firebase deploy --only firestore:indexes
// ). For local dev the missing-index errors include a console URL you can click to
// auto-create the index.
//
// This script exists so `npm run db:migrate` still resolves; it just smoke-tests
// that the service account can reach Firestore.

const { db } = require('./firestore');

(async () => {
  try {
    await db.collection('__healthcheck').doc('ping').set({ at: new Date() });
    await db.collection('__healthcheck').doc('ping').delete();
    console.log('Firestore reachable. No schema migration needed.');
    process.exit(0);
  } catch (err) {
    console.error('Firestore connection failed:', err.message);
    process.exit(1);
  }
})();