cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From weiz...@apache.org
Subject git commit: updated refs/heads/master to 5c23adf
Date Tue, 06 Aug 2013 12:45:21 GMT
Updated Branches:
  refs/heads/master 1a89bc06c -> 5c23adfff


CLOUDSTACK-4110: update user_ip_address.dnat_vmip field in 410to420 upgrade
(cherry picked from commit fa094a5d2c9e0274c3dd9c10e3c5ed4df81b67bc)


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/5c23adff
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/5c23adff
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/5c23adff

Branch: refs/heads/master
Commit: 5c23adfff2f103f419dbeedd04e895d2d835d4c8
Parents: 1a89bc0
Author: Wei Zhou <w.zhou@leaseweb.com>
Authored: Tue Aug 6 14:44:15 2013 +0200
Committer: Wei Zhou <w.zhou@leaseweb.com>
Committed: Tue Aug 6 14:45:14 2013 +0200

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


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/5c23adff/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 1ca9d64..797a931 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -423,6 +423,8 @@ CREATE TABLE nic_secondary_ips (
 
 ALTER TABLE `cloud`.`nics` ADD COLUMN secondary_ip SMALLINT DEFAULT '0' COMMENT 'secondary
ips configured for the nic';
 ALTER TABLE `cloud`.`user_ip_address` ADD COLUMN dnat_vmip VARCHAR(40);
+UPDATE `cloud`.`user_ip_address`,`cloud`.`nics` SET `user_ip_address`.`dnat_vmip` = `nics`.`ip4_address`
+      WHERE `user_ip_address`.`vm_id` = `nics`.`instance_id` AND `user_ip_address`.`network_id`
= `nics`.`network_id` AND `user_ip_address`.`one_to_one_nat` = 1;
 
 ALTER TABLE `cloud`.`alert` ADD COLUMN `archived` tinyint(1) unsigned NOT NULL DEFAULT 0;
 ALTER TABLE `cloud`.`event` ADD COLUMN `archived` tinyint(1) unsigned NOT NULL DEFAULT 0;


Mime
View raw message