Files
Denozordec 9fa6269174
quality / changes (push) Successful in 7s
quality / commitlint (push) Skipped
quality / openapi (push) Successful in 30s
quality / web (push) Successful in 1m3s
quality / api (push) Successful in 1m15s
quality / linux-agent-smoke (push) Failing after 27s
quality / docker-check (push) Failing after 2m28s
CD / quality (push) Failing after 5m52s
CD / publish (push) Skipped
feat: harden firewall policies telemetry and operations
Implement reliable agent apply, telemetry v2, analytics retention, guarded rollouts, enrollment, labels and webhooks. Improve ReUI frontend data safety and bounded list loading, and add Docker smoke, recovery and resource checks. Document local verification and pending native acceptance.
2026-10-26 13:10:58 +07:00

20 lines
778 B
SQL

ALTER TABLE agent_install_links ADD COLUMN expires_at TEXT;
ALTER TABLE agent_install_links ADD COLUMN consumed_at TEXT;
ALTER TABLE agent_install_links ADD COLUMN consumed_token_hash TEXT;
UPDATE agent_install_links SET expires_at = strftime('%Y-%m-%dT%H:%M:%fZ', 'now', '+1 day') WHERE expires_at IS NULL;
CREATE TABLE agent_token_rotations (
agent_id TEXT PRIMARY KEY REFERENCES agents(id) ON DELETE CASCADE,
request_id TEXT NOT NULL UNIQUE,
created_at TEXT NOT NULL,
expires_at TEXT NOT NULL,
completed_at TEXT,
previous_token_hash TEXT,
next_token_hash TEXT
);
CREATE TABLE agent_credential_receipts (
agent_id TEXT PRIMARY KEY REFERENCES agents(id) ON DELETE CASCADE,
request_id TEXT NOT NULL,
token_hash TEXT NOT NULL,
completed_at TEXT NOT NULL
);