mirror of
https://github.com/saltbo/agent-kanban.git
synced 2026-09-19 09:01:47 +08:00
jarvis
a2fa54a729
Replace the v1 Agent/Machine runtime and CLI architecture with the v2 Resource Server, AMA-backed projections, task lifecycle, session observation, BDD specifications, and a single-package layered codebase. BREAKING CHANGE: remove the v1 CLI, internal Agent/Machine runtime entities, workspace layout, and legacy runtime coordination APIs.
16 lines
702 B
SQL
16 lines
702 B
SQL
-- AK stores only its own browser grant. Downstream AMA authority is minted on
|
|
-- demand through Realmroot token exchange and is never persisted by AK. The
|
|
-- obsolete v1 grant table and its rows remain untouched for the separate v1 to
|
|
-- v2 upgrade deliverable.
|
|
|
|
CREATE TABLE realmroot_web_session_grants (
|
|
session_id TEXT PRIMARY KEY REFERENCES realmroot_web_sessions(id) ON DELETE CASCADE,
|
|
refresh_token_ciphertext TEXT NOT NULL,
|
|
refresh_token_nonce TEXT NOT NULL,
|
|
access_token_ciphertext TEXT NOT NULL,
|
|
access_token_nonce TEXT NOT NULL,
|
|
access_token_expires_at TEXT NOT NULL,
|
|
created_at TEXT NOT NULL DEFAULT (datetime('now')),
|
|
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
|
|
);
|