diff options
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/mkdb.py | 4 |
1 files 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)) |