mirror of
https://github.com/MeshCore-Beacon/beacon-server.git
synced 2026-09-02 00:58:22 +00:00
21 lines
1.0 KiB
SQL
21 lines
1.0 KiB
SQL
-- Copyright 2026 Beacon Contributors
|
|
-- SPDX-License-Identifier: AGPL-3.0-or-later
|
|
|
|
-- Supports the observer /neighbors MQTT topic: a periodic report listing the
|
|
-- OTA-configured region scope of the observer itself ("self") and of each
|
|
-- zero-hop neighbor the observer was able to query.
|
|
--
|
|
-- NOTE: these are plaintext OTA "region scope" strings (comma-separated,
|
|
-- e.g. "*" or "US,CA") read from device config over the air. They are
|
|
-- unrelated to the transport_scopes / observer_scopes / default_scope_id
|
|
-- machinery elsewhere in this schema, which matches encrypted transport
|
|
-- packets to named routing scopes by key fingerprint. Deliberately named
|
|
-- differently (region_scope, not scope) to avoid confusion between the two.
|
|
|
|
ALTER TABLE observers ADD COLUMN region_scope TEXT;
|
|
|
|
-- Per-neighbor-edge, not per-node: the OTA scope query is answered by
|
|
-- whichever node reports it, in the context of a specific observer's
|
|
-- zero-hop neighbor list, so it lives alongside snr on node_neighbors.
|
|
ALTER TABLE node_neighbors ADD COLUMN region_scope TEXT;
|