You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by bh...@apache.org on 2014/11/06 16:03:11 UTC
git commit: updated refs/heads/4.5 to fda4b9b
Repository: cloudstack
Updated Branches:
refs/heads/4.5 f5c3a71ef -> fda4b9ba2
CLOUDSTACK-7854: Don't remove vm_template row for centos 5.5, mark as removed
Signed-off-by: Rohit Yadav <ro...@shapeblue.com>
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/fda4b9ba
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/fda4b9ba
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/fda4b9ba
Branch: refs/heads/4.5
Commit: fda4b9ba2c2884960d5709952233a5551e900ebd
Parents: f5c3a71
Author: Rohit Yadav <ro...@shapeblue.com>
Authored: Thu Nov 6 20:32:03 2014 +0530
Committer: Rohit Yadav <ro...@shapeblue.com>
Committed: Thu Nov 6 20:32:47 2014 +0530
----------------------------------------------------------------------
setup/db/db/schema-441to450.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/fda4b9ba/setup/db/db/schema-441to450.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-441to450.sql b/setup/db/db/schema-441to450.sql
index 7f60f85..1d2bbb6 100644
--- a/setup/db/db/schema-441to450.sql
+++ b/setup/db/db/schema-441to450.sql
@@ -752,5 +752,5 @@ INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hype
--Remove duplicates from guest_os_hypervisor table
DELETE t1 FROM guest_os_hypervisor t1, guest_os_hypervisor t2 WHERE (t1.hypervisor_type = t2.hypervisor_type AND t1.hypervisor_version = t2.hypervisor_version AND t1.guest_os_id = t2.guest_os_id AND t1.id > t2.id AND t1.is_user_defined=0);
--- Delete redundant built-in CentOS 5.3 template (if any) for XenServer, since CentOS 5.6 template already exists
-DELETE FROM `cloud`.`vm_template` WHERE unique_name="centos53-x86_64" AND hypervisor_type="XenServer";
+-- Set as removed built-in CentOS 5.3 template (if any) for XenServer, since CentOS 5.6 template already exists
+UPDATE `cloud`.`vm_template` SET removed=NOW() WHERE unique_name="centos53-x86_64" AND hypervisor_type="XenServer";