Index: openacs-4/packages/wp-slim/sql/oracle/wp-slim-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/sql/oracle/wp-slim-drop.sql,v
diff -u -N -r1.3 -r1.3.2.1
--- openacs-4/packages/wp-slim/sql/oracle/wp-slim-drop.sql	13 Mar 2002 22:50:53 -0000	1.3
+++ openacs-4/packages/wp-slim/sql/oracle/wp-slim-drop.sql	21 May 2003 15:01:15 -0000	1.3.2.1
@@ -195,25 +195,35 @@
 
     default_context := acs.magic_object_id('default_context');
     registered_users := acs.magic_object_id('registered_users');
-    the_public := acs.magic_object_id('the_public');
+--    the_public := acs.magic_object_id('the_public');
 
     acs_permission.revoke_permission (
         object_id => default_context,
         grantee_id => registered_users,
         privilege => 'wp_create_presentation'
     );
 
-    acs_permission.revoke_permission (
-        object_id => default_context,
-        grantee_id => the_public,
-        privilege => 'wp_view_presentation'
-    );
+--    acs_permission.revoke_permission (
+--        object_id => default_context,
+--        grantee_id => the_public,
+--        privilege => 'wp_view_presentation'
+--    );
 
 end;
 /
 show errors
 
 begin
+	
+
+	acs_privilege.remove_child('admin', 'wp_admin_presentation');
+
+	acs_privilege.remove_child('wp_edit_presentation',  'wp_view_presentation');
+	acs_privilege.remove_child('wp_admin_presentation', 'wp_create_presentation');
+	acs_privilege.remove_child('wp_admin_presentation', 'wp_edit_presentation');
+	acs_privilege.remove_child('wp_admin_presentation', 'wp_delete_presentation');
+
+
 	delete from acs_permissions
 	where privilege in ('wp_admin_presentation', 'wp_create_presentation', 'wp_edit_presentation', 'wp_delete_presentation', 'wp_view_presentation');
 	acs_privilege.drop_privilege('wp_admin_presentation');
@@ -253,6 +263,15 @@
 drop view cr_wp_presentationsx;
 drop table cr_wp_presentations;
 
+-- droping style definitions roc@
+
+drop package wp_style;
+
+
+drop sequence wp_style_seq;
+
+drop table wp_style_images;
+
 drop table wp_styles;
 
 commit;
Index: openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql,v
diff -u -N -r1.3.2.1 -r1.3.2.2
--- openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql	2 Mar 2003 22:56:43 -0000	1.3.2.1
+++ openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql	21 May 2003 14:59:07 -0000	1.3.2.2
@@ -315,26 +315,35 @@
 
     default_context := acs__magic_object_id(''default_context'');
     registered_users := acs__magic_object_id(''registered_users'');
-    the_public := acs__magic_object_id(''the_public'');
+--    the_public := acs__magic_object_id(''the_public'');
 
     PERFORM acs_permission__revoke_permission (
          default_context,
          registered_users,
          ''wp_create_presentation''
     );
 
-    PERFORM acs_permission__revoke_permission (
-         default_context,
-         the_public,
-         ''wp_view_presentation''
-    );
+--    PERFORM acs_permission__revoke_permission (
+--         default_context,
+--         the_public,
+--        ''wp_view_presentation''
+--    );
 
 return 0;
 end;' language 'plpgsql';
 select inline_11 ();
 drop function inline_11 ();
 
 --checked
+
+select acs_privilege__remove_child('admin', 'wp_admin_presentation');
+
+select acs_privilege__remove_child('wp_edit_presentation', 'wp_view_presentation');
+select acs_privilege__remove_child('wp_admin_presentation', 'wp_create_presentation');
+select acs_privilege__remove_child('wp_admin_presentation', 'wp_edit_presentation');
+select acs_privilege__remove_child('wp_admin_presentation', 'wp_delete_presentation');
+
+
 create function inline_12 ()
 returns integer as'
 begin
@@ -368,7 +377,7 @@
 --drop package wp_slide;
 DROP FUNCTION wp_slide__new(
 	integer,
-	timestamptz,
+	timestamp,
 	integer,
 	varchar,
 	varchar,
@@ -408,7 +417,7 @@
 
 --drop package wp_presentation;
 DROP FUNCTION wp_presentation__new(
-	timestamptz,
+	timestamp,
 	integer,
 	varchar,
 	varchar,
@@ -450,7 +459,7 @@
 );
 
 drop function wp_slide__new_revision(
-    timestamptz,
+    timestamp,
     integer,
     varchar,
     integer,
@@ -465,7 +474,7 @@
     boolean);
 
 drop function wp_presentation__new_revision (
-    timestamptz,
+    timestamp,
     integer,	 
     varchar,	 
     integer,	 
@@ -500,10 +509,19 @@
 drop view cr_wp_presentationsx;
 drop table cr_wp_presentations;
 
-drop table wp_styles;
 drop function wp_slide__get_bullet_items_revision(integer);
 drop function wp_slide__get_postamble_revision(integer);
 drop function wp_slide__get_bullet_items(integer);
 drop function wp_slide__get_postamble(integer);
 
 drop function wp_presentation__set_live_revision(integer);
+
+drop sequence wp_style_seq;
+
+
+drop function wp_style__delete(integer);
+
+drop function wp_style__image_delete(integer);
+drop table wp_style_images;
+drop table wp_styles;
+