2 DELETE from slice_instantiations WHERE instantiation='nm-controller';
7 DROP VIEW node_slices_whitelist;
8 DROP TABLE node_slice_whitelist;
10 CREATE OR REPLACE VIEW view_nodes AS
22 CAST(date_part('epoch', nodes.date_created) AS bigint) AS date_created,
23 CAST(date_part('epoch', nodes.last_updated) AS bigint) AS last_updated,
24 CAST(date_part('epoch', nodes.last_contact) AS bigint) AS last_contact,
26 peer_node.peer_node_id,
27 COALESCE((SELECT nodenetwork_ids FROM node_nodenetworks WHERE node_nodenetworks.node_id = nodes.node_id), '{}') AS nodenetwork_ids,
28 COALESCE((SELECT nodegroup_ids FROM node_nodegroups WHERE node_nodegroups.node_id = nodes.node_id), '{}') AS nodegroup_ids,
29 COALESCE((SELECT slice_ids FROM node_slices WHERE node_slices.node_id = nodes.node_id), '{}') AS slice_ids,
30 COALESCE((SELECT pcu_ids FROM node_pcus WHERE node_pcus.node_id = nodes.node_id), '{}') AS pcu_ids,
31 COALESCE((SELECT ports FROM node_pcus WHERE node_pcus.node_id = nodes.node_id), '{}') AS ports,
32 COALESCE((SELECT conf_file_ids FROM node_conf_files WHERE node_conf_files.node_id = nodes.node_id), '{}') AS conf_file_ids,
33 node_session.session_id AS session
35 LEFT JOIN peer_node USING (node_id)
36 LEFT JOIN node_session USING (node_id);
39 ---------- revert subversion
41 UPDATE plc_db_version SET subversion = 7;
42 SELECT subversion from plc_db_version;