Index: openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql 7 May 2001 19:19:06 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql 21 Aug 2001 22:15:43 -0000 1.2 @@ -1,5 +1,34 @@ + + + drop table postcard_images; +drop trigger postcard_images_lob_trigger; drop table postcards; drop sequence postcard_seq; drop sequence postcard_image_seq; + +-- Drop permission metadata +delete from acs_permissions + where privilege in + ('postcard_create_card', 'postcard_create_image', + 'postcard_read', 'postcard_admin'); + + +delete from acs_privilege_hierarchy + where privilege in + ('postcard_create_card', 'postcard_create_image', + 'postcard_read', 'postcard_admin'); + +delete from acs_privilege_hierarchy + where child_privilege in + ('postcard_create_card', 'postcard_create_image', + 'postcard_read', 'postcard_admin'); + +delete from acs_privileges + where privilege in + ('postcard_create_card', 'postcard_create_image', + 'postcard_read', 'postcard_admin'); + + +