Index: openacs-4/packages/chat/tcl/chat-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/Attic/chat-procs-oracle.xql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/chat/tcl/chat-procs-oracle.xql	11 Apr 2006 07:12:46 -0000	1.1.2.2
+++ openacs-4/packages/chat/tcl/chat-procs-oracle.xql	11 Apr 2006 07:59:01 -0000	1.1.2.3
@@ -226,8 +226,4 @@
       </querytext>
 </fullquery>
 
-
-
-
-
 </queryset>
\ No newline at end of file
Index: openacs-4/packages/chat/tcl/chat-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/Attic/chat-procs-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/chat/tcl/chat-procs-postgresql.xql	7 Apr 2006 16:59:52 -0000	1.1.2.1
+++ openacs-4/packages/chat/tcl/chat-procs-postgresql.xql	11 Apr 2006 07:59:01 -0000	1.1.2.2
@@ -221,23 +221,5 @@
       </querytext>
 </fullquery>
 
-<fullquery name="chat_flush_rooms.get_rooms">
-      <querytext>
-            select room_id 
-            from chat_rooms 
-            where archive_p = 't' and auto_flush_p = 't'
-      </querytext>
-</fullquery>
-
-<fullquery name="chat_room_flush.get_archives_messages">
-  <querytext>
-    select msg, creation_user, to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date
-    from chat_msgs
-    where room_id = :room_id
-          and msg is not null
-    order by creation_date
-  </querytext>
-</fullquery>
-
 </queryset>
 
Index: openacs-4/packages/chat/tcl/chat-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/Attic/chat-procs.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/chat/tcl/chat-procs.xql	11 Apr 2006 07:12:46 -0000	1.1.2.1
+++ openacs-4/packages/chat/tcl/chat-procs.xql	11 Apr 2006 07:59:01 -0000	1.1.2.2
@@ -18,5 +18,23 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="chat_flush_rooms.get_rooms">
+    <querytext>
+            select room_id 
+            from chat_rooms 
+            where archive_p = 't' and auto_flush_p = 't'
+    </querytext>
+  </fullquery>
+
+  <fullquery name="chat_room_flush.get_archives_messages">
+    <querytext>
+      select msg, creation_user, to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date
+      from chat_msgs
+      where room_id = :room_id
+          and msg is not null
+      order by creation_date
+    </querytext>
+  </fullquery>
+
 </queryset>