--
-- packages/file-storage/sql/file-storage-drop.sql
--
-- @author Kevin Scaldeferri (kevin@arsdigita.com)
-- @creation-date 6 Now 2000
-- @cvs-id $Id: file-storage-drop.sql,v 1.1.1.1 2001/04/20 20:51:10 donb Exp $
--
-- drop script for file-storage
--

--
-- content repository is set up to cascade, so we should just have to 
-- delete the root folders
--

declare
    cursor c_root_folders
    is
    select folder_id
    from   fs_root_folders;
begin
    for v_root_folder in c_root_folders loop
        acs_object.delete(v_root_folder.folder_id);
    end loop;
end;
/
show errors

drop table fs_root_folders;
drop package file_storage;