From 7a9e229d5f4913d1a48c92615bcb3234f5dcfd33 Mon Sep 17 00:00:00 2001 From: Benedikt Peetz Date: Thu, 11 Jun 2026 01:05:07 +0200 Subject: chore: Restore db migrations --- .../20240702094825_create-store-idx-cache.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 crates/turtle/db/server-sqlite-migrations/20240702094825_create-store-idx-cache.sql (limited to 'crates/turtle/db/server-sqlite-migrations/20240702094825_create-store-idx-cache.sql') diff --git a/crates/turtle/db/server-sqlite-migrations/20240702094825_create-store-idx-cache.sql b/crates/turtle/db/server-sqlite-migrations/20240702094825_create-store-idx-cache.sql new file mode 100644 index 00000000..cd54cb18 --- /dev/null +++ b/crates/turtle/db/server-sqlite-migrations/20240702094825_create-store-idx-cache.sql @@ -0,0 +1,10 @@ +create table store_idx_cache( + id integer primary key autoincrement, + user_id bigint, + + host uuid, + tag text, + idx bigint +); + +create unique index store_idx_cache_uniq on store_idx_cache(user_id, host, tag); -- cgit v1.3.1