Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v
diff -u -N -r1.17 -r1.18
--- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	12 Mar 2004 18:48:49 -0000	1.17
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	26 Jul 2004 12:21:39 -0000	1.18
@@ -175,11 +175,16 @@
 before update on acs_objects
 for each row
 begin
- :new.last_modified := sysdate;
+  if :new.last_modified is null then
+     :new.last_modified := :old.last_modified;
+  elsif :new.last_modified = :old.last_modified then
+     :new.last_modified := sysdate;
+  end if;
 end acs_objects_last_mod_update_tr;
 /
 show errors
 
+
 comment on table acs_objects is '
 ';