fix error data local ps systemUsedCapacity
@@ -424,3 +424,8 @@ ALTER TABLE `zstack`.`ImageEO` ADD COLUMN exportMd5Sum varchar(255) DEFAULT NULL
ALTER VIEW `zstack`.`ImageVO` AS SELECT uuid, name, description, status, state, size, actualSize, md5Sum, exportMd5Sum, platform, type, format, url, system, mediaType, createDate, lastOpDate, guestOsType, exportUrl FROM `zstack`.`ImageEO` WHERE deleted IS NULL;
ALTER TABLE HostCapacityVO MODIFY availableCpu bigint(20) NOT NULL COMMENT 'used cpu of host in HZ';
+
+UPDATE PrimaryStorageCapacityVO t0,
+(SELECT SUM(systemUsedCapacity) ps_systemUsedCapacity , primaryStorageUuid FROM LocalStorageHostRefVO GROUP BY primaryStorageUuid) t1
+SET t0.systemUsedCapacity = t1.ps_systemUsedCapacity
+WHERE t0.uuid = t1.primaryStorageUuid;
\ No newline at end of file
