git://git.onelab.eu
/
plcapi.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
- add node_id to view_events
[plcapi.git]
/
planetlab4.sql
diff --git
a/planetlab4.sql
b/planetlab4.sql
index
0e28ec1
..
90c095b
100644
(file)
--- a/
planetlab4.sql
+++ b/
planetlab4.sql
@@
-9,7
+9,7
@@
--
-- Copyright (C) 2006 The Trustees of Princeton University
--
--
-- Copyright (C) 2006 The Trustees of Princeton University
--
--- $Id: planetlab4.sql,v 1.2
3 2006/10/25 14:13:14
mlhuang Exp $
+-- $Id: planetlab4.sql,v 1.2
4 2006/10/27 15:31:28
mlhuang Exp $
--
--------------------------------------------------------------------------------
--
--------------------------------------------------------------------------------
@@
-703,22
+703,21
@@
GROUP BY event_id;
-- Useful views
--------------------------------------------------------------------------------
-- Useful views
--------------------------------------------------------------------------------
---view_events
CREATE VIEW view_events AS
SELECT
events.event_id,
events.person_id,
CREATE VIEW view_events AS
SELECT
events.event_id,
events.person_id,
+events.node_id,
event_objects.object_ids,
events.event_type,
events.object_type,
events.fault_code,
events.call,
events.runtime,
event_objects.object_ids,
events.event_type,
events.object_type,
events.fault_code,
events.call,
events.runtime,
-
events.
time
-F
rom
events
+
CAST(date_part('epoch', events.time) AS bigint) AS
time
+F
ROM
events
LEFT JOIN event_objects USING (event_id);
LEFT JOIN event_objects USING (event_id);
--- view_persons
CREATE VIEW view_persons AS
SELECT
persons.person_id,
CREATE VIEW view_persons AS
SELECT
persons.person_id,