Subversion Repositories computer_asset_manager_v1

Rev

Rev 58 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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