Index: openacs-4/packages/chat/sql/oracle/chat-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/oracle/chat-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/chat/sql/oracle/chat-create.sql	19 Nov 2007 01:14:15 -0000	1.4
+++ openacs-4/packages/chat/sql/oracle/chat-create.sql	7 Aug 2017 23:48:07 -0000	1.5
@@ -148,7 +148,14 @@
 					   check (auto_flush_p in ('t', 'f')),
 	auto_transcript_p  char(1) default 'f'
 					   constraint chat_rooms_auto_transcript_ck
-					   check (auto_transcript_p in ('t', 'f'))
+					   check (auto_transcript_p in ('t', 'f')),
+	login_messages_p  char(1) default 't'
+					   constraint chat_rooms_login_messages_ck
+					   check (login_messages_p in ('t', 'f')),
+
+	logout_messages_p  char(1) default 't'
+					   constraint chat_rooms_logout_messages_ck
+					   check (logout_messages_p in ('t', 'f'))
 ); 
 
 declare
@@ -245,6 +252,8 @@
         archive_p      in chat_rooms.archive_p%TYPE      default 'f',
 	auto_flush_p   in chat_rooms.auto_flush_p%TYPE	 default 't',
 	auto_transcript_p in chat_rooms.auto_transcript_p%TYPE default 'f',
+	login_messages_p  in chat_rooms.login_messages_p%TYPE default  't',
+	logout_messages_p in chat_rooms.logout_messages_p%TYPE default 't',	
         context_id     in acs_objects.context_id%TYPE    default null,
         creation_date  in acs_objects.creation_date%TYPE default sysdate,
         creation_user  in acs_objects.creation_user%TYPE default null,
@@ -341,6 +350,8 @@
         archive_p      in chat_rooms.archive_p%TYPE      default 'f',
 	auto_flush_p   in chat_rooms.auto_flush_p%TYPE	 default 't',
 	auto_transcript_p in chat_rooms.auto_transcript_p%TYPE default 'f',
+	login_messages_p  in chat_rooms.login_messages_p%TYPE default  't',
+	logout_messages_p in chat_rooms.logout_messages_p%TYPE default 't',	
         context_id     in acs_objects.context_id%TYPE    default null,
         creation_date  in acs_objects.creation_date%TYPE default sysdate,
         creation_user  in acs_objects.creation_user%TYPE default null,
@@ -366,7 +377,9 @@
             active_p, 
             archive_p,
 	    auto_flush_p,
-	    auto_transcript_p)
+	    auto_transcript_p,
+	    login_messages_p,
+	    logout_messages_p)
 	values (
             v_room_id, 
             chat_room.new.pretty_name, 
@@ -375,7 +388,9 @@
             chat_room.new.active_p, 
             chat_room.new.archive_p,
 	    chat_room.new.auto_flush_p,
-	    chat_room.new.auto_transcript_p);
+	    chat_room.new.auto_transcript_p,
+	    chat_room.new.login_messages_p,
+	    chat_room.new.logout_messages_p);
 
         return v_room_id;
     end new;
