-- Galaxy Change Detection for OPC UA Server
-- Poll this query on an interval to detect when the hierarchy needs refreshing.
-- When time_of_last_deploy changes, a deployment has occurred and the OPC UA
-- server should re-run hierarchy.sql and attributes.sql to pick up changes
-- (new/removed objects, undeployed objects, etc.).

SELECT time_of_last_deploy
FROM galaxy;
