diff options
author | Ellie Huxtable <ellie@elliehuxtable.com> | 2024-04-18 16:41:28 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2024-04-18 16:41:28 +0100 |
commit | 95cc472037fcb3207b510e67f1a44af4e2a2cae9 (patch) | |
tree | fc1d3e71d8e0bdb806370e4144fd6f373bcc9c5e /crates/atuin-client/record-migrations/20231127090831_create-store.sql | |
parent | 176eae02f7f855ef40a4461caca61d530486113f (diff) |
chore: move crates into crates/ dir (#1958)
I'd like to tidy up the root a little, and it's nice to have all the
rust crates in one place
Diffstat (limited to 'crates/atuin-client/record-migrations/20231127090831_create-store.sql')
-rw-r--r-- | crates/atuin-client/record-migrations/20231127090831_create-store.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/crates/atuin-client/record-migrations/20231127090831_create-store.sql b/crates/atuin-client/record-migrations/20231127090831_create-store.sql new file mode 100644 index 00000000..53d78860 --- /dev/null +++ b/crates/atuin-client/record-migrations/20231127090831_create-store.sql @@ -0,0 +1,15 @@ +-- Add migration script here +create table if not exists store ( + id text primary key, -- globally unique ID + + idx integer, -- incrementing integer ID unique per (host, tag) + host text not null, -- references the host row + tag text not null, + + timestamp integer not null, + version text not null, + data blob not null, + cek blob not null +); + +create unique index record_uniq ON store(host, tag, idx); |