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