Index: openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 12 Nov 2003 11:38:29 -0000 1.6 +++ openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql 12 Nov 2003 12:47:54 -0000 1.7 @@ -3,42 +3,19 @@ -- @cvs-id $Id$ -select drop_package('sim_object'); - ---drop objects ---declare --- object_rec record; ---begin --- for object_rec in select object_id from acs_objects where object_type=''sim_object'' --- loop --- perform acs_object__delete( object_rec.object_id ); --- end loop; --- return 0; ---end;' language 'plpgsql'; - --drop independent tables drop table sim_party_sim_map; -drop table sim_simulations; drop table sim_tasks; drop table sim_roles; drop table sim_workflow_object_map; drop table sim_workflow_cases; +drop table sim_simulations; select acs_object_type__drop_type( 'simulation', 't' ); ---drop objects ---declare --- object_rec record; ---begin --- for object_rec in select object_id from acs_objects where object_type=''sim_object'' --- loop --- perform acs_object__delete( object_rec.object_id ); --- end loop; --- return 0; ---end;' language 'plpgsql'; -- drop content_types create function inline_0 () returns integer as '