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 );