1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
create table store (
id text primary key, -- remember to use uuidv7 for happy indices <3
client_id text not null, -- I am too uncomfortable with the idea of a client-generated primary key, even though it's fine mathematically
host text not null, -- a unique identifier for the host
idx bigint not null, -- the index of the record in this store, identified by (host, tag)
timestamp bigint not null, -- not a timestamp type, as those do not have nanosecond precision
version text not null,
tag text not null, -- what is this? history, kv, whatever. Remember clients get a log per tag per host
data text not null, -- store the actual history data, encrypted. I don't wanna know!
cek text not null,
user_id bigint not null, -- allow multiple users
created_at timestamp not null default current_timestamp
);
create unique index record_uniq ON store(user_id, host, tag, idx);
|
