DaanHoogland commented on a change in pull request #5588:
URL: https://github.com/apache/cloudstack/pull/5588#discussion_r736462732
##########
File path: engine/schema/src/main/resources/META-INF/db/schema-41520to41600.sql
##########
@@ -807,3 +807,21 @@ ALTER TABLE `cloud_usage`.`user_statistics` DROP INDEX
`account_id`, ADD UNIQUE
ALTER TABLE `cloud`.`vm_work_job` ADD COLUMN `secondary_object` char(100)
COMMENT 'any additional item that must be checked during queueing' AFTER
`vm_instance_id`;
ALTER TABLE cloud.vm_work_job ADD CONSTRAINT vm_work_job_step_and_objects
UNIQUE KEY (step,vm_instance_id,secondary_object);
+
+CREATE TABLE `cloud`.`mshost_status` (
+ `id` bigint unsigned NOT NULL auto_increment COMMENT 'id',
+ `ms_id` varchar(40) DEFAULT NULL COMMENT 'the id of the management server
record',
+ `last_start` datetime COMMENT 'the last start time for this MS',
+ `last_stop` datetime COMMENT 'the last stop time for this MS',
+ `last_boot` datetime COMMENT 'the last system boot time for the host of this
MS',
+ `last_down` datetime COMMENT 'the last system shutdown time for the host of
this MS',
+ `os_name` varchar(64) DEFAULT null COMMENT 'the name of the os type running
on the host of this MS',
+ `os_version` varchar(64) DEFAULT null COMMENT 'the version of the os running
on the host of this MS',
+ `java_name` varchar(64) DEFAULT null COMMENT 'the name of the java
distribution running this MS',
+ `java_version` varchar(64) DEFAULT null COMMENT 'the version of the java
distribution running this MS',
+ `updated` datetime DEFAULT NULL,
+ `created` datetime DEFAULT NULL,
+ `removed` datetime DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ CONSTRAINT `uc_ms_id` UNIQUE (`ms_id`)
Review comment:
The UUID is also used in referring inline. I trust the UUID more and
also it is the one that needs to be returned. I see no advantage in using the
ID.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
