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 = 'Modules' and key_name = 'Documents';

/* Menu Options */

create table temp 

   select * 

   from menu 

   where parent_id is null or parent_id not in  (select menu_id from menu where caption = 'Documents');

delete from menu;

insert into menu select * from temp;

drop table temp;

delete from menu where caption = 'Documents' and parent_id is null;