Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 49 Rev 50
Line 1... Line 1...
1 
drop table if exists license;
 1 
drop table if exists license;
2 
drop table if exists license_product;
 2 
drop table if exists license_product;
3 
delete from _system where key_name = 'license';
 3 
delete from _system where key_name = 'License';
4 
delete from menu
4 
delete from menu
5 
where
5 
where
6 
   menu.parent_id in
6 
   menu.parent_id in
7 
      ( select menu_id
7 
      ( select menu_id
8 
        from (
8 
        from (
Line 11... Line 11...
11 
           where a.caption = 'Licenses'
11 
           where a.caption = 'Licenses'
12 
           )
12 
           )
13 
      as c );
 13 
      as c );
14 
delete from menu where caption = 'Licenses';
 14 
delete from menu where caption = 'Licenses';
15 
 
 15 
 
16 
create or replace view view_device_systems as select * from device where device_type_id in (select device_type_id from device_type where show_as_system = 'Y');
 - 
 
17 
 
 -