You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by re...@apache.org on 2015/12/28 11:22:39 UTC
[15/16] git commit: updated refs/heads/master to 67b753c
CLOUDSTACK-9074: Move sql to 4.8.0 schema
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/de23c94f
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/de23c94f
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/de23c94f
Branch: refs/heads/master
Commit: de23c94f33c51cb3c72ceb801e86f3888cfb8604
Parents: 0b20ed4
Author: nvazquez <ni...@gmail.com>
Authored: Thu Dec 24 16:12:01 2015 -0300
Committer: nvazquez <ni...@gmail.com>
Committed: Thu Dec 24 16:12:01 2015 -0300
----------------------------------------------------------------------
setup/db/db/schema-461to470.sql | 1 -
setup/db/db/schema-471to480.sql | 2 ++
2 files changed, 2 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/de23c94f/setup/db/db/schema-461to470.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-461to470.sql b/setup/db/db/schema-461to470.sql
index 7cc249c..7c70199 100644
--- a/setup/db/db/schema-461to470.sql
+++ b/setup/db/db/schema-461to470.sql
@@ -251,4 +251,3 @@ INSERT IGNORE INTO `cloud`.`hypervisor_capabilities` values (25,UUID(),'VMware',
INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(),'VMware', '5.5', 'rhel7_64Guest', 245, utc_timestamp(), 0);
INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'VMware', '6.0', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='VMware' AND hypervisor_version='5.5' AND (guest_os_id NOT IN (1,2,3,4,62,63,64,65,156,157,221,222) AND guest_os_id NOT BETWEEN 121 AND 130);
-ALTER TABLE `cloud`.`nicira_nvp_router_map` DROP INDEX `logicalrouter_uuid` ;
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/de23c94f/setup/db/db/schema-471to480.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-471to480.sql b/setup/db/db/schema-471to480.sql
index fea0017..58cca38 100644
--- a/setup/db/db/schema-471to480.sql
+++ b/setup/db/db/schema-471to480.sql
@@ -18,3 +18,5 @@
--;
-- Schema upgrade from 4.7.1 to 4.8.0;
--;
+
+ALTER TABLE `cloud`.`nicira_nvp_router_map` DROP INDEX `logicalrouter_uuid` ;