Subversion Repositories computer_asset_manager_v1

Rev

Rev 1 | Rev 55 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed 

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;