g1t/services/events/migrations/0001_init.sql
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 attempts | 1 | -- Append-only log of every event published on the bus. Ids are |
| 2 | -- time-sortable, so ordering by id is ordering by time. | |
| 3 | CREATE 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 events | 7 | -- RFC 3339 UTC. |
| 8 | time TEXT NOT NULL, | |
| Initial g1t: services, event bus, intents and attempts | 9 | repo_id TEXT, |
| 10 | actor TEXT, | |
| Events service in Rust, with RFC 3339 times and accurate push events | 11 | -- JSON. |
| Initial g1t: services, event bus, intents and attempts | 12 | data TEXT NOT NULL |
| 13 | ); | |
| 14 | CREATE INDEX events_repo ON events (repo_id, id); |