fixes in sql schema for f37/pgsql14: oddly this was working before

diff --git a/planetlab5.sql b/planetlab5.sql
index a4f028d..61ff7fd 100644 (file)
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -1170,7 +1170,6 @@ nodes.key,
 CAST(date_part('epoch', nodes.date_created) AS bigint) AS date_created,
 CAST(date_part('epoch', nodes.last_updated) AS bigint) AS last_updated,
 CAST(date_part('epoch', nodes.last_contact) AS bigint) AS last_contact,  
-CAST(date_part('epoch', nodes.last_boot) AS bigint) AS last_boot,  
 CAST(date_part('epoch', nodes.last_download) AS bigint) AS last_download,  
 CAST(date_part('epoch', nodes.last_pcu_reboot) AS bigint) AS last_pcu_reboot,  
 CAST(date_part('epoch', nodes.last_pcu_confirmation) AS bigint) AS last_pcu_confirmation,  
@@ -1231,7 +1230,6 @@ AS nodegroup_ids
 FROM conf_files;
 
 --------------------------------------------------------------------------------
-DROP VIEW view_pcus;
 CREATE OR REPLACE VIEW view_pcus AS
 SELECT
 pcus.pcu_id,