Updated Branches: refs/heads/master 61b787975 -> d9d7cbd5b
CLOUDSTACK-4268: Guest OS category of Other Ubuntu 32 bit is different in a fresh setup and a setup upgraded from 4.1 to 4.2. Fixed the category id for Ubuntu on clean setup. Also made change to address the problem for upgrade from 2.x. Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/d9d7cbd5 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/d9d7cbd5 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/d9d7cbd5 Branch: refs/heads/master Commit: d9d7cbd5b453103944dc7dce55e8d840dafba599 Parents: 61b7879 Author: Devdeep Singh <[email protected]> Authored: Tue Aug 13 15:30:36 2013 +0530 Committer: Devdeep Singh <[email protected]> Committed: Tue Aug 13 15:36:55 2013 +0530 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 1 + setup/db/templates.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/d9d7cbd5/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index 50a2e90..ec4d472 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -287,6 +287,7 @@ CREATE TABLE `cloud`.`load_balancer_healthcheck_policies` ( INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'vm.instancename.flag', 'false', 'Append guest VM display Name (if set) to the internal name of the VM'); +UPDATE `cloud`.`guest_os` SET category_id=10 where id=59; INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (165, UUID(), 6, 'Windows 8 (32-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (166, UUID(), 6, 'Windows 8 (64-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (167, UUID(), 6, 'Windows Server 2012 (64-bit)'); http://git-wip-us.apache.org/repos/asf/cloudstack/blob/d9d7cbd5/setup/db/templates.sql ---------------------------------------------------------------------- diff --git a/setup/db/templates.sql b/setup/db/templates.sql index 5bc2f67..e030852 100755 --- a/setup/db/templates.sql +++ b/setup/db/templates.sql @@ -109,7 +109,7 @@ INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (55, INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (56, UUID(), 6, 'Windows Vista (32-bit)'); INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (57, UUID(), 6, 'Windows XP SP2 (32-bit)'); INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (58, UUID(), 6, 'Windows XP SP3 (32-bit)'); -INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (59, UUID(), 7, 'Other Ubuntu (32-bit)'); +INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (59, UUID(), 10, 'Other Ubuntu (32-bit)'); INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (60, UUID(), 7, 'Other (32-bit)'); INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (61, UUID(), 6, 'Windows 2000 Server'); INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (62, UUID(), 6, 'Windows 98');
