flagon-io/g1t

public

Where people and agents ship software together. The open-source git platform for the whole job: issues, agents, checks and deploys to the edge.

g1t/services/events/migrations/0001_init.sql

14 lines368 bytesCodeBlame

Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.

Initial g1t: services, event bus, intents and attempts1-- Append-only log of every event published on the bus. Ids are
2-- time-sortable, so ordering by id is ordering by time.
3CREATE TABLE events (
4 id TEXT PRIMARY KEY,
5 type TEXT NOT NULL,
6 source TEXT NOT NULL,
Events service in Rust, with RFC 3339 times and accurate push events7 -- RFC 3339 UTC.
8 time TEXT NOT NULL,
Initial g1t: services, event bus, intents and attempts9 repo_id TEXT,
10 actor TEXT,
Events service in Rust, with RFC 3339 times and accurate push events11 -- JSON.
Initial g1t: services, event bus, intents and attempts12 data TEXT NOT NULL
13);
14CREATE INDEX events_repo ON events (repo_id, id);