crates/atuin-kv/migrations/20250501160746_create_kv_db.up.sql


1
2
3
4
5
6
7
8
9
10
11
12

-- Add up migration script here
CREATE TABLE
  kv (
    namespace TEXT NOT NULL,
    key TEXT NOT NULL,
    value TEXT NOT NULL,
    inserted_at INTEGER NOT NULL DEFAULT (strftime ('%s', 'now'))
  );

CREATE INDEX idx_kv_namespace ON kv (namespace);

CREATE UNIQUE INDEX idx_kv ON kv (namespace, key);