Versions Compared

Old Version 5

changes.mady.by.user Amogh Vasekar

Saved on

compared with

New Version 6

changes.mady.by.user Amogh Vasekar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • GUEST_OS_HYPERVISOR table that stores the mappings:

 

Code Block
ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `hypervisor_version` varchar(32) NOT NULL DEFAULT 'default' COMMENT 'Hypervisor version for this mapping';

...


ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `uuid` varchar(40) COMMENT 'UUID of the mapping';

...


ALTER TABLE `cloud`.`guest_os_hypervisor` ADD CONSTRAINT `uc_guest_os_hypervisor__uuid` UNIQUE (`uuid`);

...


ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `created` datetime COMMENT 'Time when mapping was created';

...


ALTER TABLE `cloud`.`guest_os_hypervisor` ADD COLUMN `removed` datetime COMMENT 'Time when mapping was removed if deleted, else NULL';

...


UPDATE `cloud`.`guest_os_hypervisor` SET `uuid` = UUID();

...


UPDATE `cloud`.`guest_os_hypervisor` SET `created` = now();

 

  • GUEST_OS table changes :

Code Block
ALTER TABLE `cloud`.`guest_os` ADD COLUMN `created` datetime COMMENT 'Time when Guest OS was created in system';

...


ALTER TABLE `cloud`.`guest_os` ADD COLUMN `removed` datetime COMMENT 'Time when Guest OS was removed if deleted, else NULL';

...


UPDATE `cloud`.`guest_os` SET `created` = now();

 

The ResourceBase / OsMapper files will load the mappings from DB, via the respective Gurus.

...