Files
buryan-infra/ops/scripts/init-agent-registry.sql
root 15b79e0b5b feat: formalize comms-agent and initialize agent_registry (F2-1)
- Populated agents/REGISTRY.md with 8 planned agents
- Created first agent charter: CHARTER-comms-agent.md (Telegram Bot)
- Added SQL init script for agent_registry table in PG (CT 151)
- Registered comms-agent as 'active' in the database
2026-10-07 12:38:50 +03:00

16 lines
650 B
SQL

-- Создание таблицы реестра агентов в БД buryan_monitoring (CT 151)
CREATE TABLE IF NOT EXISTS agent_registry (
id SERIAL PRIMARY KEY,
name VARCHAR(50) UNIQUE NOT NULL,
domain VARCHAR(50) NOT NULL,
status VARCHAR(20) DEFAULT 'inactive',
last_heartbeat TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Регистрация comms-agent
INSERT INTO agent_registry (name, domain, status, last_heartbeat)
VALUES ('comms-agent', 'comms', 'active', CURRENT_TIMESTAMP)
ON CONFLICT (name) DO UPDATE
SET status = 'active', last_heartbeat = CURRENT_TIMESTAMP;