- added runtime to view_events

[plcapi.git] / planetlab4.sql

diff --git a/planetlab4.sql b/planetlab4.sql
index 25ad254..c9ec560 100644 (file)
--- a/planetlab4.sql
+++ b/planetlab4.sql
@@ -9,7 +9,7 @@
 --
 -- Copyright (C) 2006 The Trustees of Princeton University
 --
--- $Id: planetlab4.sql,v 1.17 2006/10/19 21:36:54 tmack Exp $
+-- $Id: planetlab4.sql,v 1.20 2006/10/23 16:25:46 tmack Exp $
 --
 
 --------------------------------------------------------------------------------
@@ -609,6 +609,7 @@ INSERT INTO event_types (event_type) VALUES ('AddTo');
 INSERT INTO event_types (event_type) VALUES ('Get');
 INSERT INTO event_types (event_type) VALUES ('Update');
 INSERT INTO event_types (event_type) VALUES ('Delete');
+INSERT INTO event_types (event_type) VALUES ('DeleteFrom');
 INSERT INTO event_types (event_type) VALUES ('Unknown');
 
 -- object types
@@ -620,6 +621,7 @@ CREATE TABLE object_types (
 INSERT INTO object_types (object_type) VALUES ('AddressType');
 INSERT INTO object_types (object_type) VALUES ('Address');
 INSERT INTO object_types (object_type) VALUES ('BootState');
+INSERT INTO object_types (object_type) VALUES ('ConfFile');
 INSERT INTO object_types (object_type) VALUES ('KeyType');
 INSERT INTO object_types (object_type) VALUES ('Key');
 INSERT INTO object_types (object_type) VALUES ('NetworkMethod');
@@ -681,6 +683,7 @@ events.event_type,
 events.object_type,
 events.fault_code,
 events.call,
+events.runtime,
 events.time
 From events
 LEFT JOIN event_objects USING (event_id);