Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 46 Rev 47
Line 30... Line 30...
30 
           )
30 
           )
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/edit_license_product.html','Edit Products',menu_id from menu where caption = 'Licenses';
36 
 
 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');
 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