migrations/2021-03-20-151809_create_history/up.sql


1
2
3
4
5
6
7
8
9
10
11

-- Your SQL goes here
-- lower case SQL please, this isn't a shouting match
create table history (
	id bigserial primary key,
	client_id text not null unique, -- the client-generated ID
	user_id bigserial not null,     -- allow multiple users
	mac varchar(128) not null,      -- store a hashed mac address, to identify machines - more likely to be unique than hostname
	timestamp timestamp not null,   -- one of the few non-encrypted metadatas

	data varchar(8192) not null     -- store the actual history data, encrypted. I don't wanna know!
);