Index: openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql	3 Dec 2002 17:26:54 -0000	1.3
+++ openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql	19 Dec 2002 16:00:53 -0000	1.4
@@ -23,7 +23,7 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="lang::catalog::export_package_to_files.get_messages">
+  <fullquery name="lang::catalog::all_messages_for_package_and_locale.get_messages">
     <querytext>
         select message_key, message
         from lang_messages
@@ -47,4 +47,31 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="lang::catalog::reset_upgrade_status_message_keys.reset_status">
+    <querytext>
+        update lang_message_keys
+              set upgrade_status = 'no_upgrade'
+              where package_key = :package_key
+    </querytext>
+  </fullquery>
+
+  <fullquery name="lang::catalog::import_messages_from_file.reset_upgrade_status_messages">
+    <querytext>
+        update lang_messages
+                set upgrade_status = 'no_upgrade'
+                where package_key = :package_key
+                  and locale = :locale      
+    </querytext>
+  </fullquery>
+
+  <fullquery name="lang::catalog::import_messages_from_file.mark_message_as_deleted">
+    <querytext>
+        update lang_messages
+           set upgrade_status = 'deleted'
+           where package_key = :package_key
+             and message_key = :message_key
+             and locale = :locale
+    </querytext>
+  </fullquery>
+
 </queryset>