src/lib/db/index.ts

import Dexie, { type Table } from 'dexie';
import type { PicletInstance, Encounter, GameState } from './schema';

export class PicletDatabase extends Dexie {
  // Game tables
  picletInstances!: Table<PicletInstance>;
  encounters!: Table<Encounter>;
  gameState!: Table<GameState>;

  constructor() {
    super('PicletGameDB');
    
    // Version 1: Legacy monsters table (removed in v5)
    
    // Version 2: Legacy monsters table with imageData (removed in v5)
    
    // Version 3: Legacy monsters table with stats (removed in v5)
    
    // Version 4: Add new game tables with legacy monsters
    this.version(4).stores({
      monsters: '++id, name, createdAt',
      picletInstances: '++id, typeId, nickname, isInRoster, rosterPosition, caughtAt',
      encounters: '++id, type, createdAt',
      gameState: '++id, lastPlayed'
    });
    
    // Version 5: Remove legacy monsters table
    this.version(5).stores({
      picletInstances: '++id, typeId, nickname, isInRoster, rosterPosition, caughtAt',
      encounters: '++id, type, createdAt',
      gameState: '++id, lastPlayed'
    });
  }
}

export const db = new PicletDatabase();