Index: openacs-4/packages/logger/sql/oracle/logger-packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/logger/sql/oracle/logger-packages-create.sql,v diff -u -N -r1.6 -r1.7 --- openacs-4/packages/logger/sql/oracle/logger-packages-create.sql 30 Sep 2003 12:10:08 -0000 1.6 +++ openacs-4/packages/logger/sql/oracle/logger-packages-create.sql 11 Dec 2003 21:40:06 -0000 1.7 @@ -131,17 +131,18 @@ logger_entry.del(rec.entry_id); end loop; - -- Delete all variables only mapped to this project. + -- Delete all variables only mapped to this project that are not preinstalled (time, expenses) for rec in (select variable_id - from logger_variables - where exists (select 1 - from logger_project_pkg_map - where project_id = logger_project.del.project_id - ) - and not exists (select 1 - from logger_project_pkg_map - where project_id <> logger_project.del.project_id + from logger_variables + where package_id is not null + and exists (select 1 + from logger_project_pkg_map + where project_id = logger_project.del.project_id ) + and not exists (select 1 + from logger_project_pkg_map + where project_id <> logger_project.del.project_id + ) ) loop logger_variable.del(rec.variable_id);