Subversion Repositories computer_asset_manager_v1

Rev

Rev 45 | Rev 47 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 45 Rev 46
Line 31... Line 31...
31 
      as c );
 31 
      as c );
32 
delete from menu where caption = 'Licenses';
 32 
delete from menu where caption = 'Licenses';
33 
insert into menu( url, caption, parent_id) values ('/modules/license/', 'Licenses', null);
 33 
insert into menu( url, caption, parent_id) values ('/modules/license/', 'Licenses', null);
34 
insert into menu( url,caption,parent_id) select '/modules/license/bulk_load.html','Bulk Load',menu_id from menu where caption = 'Licenses';
 34 
insert into menu( url,caption,parent_id) select '/modules/license/bulk_load.html','Bulk Load',menu_id from menu where caption = 'Licenses';
35 
insert into menu( url,caption,parent_id) select '/modules/license/add_edit.html','Edit',menu_id from menu where caption = 'Licenses';
 35 
insert into menu( url,caption,parent_id) select '/modules/license/add_edit.html','Edit',menu_id from menu where caption = 'Licenses';
36 
insert into menu( url,caption,parent_id) select '/modules/license/find.html','Find',menu_id from menu where caption = 'Licenses';
 - 
 
37 
 
 36 
 
- 
 
 37 
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');
38 
 
 38 
 
39 
/* DO NOT RUN BELOW THIS LINE */
 39 
/* DO NOT RUN BELOW THIS LINE */
40 
 
 40 
 
41 
select
41 
select
42 
   license_product.name 'Product',
 42 
   license_product.name 'Product',