Subversion Repositories computer_asset_manager_v1

drop table if exists file;
drop table if exists file_mime_type;
drop view if exists client_files;
drop view if exists site_files;
drop view if exists device_files;

delete from _system where group_name = 'Files';
delete from _system where key_name = 'Files';

delete from menu 
where 
   menu.parent_id in 
      ( select menu_id 
        from ( 
           select distinct a.menu_id as menu_id 
           from menu a join menu b on a.menu_id = b.menu_id 
           where a.caption = 'Files' 
           ) 
      as c );
delete from menu where caption = 'Files';