-- Safe indexes for journal-entry list pagination and status filtering.
-- Run once on existing production databases after deploying the code change.
CREATE INDEX idx_journal_entries_list_order
  ON journal_entries (entryDate, createdAt, id);

CREATE INDEX idx_journal_entries_status_order
  ON journal_entries (status, entryDate, createdAt, id);