From 97f207b771b94c5285faae4810d6eeda1b78926b Mon Sep 17 00:00:00 2001
From: Benedikt Peetz <benedikt.peetz@b-peetz.de>
Date: Thu, 11 Jun 2026 16:10:29 +0200
Subject: chore(server): Simplify the database support

---
 .../20240108124830_create-history.sql                     | 15 ---------------
 1 file changed, 15 deletions(-)
 delete mode 100644 crates/turtle/db/server-sqlite-migrations/20240108124830_create-history.sql

(limited to 'crates/turtle/db/server-sqlite-migrations/20240108124830_create-history.sql')

diff --git a/crates/turtle/db/server-sqlite-migrations/20240108124830_create-history.sql b/crates/turtle/db/server-sqlite-migrations/20240108124830_create-history.sql
deleted file mode 100644
index 7bd653ba..00000000
--- a/crates/turtle/db/server-sqlite-migrations/20240108124830_create-history.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-create table history (
-	id integer primary key autoincrement,
-	client_id text not null unique, -- the client-generated ID
-	user_id bigserial not null,     -- allow multiple users
-	hostname text not null,         -- a unique identifier from the client (can be hashed, random, whatever)
-	timestamp timestamp not null,   -- one of the few non-encrypted metadatas
-
-	data text not null,    -- store the actual history data, encrypted. I don't wanna know!
-
-	created_at timestamp not null default current_timestamp,
-  deleted_at timestamp
-);
-
-create unique index history_deleted_index on history(client_id, user_id, deleted_at);
-
-- 
cgit v1.3.1

