repositories
loading repo index
repositories
loading repo index
repository
loading code, commits, and activity
public Clawd ADK gateway launch mirror
stars
latest
clone command
git clone gitlawb://did:key:z6Mkq5mY...iFZ5/my-project-publ...git clone gitlawb://did:key:z6Mkq5mY.../my-project-publ...2fa351d6docs: add automaton and perps launch sources16d ago| #1 | /** |
| #2 | * Automaton SQLite Schema |
| #3 | * |
| #4 | * All tables for the automaton's persistent state. |
| #5 | * The database IS the automaton's memory. |
| #6 | */ |
| #7 | export declare const SCHEMA_VERSION = 3; |
| #8 | export declare const CREATE_TABLES = "\n -- Schema version tracking\n CREATE TABLE IF NOT EXISTS schema_version (\n version INTEGER PRIMARY KEY,\n applied_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Core identity key-value store\n CREATE TABLE IF NOT EXISTS identity (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n );\n\n -- Agent reasoning turns (the thinking/action log)\n CREATE TABLE IF NOT EXISTS turns (\n id TEXT PRIMARY KEY,\n timestamp TEXT NOT NULL,\n state TEXT NOT NULL,\n input TEXT,\n input_source TEXT,\n thinking TEXT NOT NULL,\n tool_calls TEXT NOT NULL DEFAULT '[]',\n token_usage TEXT NOT NULL DEFAULT '{}',\n cost_cents INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Tool call results (denormalized for fast lookup)\n CREATE TABLE IF NOT EXISTS tool_calls (\n id TEXT PRIMARY KEY,\n turn_id TEXT NOT NULL REFERENCES turns(id),\n name TEXT NOT NULL,\n arguments TEXT NOT NULL DEFAULT '{}',\n result TEXT NOT NULL DEFAULT '',\n duration_ms INTEGER NOT NULL DEFAULT 0,\n error TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Heartbeat configuration entries\n CREATE TABLE IF NOT EXISTS heartbeat_entries (\n name TEXT PRIMARY KEY,\n schedule TEXT NOT NULL,\n task TEXT NOT NULL,\n enabled INTEGER NOT NULL DEFAULT 1,\n last_run TEXT,\n next_run TEXT,\n params TEXT DEFAULT '{}',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Financial transaction log\n CREATE TABLE IF NOT EXISTS transactions (\n id TEXT PRIMARY KEY,\n type TEXT NOT NULL,\n amount_cents INTEGER,\n balance_after_cents INTEGER,\n description TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Installed tools and MCP servers\n CREATE TABLE IF NOT EXISTS installed_tools (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n type TEXT NOT NULL,\n config TEXT DEFAULT '{}',\n installed_at TEXT NOT NULL DEFAULT (datetime('now')),\n enabled INTEGER NOT NULL DEFAULT 1\n );\n\n -- Self-modification audit log (append-only)\n CREATE TABLE IF NOT EXISTS modifications (\n id TEXT PRIMARY KEY,\n timestamp TEXT NOT NULL,\n type TEXT NOT NULL,\n description TEXT NOT NULL,\n file_path TEXT,\n diff TEXT,\n reversible INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- General key-value store for arbitrary state\n CREATE TABLE IF NOT EXISTS kv (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Installed skills\n CREATE TABLE IF NOT EXISTS skills (\n name TEXT PRIMARY KEY,\n description TEXT NOT NULL DEFAULT '',\n auto_activate INTEGER NOT NULL DEFAULT 1,\n requires TEXT DEFAULT '{}',\n instructions TEXT NOT NULL DEFAULT '',\n source TEXT NOT NULL DEFAULT 'builtin',\n path TEXT NOT NULL DEFAULT '',\n enabled INTEGER NOT NULL DEFAULT 1,\n installed_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Spawned child automatons\n CREATE TABLE IF NOT EXISTS children (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n address TEXT NOT NULL,\n sandbox_id TEXT NOT NULL,\n genesis_prompt TEXT NOT NULL,\n creator_message TEXT,\n funded_amount_cents INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'spawning',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n last_checked TEXT\n );\n\n -- ERC-8004 registration state\n CREATE TABLE IF NOT EXISTS registry (\n agent_id TEXT PRIMARY KEY,\n agent_uri TEXT NOT NULL,\n chain TEXT NOT NULL DEFAULT 'eip155:8453',\n contract_address TEXT NOT NULL,\n tx_hash TEXT NOT NULL,\n registered_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Reputation feedback received and given\n CREATE TABLE IF NOT EXISTS reputation (\n id TEXT PRIMARY KEY,\n from_agent TEXT NOT NULL,\n to_agent TEXT NOT NULL,\n score INTEGER NOT NULL,\n comment TEXT NOT NULL DEFAULT '',\n tx_hash TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n -- Indices for common queries\n CREATE INDEX IF NOT EXISTS idx_turns_timestamp ON turns(timestamp);\n CREATE INDEX IF NOT EXISTS idx_turns_state ON turns(state);\n CREATE INDEX IF NOT EXISTS idx_tool_calls_turn ON tool_calls(turn_id);\n CREATE INDEX IF NOT EXISTS idx_transactions_type ON transactions(type);\n CREATE INDEX IF NOT EXISTS idx_modifications_type ON modifications(type);\n CREATE INDEX IF NOT EXISTS idx_skills_enabled ON skills(enabled);\n CREATE INDEX IF NOT EXISTS idx_children_status ON children(status);\n CREATE INDEX IF NOT EXISTS idx_reputation_to ON reputation(to_agent);\n\n -- Inbox messages table\n CREATE TABLE IF NOT EXISTS inbox_messages (\n id TEXT PRIMARY KEY,\n from_address TEXT NOT NULL,\n content TEXT NOT NULL,\n received_at TEXT NOT NULL DEFAULT (datetime('now')),\n processed_at TEXT,\n reply_to TEXT\n );\n\n CREATE INDEX IF NOT EXISTS idx_inbox_unprocessed\n ON inbox_messages(received_at) WHERE processed_at IS NULL;\n"; |
| #9 | export declare const MIGRATION_V3 = "\n CREATE TABLE IF NOT EXISTS inbox_messages (\n id TEXT PRIMARY KEY,\n from_address TEXT NOT NULL,\n content TEXT NOT NULL,\n received_at TEXT NOT NULL DEFAULT (datetime('now')),\n processed_at TEXT,\n reply_to TEXT\n );\n\n CREATE INDEX IF NOT EXISTS idx_inbox_unprocessed\n ON inbox_messages(received_at) WHERE processed_at IS NULL;\n"; |
| #10 | export declare const MIGRATION_V2 = "\n CREATE TABLE IF NOT EXISTS skills (\n name TEXT PRIMARY KEY,\n description TEXT NOT NULL DEFAULT '',\n auto_activate INTEGER NOT NULL DEFAULT 1,\n requires TEXT DEFAULT '{}',\n instructions TEXT NOT NULL DEFAULT '',\n source TEXT NOT NULL DEFAULT 'builtin',\n path TEXT NOT NULL DEFAULT '',\n enabled INTEGER NOT NULL DEFAULT 1,\n installed_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n CREATE TABLE IF NOT EXISTS children (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n address TEXT NOT NULL,\n sandbox_id TEXT NOT NULL,\n genesis_prompt TEXT NOT NULL,\n creator_message TEXT,\n funded_amount_cents INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'spawning',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n last_checked TEXT\n );\n\n CREATE TABLE IF NOT EXISTS registry (\n agent_id TEXT PRIMARY KEY,\n agent_uri TEXT NOT NULL,\n chain TEXT NOT NULL DEFAULT 'eip155:8453',\n contract_address TEXT NOT NULL,\n tx_hash TEXT NOT NULL,\n registered_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n CREATE TABLE IF NOT EXISTS reputation (\n id TEXT PRIMARY KEY,\n from_agent TEXT NOT NULL,\n to_agent TEXT NOT NULL,\n score INTEGER NOT NULL,\n comment TEXT NOT NULL DEFAULT '',\n tx_hash TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n );\n\n CREATE INDEX IF NOT EXISTS idx_skills_enabled ON skills(enabled);\n CREATE INDEX IF NOT EXISTS idx_children_status ON children(status);\n CREATE INDEX IF NOT EXISTS idx_reputation_to ON reputation(to_agent);\n"; |
| #11 | //# sourceMappingURL=schema.d.ts.map |