Updated Branches: refs/heads/4.2 13d44fd7a -> cf220dd63
CLOUDSTACK-3647: Remove duplicate row Reviewed-by: Alena Prokharchyk Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/cf220dd6 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/cf220dd6 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/cf220dd6 Branch: refs/heads/4.2 Commit: cf220dd6332132aeb7eda98665b219735aca422d Parents: 13d44fd Author: Amogh Vasekar <amoghvase...@amoghs.citrite.net> Authored: Fri Aug 2 15:39:45 2013 -0700 Committer: Alena Prokharchyk <alena.prokharc...@citrix.com> Committed: Fri Aug 2 16:08:58 2013 -0700 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 6 ++++++ 1 file changed, 6 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/cf220dd6/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index 3ea6319..2f0f25c 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -289,6 +289,12 @@ INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALU INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (167, UUID(), 6, 'Windows Server 2012 (64-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (168, UUID(), 6, 'Windows Server 8 (64-bit)'); +# clean up row added in 3.0.6. +UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 166 where guest_os_id = 206; +UPDATE `cloud`.`vm_template` set guest_os_id = 166 where guest_os_id = 206; +UPDATE `cloud`.`vm_instance` set guest_os_id = 166 where guest_os_id = 206; +DELETE IGNORE FROM `cloud`.`guest_os` where id=206; + INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (169, UUID(), 10, 'Ubuntu 11.04 (32-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (170, UUID(), 10, 'Ubuntu 11.04 (64-bit)'); INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (171, UUID(), 1, 'CentOS 6.3 (32-bit)');
