Subversion Repositories computer_asset_manager_v1

drop table if exists document;
drop table if exists document_mime_type;
drop view if exists client_documents;
drop view if exists site_documents;
drop view if exists device_documents;

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

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 = 'Documents' 
           ) 
      as c );
delete from menu where caption = 'Documents';