Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 1 Rev 49
Line 54... Line 54...
54 
alter table maintenance_schedule add index (login_id);
 54 
alter table maintenance_schedule add index (login_id);
55 
alter table maintenance_schedule add index (device_id);
 55 
alter table maintenance_schedule add index (device_id);
56 
alter table maintenance_schedule add index (maintenance_task_id);
 56 
alter table maintenance_schedule add index (maintenance_task_id);
57 
 
 57 
 
58 
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Maintenance', 'modules/maintenance/', now() );
 58 
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Maintenance', 'modules/maintenance/', now() );
- 
 
 59 
/* add maintenance report */
- 
 
 60 
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Maintenance', 'callable.php:maintenanceView', now() );
59 
 
 61 
 
60 
insert into menu( url, caption, parent_id) values ('', 'Maintenance', null);
 62 
insert into menu( url, caption, parent_id) values ('', 'Maintenance', null);
61 
insert into menu( url,caption,parent_id) select '/modules/maintenance/do_maintenance.html','Scheduled Maintenance',menu_id from menu where caption = 'Maintenance';
 63 
insert into menu( url,caption,parent_id) select '/modules/maintenance/do_maintenance.html','Scheduled Maintenance',menu_id from menu where caption = 'Maintenance';
62 
insert into menu( url,caption,parent_id) select '/modules/maintenance/unscheduled_maintenance.html','Unscheduled Maintenance',menu_id from menu where caption = 'Maintenance';
 64 
insert into menu( url,caption,parent_id) select '/modules/maintenance/unscheduled_maintenance.html','Unscheduled Maintenance',menu_id from menu where caption = 'Maintenance';
63 
insert into menu( url,caption,parent_id) select '/modules/maintenance/edit_schedule.html','Edit Schedules',menu_id from menu where caption = 'Maintenance';
 65 
insert into menu( url,caption,parent_id) select '/modules/maintenance/edit_schedule.html','Edit Schedules',menu_id from menu where caption = 'Maintenance';