PaulAngus commented on a change in pull request #3549: add detailed hypervisor 
and guest OS data
URL: https://github.com/apache/cloudstack/pull/3549#discussion_r313830553
 
 

 ##########
 File path: engine/schema/src/main/resources/META-INF/db/schema-41200to41300.sql
 ##########
 @@ -19,18 +19,154 @@
 -- Schema upgrade from 4.12.0.0 to 4.13.0.0
 --;
 
--- Add support for VMware 6.7
-INSERT IGNORE INTO `cloud`.`hypervisor_capabilities` (uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, security_group_enabled, 
max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, 
vm_snapshot_enabled) values (UUID(), 'VMware', '6.7', 128, 0, 13, 32, 1, 1);
+-- Add XenServer 7.1.2, 7.6 and 8.0 hypervisor capabilities
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, max_data_volumes_limit, 
max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', 
'7.6.0', 1000, 253, 64, 1);
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, max_data_volumes_limit, 
max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', 
'8.0.0', 1000, 253, 64, 1);
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, max_data_volumes_limit, 
max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', 
'7.1.1', 1000, 253, 64, 1);
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, max_data_volumes_limit, 
max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', 
'7.1.2', 1000, 253, 64, 1);
+
+-- Add VMware 6.7 hypervisor capabilities
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, 
hypervisor_version, max_guests_limit, security_group_enabled, 
max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, 
vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7', '1024', '0', '59', '64', 
'1', '1');
+
+-- Update VMware 6.x hypervisor capabilities
+UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', 
max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE 
(hypervisor_type='VMware' AND hypervisor_version='6.0' );
+UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', 
max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE 
(hypervisor_type='VMware' AND hypervisor_version='6.5' );
+
+
+-- Add new OS versions
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('277', UUID(), '1', 'Ubuntu 17.04', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('278', UUID(), '1', 'Ubuntu 17.10', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('279', UUID(), '1', 'Ubuntu 18.04 LTS', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('280', UUID(), '1', 'Ubuntu 18.10', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('281', UUID(), '1', 'Ubuntu 19.04', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('282', UUID(), '1', 'Red Hat Enterprise Linux 7.3', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('283', UUID(), '1', 'Red Hat Enterprise Linux 7.4', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('284', UUID(), '1', 'Red Hat Enterprise Linux 7.5', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('285', UUID(), '1', 'Red Hat Enterprise Linux 7.6', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('286', UUID(), '1', 'Red Hat Enterprise Linux 8.0', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('288', UUID(), '6', 'Windows Server 2019 (64-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('289', UUID(), '2', 'Debian GNU/Linux 9 (32-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('290', UUID(), '2', 'Debian GNU/Linux 9 (64-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('291', UUID(), '5', 'SUSE Linux Enterprise Server 15 
(64-bit)', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('292', UUID(), '2', 'Debian GNU/Linux 10 (32-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('293', UUID(), '2', 'Debian GNU/Linux 10 (64-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('294', UUID(), '2', 'Linux 4.x Kernel (32-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('295', UUID(), '2', 'Linux 4.x Kernel (64-bit)', 
now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('296', UUID(), '3', 'Oracle Linux 8', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('297', UUID(), '1', 'CentOS 8', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('298', UUID(), '9', 'FreeBSD 11 (32-bit)', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('299', UUID(), '9', 'FreeBSD 11 (64-bit)', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('300', UUID(), '9', 'FreeBSD 12 (32-bit)', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('301', UUID(), '9', 'FreeBSD 12 (64-bit)', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('302', UUID(), '1', 'CentOS 6.8', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('303', UUID(), '1', 'CentOS 6.9', now(), '0');
+INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, 
is_user_defined) VALUES ('304', UUID(), '1', 'CentOS 6.10', now(), '0');
 
 Review comment:
   276 was last ID in 4.12 release.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to