atuin/atuin-client/migrations/20220505083406_create-events.sql
Ellie Huxtable e297b98f72
Add local event log storage (#390)
* Add event data structures

This adds the data structures required to start syncing events, rather
than syncing history directly.

Adjust event

Fix

Add event data structure to client

* Add server event table sql

* Add client event table migration

Adjust migration

* Insert into event table from client

* Add event merge function

Right now this just ensures we have the right amount of events given the
history we have

BUT it will also be used to merge CREATE/DELETE events, resulting in
history being deleted :)

* Make CI happy

* Adjust

* we don't limit history length any more

* Update atuin-client/src/database.rs

Co-authored-by: Conrad Ludgate <conradludgate@gmail.com>

* fix usage

* Fix typo

* New Rust, new clippy stuff

Co-authored-by: Conrad Ludgate <conradludgate@gmail.com>
2022-11-04 09:08:20 +00:00

12 lines
312 B
SQL

create table if not exists events (
id text primary key,
timestamp integer not null,
hostname text not null,
event_type text not null,
history_id text not null
);
-- Ensure there is only ever one of each event type per history item
create unique index history_event_idx ON events(event_type, history_id);