oott/backend/database_migrations/09-add_scanner_to_device_events/up.sql at main - oott - Gitea: Git with a cup of tea

External/oott

mirror of https://github.com/rzuasti/oott.git synced 2026-07-08 19:21:54 +02:00

Files

T

rzuastiandClaude Opus 4.7 d6cf9be412 Record originating scanner on device events

So that consumers of the events API can tell whether a sighting came
from the ARP scanner or the mDNS listener. Adds a DeviceEventScanner
enum (Arp / Mdns) plumbed from each scanner's call site through to a
new scanner column on device_events, exposed via the existing events
endpoint and OpenAPI schema. Pre-existing rows are backfilled with
'ARP' since that was the only scanner before mDNS.

Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>

2026-06-01 08:09:34 -04:00

2 lines

89 B

SQL

Raw Permalink Blame History

ALTER TABLE device_events ADD COLUMN scanner TEXT NOT NULL DEFAULT 'ARP' COLLATE NOCASE;