Subversion Repositories computer_asset_manager_v1

Rev

Rev 58 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
59 rodolico 1 
drop table if exists file;
2 
drop table if exists file_mime_type;
3 
drop view if exists client_files;
4 
drop view if exists site_files;
5 
drop view if exists device_files;
1 rodolico 6 
 
59 rodolico 7 
delete from _system where group_name = 'Files';
8 
delete from _system where key_name = 'Files';
1 rodolico 9 
 
55 rodolico 10 
delete from menu
11 
where
12 
   menu.parent_id in
13 
      ( select menu_id
14 
        from (
15 
           select distinct a.menu_id as menu_id
16 
           from menu a join menu b on a.menu_id = b.menu_id
59 rodolico 17 
           where a.caption = 'Files'
55 rodolico 18 
           )
19 
      as c );
59 rodolico 20 
delete from menu where caption = 'Files';
1 rodolico 21