parakeet.at
A PLC Mirror written in Rust
mia.omg.lol
1create table if not exists dids
2(
3 did text primary key
4);
5
6create table if not exists operations
7(
8 did text not null references dids (did),
9 hash text not null,
10 prev text,
11 sig text not null,
12 nullified bool not null default false,
13
14 operation jsonb not null,
15
16 created_at timestamptz not null default now(),
17
18 primary key (did, hash)
19);
20
21create index if not exists operations_created on operations (created_at);
22create index if not exists operations_nullified on operations (nullified);