aboutsummaryrefslogtreecommitdiffstats
path: root/crates/turtle/db/client-record-migrations
diff options
context:
space:
mode:
authorBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-07-09 21:43:23 +0200
committerBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-07-09 21:43:23 +0200
commit3223d93cb3c77ab02aa0a35f2a8314e447cee9a4 (patch)
tree3971a1f37f5fe3cadb747c5229a0d54e868e45e3 /crates/turtle/db/client-record-migrations
parentfix(client/sync): Pass through precise error on `SyncError::WrongKey` (diff)
downloadatuin-3223d93cb3c77ab02aa0a35f2a8314e447cee9a4.zip
chore: Separate daemon, client, server, and lib into crates
Diffstat (limited to 'crates/turtle/db/client-record-migrations')
-rw-r--r--crates/turtle/db/client-record-migrations/20230531212437_create-records.sql16
-rw-r--r--crates/turtle/db/client-record-migrations/20231127090831_create-store.sql15
2 files changed, 0 insertions, 31 deletions
diff --git a/crates/turtle/db/client-record-migrations/20230531212437_create-records.sql b/crates/turtle/db/client-record-migrations/20230531212437_create-records.sql
deleted file mode 100644
index 4f4b304a..00000000
--- a/crates/turtle/db/client-record-migrations/20230531212437_create-records.sql
+++ /dev/null
@@ -1,16 +0,0 @@
--- Add migration script here
-create table if not exists records (
- id text primary key,
- parent text unique, -- null if this is the first one
- host text not null,
-
- timestamp integer not null,
- tag text not null,
- version text not null,
- data blob not null,
- cek blob not null
-);
-
-create index host_idx on records (host);
-create index tag_idx on records (tag);
-create index host_tag_idx on records (host, tag);
diff --git a/crates/turtle/db/client-record-migrations/20231127090831_create-store.sql b/crates/turtle/db/client-record-migrations/20231127090831_create-store.sql
deleted file mode 100644
index 53d78860..00000000
--- a/crates/turtle/db/client-record-migrations/20231127090831_create-store.sql
+++ /dev/null
@@ -1,15 +0,0 @@
--- 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);