PRAGMA foreign_keys = ON;
      CREATE TABLE IF NOT EXISTS todo (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          titel TEXT NOT NULL,
          beschreibung TEXT,
          kategorie TEXT NOT NULL DEFAULT 'Allgemein',
          prioritaet TEXT NOT NULL DEFAULT 'Mittel',
          status TEXT NOT NULL DEFAULT 'Offen',
          faellig_am TEXT,
          wiederholen TEXT NOT NULL DEFAULT 'Nein',
          notiz TEXT,
          created_at TEXT NOT NULL DEFAULT (datetime('now')),
          updated_at TEXT NOT NULL DEFAULT (datetime('now'))
      );
      CREATE TABLE IF NOT EXISTS calendar_event (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          titel TEXT NOT NULL,
          datum TEXT NOT NULL,
          uhrzeit TEXT NOT NULL,
          dauer_min INTEGER NOT NULL DEFAULT 60,
          kalender TEXT NOT NULL DEFAULT 'Privat',
          kategorie TEXT NOT NULL DEFAULT 'Sonstiges',
          erinnerung_min INTEGER NOT NULL DEFAULT 30,
          wiederholen TEXT NOT NULL DEFAULT 'Nein',
          notiz TEXT,
          created_at TEXT NOT NULL DEFAULT (datetime('now')),
          updated_at TEXT NOT NULL DEFAULT (datetime('now'))
      );
      CREATE TABLE IF NOT EXISTS settings (
          key TEXT PRIMARY KEY,
          value TEXT NOT NULL
      );
      CREATE INDEX IF NOT EXISTS idx_todo_faellig_am ON todo(faellig_am);
      CREATE INDEX IF NOT EXISTS idx_todo_status ON todo(status);
      CREATE INDEX IF NOT EXISTS idx_calendar_event_datum ON calendar_event(datum);
      CREATE INDEX IF NOT EXISTS idx_calendar_event_kalender ON calendar_event(kalender);