cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wid...@apache.org
Subject [42/50] [abbrv] git commit: updated refs/heads/disk-cache to 99d67cb
Date Mon, 02 Sep 2013 20:05:28 GMT
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/93247648
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/93247648
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/93247648

Branch: refs/heads/disk-cache
Commit: 932476488bd425300cf0474de99b1f710b06c85f
Parents: 3e5a84a
Author: Amogh Vasekar <amoghvasekar@amoghs.citrite.net>
Authored: Fri Aug 2 15:39:45 2013 -0700
Committer: Alena Prokharchyk <alena.prokharchyk@citrix.com>
Committed: Fri Aug 2 16:09:13 2013 -0700

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql | 6 ++++++
 1 file changed, 6 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/93247648/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index b2fe2ed..0f98693 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -284,6 +284,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)');


Mime
View raw message