/** * The canonical presence-registry schema. * * The DDL here is the single source of truth the {@link PresenceStore} applies * through {@link PresenceStore.ensureSchema}. The very same statements are * mirrored in the app-boot migration `db/migrations/001_agentic_presence.sql` * (applied by the DataLayer migration runner). To keep those two application * paths from drifting, `schema.test.ts` normalises both and asserts they are * statement-for-statement identical — divergence is a red test, not a silent * production/boot mismatch. */ /** The presence & registry table name. */ export declare const PRESENCE_TABLE = "agentic_presence"; /** * The canonical presence-registry DDL. Forward-only and additive; every column * added here must also be added to the boot migration (the drift guard enforces * it). Capability (cognition/weight/family/host) is stored as an ENROLMENT * attribute — never a routing token. */ export declare const PRESENCE_SCHEMA_SQL = "CREATE TABLE IF NOT EXISTS agentic_presence (\n instance TEXT PRIMARY KEY,\n connection_id TEXT NOT NULL,\n identity TEXT NOT NULL,\n cognition TEXT,\n weight REAL,\n family TEXT,\n host TEXT,\n registered_at TEXT NOT NULL,\n last_seen INTEGER NOT NULL\n);\nCREATE INDEX IF NOT EXISTS idx_agentic_presence_last_seen ON agentic_presence (last_seen);\nCREATE INDEX IF NOT EXISTS idx_agentic_presence_connection ON agentic_presence (connection_id);";