From e350a09276b5c53bc8a337efac014b1905d69eb4 Mon Sep 17 00:00:00 2001 From: Tony Mack Date: Wed, 11 Apr 2007 20:37:23 +0000 Subject: [PATCH] - event_object.object_type values default to 'Unknown' --- planetlab4.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/planetlab4.sql b/planetlab4.sql index f422c22..31311d1 100644 --- a/planetlab4.sql +++ b/planetlab4.sql @@ -9,7 +9,7 @@ -- -- Copyright (C) 2006 The Trustees of Princeton University -- --- $Id: planetlab4.sql,v 1.74 2007/04/02 20:45:49 tmack Exp $ +-- $Id: planetlab4.sql,v 1.75 2007/04/11 20:31:15 tmack Exp $ -- SET client_encoding = 'UNICODE'; @@ -784,7 +784,7 @@ CREATE TABLE events ( CREATE TABLE event_object ( event_id integer REFERENCES events NOT NULL, -- Event identifier object_id integer NOT NULL, -- Object identifier - object_type text -- What type of object is this event affecting + object_type text NOT NULL Default 'Unknown' -- What type of object is this event affecting ) WITH OIDS; CREATE INDEX event_object_event_id_idx ON event_object (event_id); CREATE INDEX event_object_object_id_idx ON event_object (object_id); -- 2.43.0