2 Commits

Author	SHA1	Message	Date
Jason Staack	413376e363	fix(db): add missing GRANT statements to v9.7 migrations ... Migrations 030 (sites), 032 (device_interfaces), 033 (wireless_links), and 034 (sectors) were missing GRANT statements for app_user and poller_user. Without these, fresh deploys crash on site/sector CRUD with permission denied errors. Also added poller_user SELECT grants to migration 035 (site_alert_rules/events). Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>	2026-03-19 17:46:23 -05:00
Jason Staack	7147b15e13	feat(13-02): add device_interfaces table migration and ORM model ... - Migration 032 creates device_interfaces with RLS, MAC index, unique(device_id, name) - DeviceInterface SQLAlchemy model with all columns and device relationship Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>	2026-03-19 06:01:22 -05:00