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.17 -r1.18
--- openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql	18 Dec 2003 16:12:17 -0000	1.17
+++ openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql	19 Dec 2003 10:23:11 -0000	1.18
@@ -2,223 +2,7 @@
 -- @creation-date 2003-10-12
 -- @cvs-id $Id$
 
---drop independent tables
-drop table sim_party_sim_map;
-drop table sim_tasks;
-drop table sim_role_party_map;
-drop table sim_roles;
-select acs_object_type__drop_type(
-	   'simulation',
-	   't'
-    );
-drop table sim_simulations;
-
--- drop content_types
-create function inline_0 () returns integer as '
-declare
-    row record;
-begin
-    for row in select folder_id 
-                  from cr_folders 
-                 where package_id in (select package_id 
-                                        from apm_packages 
-                                       where package_key = ''simulation'') loop
-            perform content_folder__unregister_content_type(v_id, ''sim_characters'',''t'');
-        end loop;
-    return 0;
-end;' language 'plpgsql';
-select inline_0();
-drop function inline_0 ();
-
-
-
-----------------------------------------------------------------------
--- drop everything in reverse order of creation
-----------------------------------------------------------------------
--- have to manually drop attributes because content_type__drop_type doesn't
--- bad, stupid content_type__drop_type
-
-----------------------------------------------------------------------
--- sim_case
-----------------------------------------------------------------------
-
-select content_type__drop_type(
-    'sim_case',
-    't',
-    't'
-);
-
-----------------------------------------------------------------------
--- sim_location
-----------------------------------------------------------------------
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'sim_location',                -- target_type
-    'is_located_in'                -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'image',                       -- target_type
-    'thumbnail'                    -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'sim_stylesheet',              -- target_type
-    'stylesheet'                   -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'image',                       -- target_type
-    'image'                        -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'image',                       -- target_type
-    'letterhead'                   -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_location',                -- content_type
-    'image',                       -- target_type
-    'logo'                         -- relation_tag
-);
-
-select content_type__drop_type(
-    'sim_location',
-    't',
-    't'
-);
-
-
-----------------------------------------------------------------------
--- sim_message
-----------------------------------------------------------------------
-
-select content_type__unregister_relation_type (
-    'sim_message',                 -- content_type
-    'sim_prop',                    -- target_type
-    'attachment'                   -- relation_tag
-);
-
-select content_type__drop_type(
-    'sim_message',
-    't',
-    't'
-);
-
-
-
-----------------------------------------------------------------------
--- sim_prop
-----------------------------------------------------------------------
-
-select content_type__unregister_relation_type (
-    'sim_prop',                    -- content_type
-    'image',                       -- target_type
-    'thumbnail'                    -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_prop',                    -- content_type
-    'sim_stylesheet',              -- target_type
-    'stylesheet'                   -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_prop',                    -- content_type
-    'image',                       -- target_type
-    'image'                        -- relation_tag
-);
-
-select content_type__drop_type(
-    'sim_prop',
-    't',
-    't'
-);
-
-
-----------------------------------------------------------------------
--- sim_character
-----------------------------------------------------------------------
-
-select content_type__unregister_relation_type (
-    'sim_character',               -- content_type
-    'sim_location',                -- target_type
-    'resides_at'                   -- relation_tag
-);
-
-
-select content_type__unregister_relation_type (
-    'sim_character',               -- content_type
-    'sim_location',                -- target_type
-    'works_for'                    -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_character',               -- content_type
-    'image',                       -- target_type
-    'thumbnail'                    -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_character',               -- content_type
-    'sim_stylesheet',              -- target_type
-    'stylesheet'                   -- relation_tag
-);
-
-select content_type__unregister_relation_type (
-    'sim_character',               -- content_type
-    'image',                       -- target_type
-    'image'                        -- relation_tag
-);
-
-select content_type__drop_type(
-    'sim_character',
-    't',
-    't'
-);
-
-----------------------------------------------------------------------
--- sim_stylesheet
-----------------------------------------------------------------------
-
-select content_type__drop_type(
-    'sim_stylesheet',
-    't',
-    't'
-
-);
-
-
-----------------------------------------------------------------------
--- privileges
-----------------------------------------------------------------------
-
-create function inline_0 ()
-returns integer as '
-begin
-    perform acs_privilege__remove_child(''sim_admin'',''sim_template_create'');
-    perform acs_privilege__remove_child(''sim_admin'',''sim_inst'');
-    perform acs_privilege__remove_child(''sim_admin'',''sim_object_writer'');
-    perform acs_privilege__remove_child(''sim_admin'',''sim_set_map_p'');
-    perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_create'');
-    perform acs_privilege__remove_child(''sim_object_writer'',''sim_object_write'');
-    perform acs_privilege__remove_child(''admin'',''sim_admin'');
-
-    perform acs_privilege__drop_privilege(''sim_object_write'');
-    perform acs_privilege__drop_privilege(''sim_object_create'');
-    perform acs_privilege__drop_privilege(''sim_object_writer'');
-    perform acs_privilege__drop_privilege(''sim_set_map_p'');
-    perform acs_privilege__drop_privilege(''sim_template_create'');
-    perform acs_privilege__drop_privilege(''sim_inst'');
-    perform acs_privilege__drop_privilege(''sim_admin'');
-    return null;
-end;' language 'plpgsql';
-
-select inline_0();
-drop function inline_0 ();
+\i simulation-tables-drop.sql
+\i simulation-content-types-drop.sql
+\i simulation-privs-drop.sql
+\i simulation-packages-drop.sql