Function initDatabase

packages/core/src/db/db-core.ts:326–740

()

/** Initialize the database, creating tables if needed */
export async function initDatabase(): Promise<void> {
  if (dbInitialized) return;
  if (dbInitPromise) return dbInitPromise;

  dbInitPromise = (async () => {
    await runSerializedDbTask(async () => {
      if (dbInitialized) return;

      const database = await getDB();

      // Create tables
      await database.execute(`
    CREATE TABLE IF NOT EXISTS books (
      id TEXT PRIMARY KEY,
      file_path TEXT NOT NULL,
      format TEXT NOT NULL DEFAULT 'epub',
      title TEXT NOT NULL DEFAULT '',
      author TEXT NOT NULL DEFAULT '',
      publisher TEXT,
      language TEXT,
      isbn TEXT,
      description TEXT,
      cover_url TEXT,
      publish_date TEXT,
      rating REAL,
      reviews TEXT,
      subjects TEXT,
      total_pages INTEGER DEFAULT 0,
      total_chapters INTEGER DEFAULT 0,
      group_id TEXT,
      added_at INTEGER NOT NULL,
      last_opened_at INTEGER,
      deleted_at INTEGER,
      progress REAL DEFAULT 0,
      current_cfi TEXT,
      is_vectorized INTEGER DEFAULT 0,
      vectorize_progress REAL DEFAULT 0,
      tags TEXT DEFAULT '[]'
    )
  `);

      await database.execute(`
    CREATE TABLE IF NOT EXISTS book_groups (
      id TEXT PRIMARY KEY,
      name TEXT NOT NULL,
      sort_order INTEGER DEFAULT 0,
      created_at INTEGER NOT NULL,
      updated_at INTEGER NOT NULL DEFAULT 0,
      sync_version INTEGER DEFAULT 0,
      last_modified_by TEXT
    )
  `);

      await database.execute(`
    CREATE TABLE IF NOT EXISTS highlights (
      id TEXT PRIMARY KEY,
      book_id TEXT NOT NULL,
      cfi TEXT NOT NULL,