-- /packages/ticket-tracker-lite/sql/ticket-tracker-lite-drop.sql
--
-- @author dvr@arsdigita.com
-- @created 2001-02-18
--
---------------------------------------------------

drop table ttl_prefs;
drop table ttl_area_assignments;
drop table ttl_assignments;
drop table ttl_comments;
drop table ttl_tickets;
drop table ttl_status;
drop table ttl_areas;

delete from acs_permissions
where object_id in (select package_id
                    from apm_packages
                    where package_key = 'ticket-tracker-lite');

delete from acs_objects where object_type like 'ticket_tracker_lite%';

begin
    acs_object_type.drop_type('ticket_tracker_lite_area');
    acs_object_type.drop_type('ticket_tracker_lite_ticket');
end;
/