X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;h=61ff7fd86e72f10c81083cc7dde9fb6dfaa4dbb2;hb=119346542b56f968eb5649e52a929d9937718512;hp=a4f028d2f14963ede32a16754fd8dc7974466231;hpb=cbf8b264347629f692c36e22bbf35b00c609db1c;p=plcapi.git diff --git a/planetlab5.sql b/planetlab5.sql index a4f028d..61ff7fd 100644 --- 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,