add messages table and interface

[plcapi.git] / planetlab4.sql

diff --git a/planetlab4.sql b/planetlab4.sql
index 90c095b..bb8d1bd 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.24 2006/10/27 15:31:28 mlhuang Exp $
+-- $Id: planetlab4.sql,v 1.25 2006/10/31 21:45:45 mlhuang Exp $
 --
 
 --------------------------------------------------------------------------------
@@ -630,6 +630,16 @@ CREATE TABLE node_session (
     UNIQUE (session_id) -- Sessions are unique
 ) WITH OIDS;
 
+--------------------------------------------------------------------------------
+-- Message templates
+--------------------------------------------------------------------------------
+
+CREATE TABLE messages (
+    message_id text PRIMARY KEY, -- Message name
+    template text, -- Message template
+    enabled bool NOT NULL DEFAULT true -- Whether message is enabled
+) WITH OIDS;
+
 --------------------------------------------------------------------------------
 -- Events
 --------------------------------------------------------------------------------