3 -- the site_nodes should restrict to nodes where deleted is false
6 CREATE OR REPLACE VIEW site_nodes AS
8 array_accum(node_id) AS node_ids
10 WHERE deleted is false
14 UPDATE plc_db_version SET subversion = 4;
15 SELECT subversion from plc_db_version;