sureshanaparti commented on a change in pull request #5588:
URL: https://github.com/apache/cloudstack/pull/5588#discussion_r737373039
##########
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:
agree. most of the db columns, which are referencing a column in the
other table through a unique identifier, are referenced through 'id' (not
'uuid').
--
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]
