Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql	26 Jan 2004 15:39:45 -0000	1.2
+++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql	26 Feb 2004 15:28:44 -0000	1.3
@@ -29,29 +29,5 @@
 -- Missing this primary key made some queries below very slow
 alter table lang_messages_audit add constraint lang_messages_audit_pk primary key (package_key, message_key, locale, overwrite_date);
 
--- Make sure sync_time is not null for the first message imported. If we don't
--- do this we are missing a set of base messages to merge against on the next 
--- catalog import.
--- Messages with only one revision
-
--- Messages with only one revision
--- This query is slow. Not sure how to speed it up.
-update lang_messages lm
-       set lm.sync_time = sysdate
-       where not exists (select 1
-                               from lang_messages_audit lma
-                               where lma.package_key = lm.package_key
-                                 and lma.message_key = lm.message_key
-                                 and lma.locale = lm.locale
-                              );
-
--- Messages with multiple revisions
--- This query is slow as well.
- update lang_messages_audit lma1
-        set lma1.sync_time = sysdate
-        where lma1.overwrite_date = (select min(lma2.overwrite_date)
-                                    from lang_messages_audit lma2
-                                    where lma2.package_key = lma1.package_key
-                                      and lma2.message_key = lma1.message_key
-                                      and lma2.locale      = lma1.locale
-                                    );
+-- We have to leave sync_time null since we don't know when the messages in the db were last in sync
+-- with the catalog files