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';