Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 13 Oct 2003 07:58:52 -0000 1.1 +++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql 13 Oct 2003 09:57:02 -0000 1.2 @@ -6,44 +6,36 @@ select drop_package('sim_object'); delete from acs_permissions - where object_id in (select simobject_id from sim_object); + where object_id in (select sim_object_id from sim_objects); --drop objects --declare -- object_rec record; --begin --- for object_rec in select object_id from acs_objects where object_type=''simobject'' +-- 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 tables -drop table sim_taskresult; -drop table sim_case; -drop table sim_task; -drop table sim_role; -drop table sim_object_in_template; -drop table sim_party_in_sim; -drop table sim_simulation; -drop table sim_template; -drop table sim_object; +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_objects; --drop types select acs_object_type__drop_type( - 'simobject', + 'sim_object', 't' ); select acs_object_type__drop_type( - 'simtemplate', + 'simulation', 't' ); -select acs_object_type__drop_type( - 'simsimulation', - 't' - ); -