From 7bca57f2dddd637fa9a11a49c2cf524502e34e0e Mon Sep 17 00:00:00 2001
From: Jonas Maier <>
Date: Sun, 8 Mar 2026 12:04:06 +0100
Subject: add auto-increment id column for correct querying

---
 src/history.rs | 1 +
 1 file changed, 1 insertion(+)

(limited to 'src/history.rs')

diff --git a/src/history.rs b/src/history.rs
index 2e06133..865d949 100644
--- a/src/history.rs
+++ b/src/history.rs
@@ -49,6 +49,7 @@ pub fn setup() {
     db.execute(
         "
     CREATE TABLE IF NOT EXISTS history (
+        id  INTEGER PRIMARY KEY AUTOINCREMENT,
         ts  INTEGER NOT NULL,
         loc BLOB NOT NULL,
         cmd BLOB NOT NULL
-- 
cgit v1.2.3