| Line 3... |
Line 3... |
| 3 |
update report set screen_report = null where name = 'Sysinfo Reports';
|
3 |
update report set screen_report = null where name = 'Sysinfo Reports';
|
| 4 |
/* this is a cleanup, and should be in the main function. It creates a view which shows only devices which are systems */
|
4 |
/* this is a cleanup, and should be in the main function. It creates a view which shows only devices which are systems */
|
| 5 |
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');
|
5 |
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');
|
| 6 |
/* add maintenance report */
|
6 |
/* add maintenance report */
|
| 7 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Maintenance', 'callable.php:maintenanceView', now() );
|
7 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Maintenance', 'callable.php:maintenanceView', now() );
|
| - |
|
8 |
/* Don't really want this, but some code depends on it. Should really use session var */
|
| - |
|
9 |
insert into _system values ( null,'System','root url', '/computer_asset_manager', now(), null );
|
| 8 |
|
10 |
|
| 9 |
delete from report where name = 'New Report';
|
11 |
delete from report where name = 'New Report';
|
| 10 |
insert into report ( name, query, parameters ) values ('Backup History','select
|
12 |
insert into report ( name, query, parameters ) values ('Backup History','select
|
| 11 |
backups_run.start_time Started,
|
13 |
backups_run.start_time Started,
|
| 12 |
backups_run.end_time Ended,
|
14 |
backups_run.end_time Ended,
|