aboutsummaryrefslogtreecommitdiffstats
path: root/src
diff options
context:
space:
mode:
authorJonas Maier <>2026-03-08 12:04:06 +0100
committerJonas Maier <>2026-03-08 12:04:06 +0100
commit7bca57f2dddd637fa9a11a49c2cf524502e34e0e (patch)
tree2dcc5b25502288a596a781fed1ccc90a86cb356b /src
parent36b934d543f8cfedb0a74c52de0620be7d5fb106 (diff)
downloadpish-7bca57f2dddd637fa9a11a49c2cf524502e34e0e.tar.gz
add auto-increment id column for correct querying
Diffstat (limited to 'src')
-rw-r--r--src/history.rs1
1 files changed, 1 insertions, 0 deletions
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