The miner needs an immutable, append-only event log (distinct from the mutable portfolio table in the schema foundation issue) so every state transition a PR goes through — opened, polled, ci_passed, ci_failed, gate_merged, gate_closed, rejected, disengaged — is replayable and auditable locally, mirroring the spirit of the cloud review_audit ledger but 100% client-side.
Deliverables
References
packages/gittensory-miner/src/state/schema.ts (new, from the schema-foundation issue — this ledger is a sibling table in the same local DB)
migrations/0049_review_audit_parity.sql — cloud audit-ledger naming precedent (event_type discriminator column) to mirror in spirit only
- New:
packages/gittensory-miner/src/state/event-ledger.ts
The miner needs an immutable, append-only event log (distinct from the mutable portfolio table in the schema foundation issue) so every state transition a PR goes through — opened, polled, ci_passed, ci_failed, gate_merged, gate_closed, rejected, disengaged — is replayable and auditable locally, mirroring the spirit of the cloud
review_auditledger but 100% client-side.Deliverables
packages/gittensory-miner/src/state/event-ledger.ts—appendEvent()(insert-only, never update/delete) andreadEvents(filter)References
packages/gittensory-miner/src/state/schema.ts(new, from the schema-foundation issue — this ledger is a sibling table in the same local DB)migrations/0049_review_audit_parity.sql— cloud audit-ledger naming precedent (event_type discriminator column) to mirror in spirit onlypackages/gittensory-miner/src/state/event-ledger.ts