--
-- The Events Package
--
-- @author Michael Steigman (michael@steigman.net)
-- @version $Id: events-permissions-drop.sql,v 1.1 2003/03/09 12:07:30 lars Exp $
--
-- This package was originally written by Bryan Che and Philip Greenspun
--
-- GNU GPL v2
--

--
-- Privileges
--

-- Drop permission metadata
delete from acs_permissions
    where privilege in
        ('events_event_create', 'events_activity_create', 'events_event_write', 'events_activity_write','events_event_delete', 'events_activity_delete', 'events_event_read', 'events_activity_read');

delete from acs_privilege_hierarchy
    where privilege in
        ('events_event_create', 'events_activity_create', 'events_event_write', 'events_activity_write','events_event_delete', 'events_activity_delete', 'events_event_read', 'events_activity_read');

delete from acs_privilege_hierarchy
    where child_privilege in
        ('events_event_create', 'events_activity_create', 'events_event_write', 'events_activity_write','events_event_delete', 'events_activity_delete', 'events_event_read', 'events_activity_read');

delete from acs_privileges
    where privilege in
        ('events_event_create', 'events_activity_create', 'events_event_write', 'events_activity_write','events_event_delete', 'events_activity_delete', 'events_event_read', 'events_activity_read');