Index: openacs-4/packages/chat/sql/postgresql/chat-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/postgresql/chat-create.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/chat/sql/postgresql/chat-create.sql	7 Apr 2006 16:59:52 -0000	1.1.2.1
+++ openacs-4/packages/chat/sql/postgresql/chat-create.sql	20 Apr 2006 09:29:10 -0000	1.1.2.2
@@ -334,8 +334,7 @@
                        references parties(party_id)
                        constraint chat_msgs_creation_user_nn not null,
     creation_ip        varchar(50) ,
-    creation_date      date
-                       constraint chat_msgs_creation_date_nn not null,
+    creation_date      timestamptz,
     room_id            integer
                        constraint chat_msgs_room_id_fk references chat_rooms
 );