-- Создание таблицы реестра агентов в БД 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;