Index: openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/oracle/upgrade/Attic/upgrade-5.0.1d5-5.0.1d6.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d5-5.0.1d6.sql	26 Feb 2019 18:06:43 -0000	1.1.2.1
@@ -0,0 +1,26 @@
+---
+--- Upgrade script from 5.0.1d5 to 5.0.1d6
+---
+--- Allow control over the avatar display in chat rooms
+---
+--- @author Hector Romojaro (hector.romojaro@gmail.com)
+--- @creation-date 26/02/2019
+--- @cvs-id $Id: upgrade-5.0.1d5-5.0.1d6.sql,v 1.1.2.1 2019/02/26 18:06:43 hectorr Exp $
+---
+
+begin;
+
+    alter table chat_rooms add column avatar_p char(1) default 't' constraint chat_rooms_avatar_p_ck check (avatar_p in ('t', 'f'));
+
+    acs_privilege.create_privilege('chat_avatar_allow', 'Enable/disable user avatars in a chat room');
+    acs_privilege.add_child('chat_room_admin', 'chat_avatar_allow');
+
+    acs_attribute.create_attribute (
+        object_type    => 'chat_room',
+        attribute_name => 'avatar_p',
+        pretty_name    => 'Avatar',
+        pretty_plural  => 'Avatars',
+        datatype       => 'boolean'
+    );
+
+end;