From ef388c5e6848e7badb1d7e4ef44d571c9a2dbe94 Mon Sep 17 00:00:00 2001 From: John Turner Date: Sun, 14 Sep 2025 21:28:32 -0400 Subject: add unique constraint to keys index --- scripts/mkdb.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/scripts/mkdb.py b/scripts/mkdb.py index 5e555b5..27e0b64 100755 --- a/scripts/mkdb.py +++ b/scripts/mkdb.py @@ -66,8 +66,8 @@ def main() -> int: with sqlite3.connect(args.database) as connection: connection.execute("PRAGMA jorunal_mode = WAL") - connection.execute("create table kv(key text, value text)") - connection.execute("create index keys on kv(key)") + connection.execute("create table kv(key text PRIMARY KEY, value text)") + connection.execute("create unique index keys on kv(key)") for i in range(args.num_records): key = generate_key(randrange(args.key_length.start, args.key_length.end)) -- cgit v1.2.3