add subject field to messages table

diff --git a/PLC/Messages.py b/PLC/Messages.py
index 5869d7f..fd8f045 100644 (file)
--- a/PLC/Messages.py
+++ b/PLC/Messages.py
@@ -4,7 +4,7 @@
 # Tony Mack <tmack@cs.princeton.edu>
 # Copyright (C) 2006 The Trustees of Princeton University
 #
-# $Id: Messages.py,v 1.2 2006/11/08 22:58:23 mlhuang Exp $
+# $Id: Messages.py,v 1.3 2006/11/10 17:06:35 mlhuang Exp $
 #
 
 from PLC.Parameter import Parameter
@@ -19,6 +19,7 @@ class Message(Row):
     primary_key = 'message_id'
     fields = {
         'message_id': Parameter(str, "Message identifier"),
+        'subject': Parameter(str, "Message summary", nullok = True),
         'template': Parameter(str, "Message template", nullok = True),
         'enabled': Parameter(bool, "Message is enabled"),
         }

diff --git a/planetlab4.sql b/planetlab4.sql
index d2c0b54..812135d 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.37 2006/11/15 21:07:30 tmack Exp $
+-- $Id: planetlab4.sql,v 1.38 2006/11/15 21:34:48 tmack Exp $
 --
 
 --------------------------------------------------------------------------------
@@ -693,6 +693,7 @@ CREATE TABLE node_session (
 
 CREATE TABLE messages (
     message_id text PRIMARY KEY, -- Message name
+    subject text, -- Message summary
     template text, -- Message template
     enabled bool NOT NULL DEFAULT true -- Whether message is enabled
 ) WITH OIDS;