Index: openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	12 Jun 2002 15:24:02 -0000	1.3
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	24 Jun 2002 21:40:16 -0000	1.4
@@ -41,6 +41,7 @@
                                     constraint forums_mess_user_id_nn
                                     not null,
     posting_date                    timestamp
+                                    default now()
                                     constraint forum_mess_post_date_nn
                                     not null,
     state                           varchar(100)
@@ -58,7 +59,7 @@
     tree_sortkey                    varbit,
     max_child_sortkey               varbit,
     constraint forums_mess_sk_forum_un
-    unique (tree_sortkey,forum_id)
+    unique (tree_sortkey, forum_id)
 );
 
 create view forums_messages_approved
