| Line 63... |
Line 63... |
| 63 |
|
63 |
|
| 64 |
/* do this only for upgrades */
|
64 |
/* do this only for upgrades */
|
| 65 |
insert into attrib (attrib_id,name,added_date,removed_date,keyname) select * from temp;
|
65 |
insert into attrib (attrib_id,name,added_date,removed_date,keyname) select * from temp;
|
| 66 |
insert into attrib_device select device_attrib_id,device_id,attrib_id,value,added_date,removed_date from device_attrib;
|
66 |
insert into attrib_device select device_attrib_id,device_id,attrib_id,value,added_date,removed_date from device_attrib;
|
| 67 |
|
67 |
|
| 68 |
update attrib set multiples = '1' where name in ( 'Alias','MAC Address','Mass Storage','Memory','Note' );
|
68 |
update attrib set multiples = '1' where name in ( 'Alias','MAC Address','Mass Storage','Memory','Note', 'Power Supply' );
|
| 69 |
|
69 |
|
| 70 |
drop table temp;
|
70 |
drop table temp;
|
| 71 |
drop table device_attrib;
|
71 |
drop table device_attrib;
|
| 72 |
|
72 |
|
| 73 |
update attrib set name = 'Memory Total' where name = 'Memory';
|
- |
|
| 74 |
update attrib set name = 'CPU Count' where name = 'Number of CPUs';
|
- |
|
| 75 |
update attrib set name = 'CPU Family' where name = 'CPU Type';
|
- |
|
| 76 |
update attrib set name = 'CPU Cores' where name = 'Cores per CPU';
|
73 |
update attrib set name = 'CPU Cores' where name = 'Cores per CPU';
|
| 77 |
update attrib set name = 'CPU Version' where name = 'CPU SubType';
|
- |
|
| 78 |
|
74 |
|
| 79 |
update attrib set name = 'Firmware Revision' where name = 'Boot ROM Version';
|
75 |
update attrib set name = 'Firmware Revision' where name = 'Boot ROM Version';
|
| 80 |
update report set screen_report = null where name in ( 'Device Attributes', 'Device PCI' );
|
76 |
update report set screen_report = null where name in ( 'Device Attributes', 'Device PCI' );
|
| 81 |
|
77 |
|
| 82 |
update attrib_device set attrib_id = 5 where attrib_id = 45;
|
78 |
update attrib_device set attrib_id = 5 where attrib_id = 45;
|