| Line 28... |
Line 28... |
| 28 |
limit <count>','device_id++Device ID++++
|
28 |
limit <count>','device_id++Device ID++++
|
| 29 |
count++Number of Reports++++');
|
29 |
count++Number of Reports++++');
|
| 30 |
|
30 |
|
| 31 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Backup', 'callable.php:backupView', now() );
|
31 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Backup', 'callable.php:backupView', now() );
|
| 32 |
|
32 |
|
| 33 |
insert into _system values ( null, 'System', 'root path', '/home/rodolico/www/web/computer_asset_manager', now(), null );
|
33 |
create or replace view view_current_client_site as select concat( client.name, ' - ', ifnull(site.name,'None' )) name, client.client_id,site.site_id from client left outer join site using (client_id) where client.removed_date is null and site.removed_date is null;
|
| - |
|
34 |
create or replace view view_current_client_systems as
|
| - |
|
35 |
select
|
| - |
|
36 |
device.device_id,
|
| 34 |
insert into _system values ( null, 'System', 'root url', '/computer_asset_manager', now(), null );
|
37 |
concat(device.name, ' (', view_current_client_site.name, ')') 'Device'
|
| - |
|
38 |
from
|
| - |
|
39 |
device join view_current_client_site using (site_id)
|
| - |
|
40 |
join device_type using (device_type_id)
|
| - |
|
41 |
where
|
| - |
|
42 |
device_type.show_as_system = 'Y'
|
| - |
|
43 |
and device.removed_date is null;
|
| - |
|
44 |
|
| - |
|
45 |
create or replace view view_current_client as select name, client_id from client where removed_date is null;
|
| - |
|
46 |
|