Index: openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0d12-5.0d13.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/chat/sql/postgresql/upgrade/upgrade-5.0d12-5.0d13.sql	7 Aug 2017 23:48:07 -0000	1.2
@@ -0,0 +1,18 @@
+begin;
+
+-- dropping unneded database functions: we now use plain db operations for this
+drop   function chat_transcript__new (varchar, varchar, varchar, integer, integer, timestamptz, integer,  varchar, varchar);
+drop   function chat_transcript__edit (integer, varchar, varchar, varchar );
+
+drop   function chat_room__new (integer, varchar, varchar, boolean, boolean, boolean, boolean, boolean, boolean, boolean, integer, timestamptz, integer, varchar, varchar);
+drop   function chat_room__name (integer);
+drop   function chat_room__edit (integer, varchar, varchar, boolean, boolean, boolean, boolean, boolean, boolean, boolean);
+
+drop   function chat_room__message_count (integer);
+
+
+-- add the new column to specify how much in the past the users will see when entering a chat room
+alter table chat_rooms add column messages_time_window integer default 600;
+
+
+end;
