Index: openacs-4/packages/chat/chat.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/chat.info,v
diff -u -r1.19 -r1.20
--- openacs-4/packages/chat/chat.info	12 Jul 2018 12:37:51 -0000	1.19
+++ openacs-4/packages/chat/chat.info	12 Jul 2018 12:43:09 -0000	1.20
@@ -9,7 +9,7 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.0" url="http://openacs.org/repository/download/apm/chat-5.0.apm">
+    <version name="5.0.1d0" url="http://openacs.org/repository/download/apm/chat-5.0.1d0.apm">
         <owner url="http://www.openacs.org">Peter Alberer</owner>
         <summary>Server based chat with an html and ajax client.</summary>
         <release-date>2017-08-06</release-date>
@@ -18,7 +18,7 @@
 Adapted by Tekne 2006/03/01 to replace JAVA server with AJAX; make use of generalized chat class from xotcl-core.</description>
         <maturity>0</maturity>
 
-        <provides url="chat" version="5.0"/>
+        <provides url="chat" version="5.0.1d0"/>
         <requires url="acs-kernel" version="5.9.1"/>
         <requires url="xotcl-core" version="0.83"/>
 
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.9 -r1.10
--- openacs-4/packages/chat/sql/postgresql/chat-create.sql	7 Aug 2017 23:48:07 -0000	1.9
+++ openacs-4/packages/chat/sql/postgresql/chat-create.sql	12 Jul 2018 12:43:09 -0000	1.10
@@ -76,8 +76,8 @@
           ''Chat Room'',  -- pretty_name
           ''Chat Rooms'', -- pretty_plural
           ''acs_object'', -- supertype
-          ''CHAT_ROOMS'', -- table_name
-          ''ROOM_ID'',    -- id_column
+          ''chat_rooms'', -- table_name
+          ''room_id'',    -- id_column
           null,           -- package_name
           ''f'',          -- abstract_p
           null,           -- type_extension_table
@@ -229,8 +229,8 @@
           ''Chat Transcript'',  -- pretty_name
           ''Chat Transcripts'', -- pretty_plural
           ''acs_object'',       -- supertype
-          ''CHAT_TRANSCRIPTS'', -- table_name
-          ''TRANSCRIPT_ID'',    -- id_column
+          ''chat_transcripts'', -- table_name
+          ''transcript_id'',    -- id_column
           null,           -- package_name
           ''f'',          -- abstract_p
           null,           -- type_extension_table
Index: openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0-5.0.1d0.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0-5.0.1d0.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0-5.0.1d0.sql	12 Jul 2018 12:43:09 -0000	1.1
@@ -0,0 +1,8 @@
+
+DO $$
+BEGIN
+   update acs_object_types set
+      table_name = lower(table_name),
+      id_column = lower(id_column)
+    where object_type in ('chat_room', 'chat_transcript');
+END$$;