jetstream v2 in zig stream.waow.tech
Something went wrong. Try again.
12345678910111213141516171819202122232425262728293031CREATE TABLE IF NOT EXISTS segments ( idx INTEGER PRIMARY KEY, name TEXT NOT NULL, size_bytes INTEGER NOT NULL, checksum TEXT NOT NULL, event_count INTEGER NOT NULL, block_count INTEGER NOT NULL, min_seq INTEGER NOT NULL, max_seq INTEGER NOT NULL, min_witnessed_at INTEGER NOT NULL, max_witnessed_at INTEGER NOT NULL, ingested_at INTEGER NOT NULL);
CREATE TABLE IF NOT EXISTS segment_collections ( idx INTEGER NOT NULL REFERENCES segments(idx), nsid TEXT NOT NULL, ns TEXT NOT NULL, count INTEGER NOT NULL, PRIMARY KEY (idx, nsid));
CREATE INDEX IF NOT EXISTS segment_collections_nsid ON segment_collections (nsid, idx);CREATE INDEX IF NOT EXISTS segment_collections_ns ON segment_collections (ns, idx);
CREATE TABLE IF NOT EXISTS meta ( key TEXT PRIMARY KEY, value INTEGER NOT NULL, updated_at INTEGER NOT NULL);