import Dexie from 'dexie';

export const db = new Dexie('ServiceBookDB');

db.version(1).stores({
  transactions: '++id, userId, date, type, category, amount',
  syncQueue: '++id, action, payload, timestamp',
  settings: 'key'
});

db.version(2).upgrade(trans => {
  return trans.table('transactions').toCollection().modify(transaction => {
    transaction.synced = false;
    transaction.updatedAt = new Date().toISOString();
  });
});

// Export the database instance
export default db;