17 lines
835 B
SQL
17 lines
835 B
SQL
-- Support for admin-API-configurable prober check types (see docs/USAGE.md,
|
|
-- "Управление типами проверок пробера"). Previously orchestrator.inbound_checks
|
|
-- was a YAML-only value baked into the process at startup.
|
|
|
|
-- Singleton row, deliberately separate from `settings`: unlike
|
|
-- fip_settle_seconds, inbound checks need no cross-field validation against
|
|
-- other orchestrator config, and ports is a list rather than a scalar, so it
|
|
-- doesn't fit the "add a column to settings" guidance left in
|
|
-- 0003_fip_settle_delay.sql.
|
|
CREATE TABLE inbound_checks_settings (
|
|
id INTEGER PRIMARY KEY CHECK (id = 1),
|
|
ports TEXT NOT NULL, -- JSON array of int, e.g. "[22,80,443,8080]"
|
|
icmp BOOLEAN NOT NULL DEFAULT 0,
|
|
created_at TIMESTAMP NOT NULL,
|
|
updated_at TIMESTAMP NOT NULL
|
|
);
|