Subversion Repositories computer_asset_manager_v1

drop table if exists license;
drop table if exists license_product;
delete from _system where key_name = 'license';
delete from menu 
where 
   menu.parent_id in 
      ( select menu_id 
        from ( 
           select distinct a.menu_id as menu_id 
           from menu a join menu b on a.menu_id = b.menu_id 
           where a.caption = 'Licenses' 
           ) 
      as c );
delete from menu where caption = 'Licenses';

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');