You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ki...@apache.org on 2014/05/30 11:43:18 UTC
[3/4] git commit: updated refs/heads/master to bdde533
FIXED CLOUDSTACK-6808 Need to add Database Information to Alter table statements in a commit to schema-430to440.sql
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/dbd05e3f
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/dbd05e3f
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/dbd05e3f
Branch: refs/heads/master
Commit: dbd05e3ff5015a867652d805b08965851608e577
Parents: 7c2b1de
Author: Rajani Karuturi <ra...@gmail.com>
Authored: Fri May 30 11:47:17 2014 +0530
Committer: Kishan Kavala <ki...@cloud.com>
Committed: Fri May 30 15:02:18 2014 +0530
----------------------------------------------------------------------
setup/db/db/schema-430to440.sql | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/dbd05e3f/setup/db/db/schema-430to440.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-430to440.sql b/setup/db/db/schema-430to440.sql
index 2262608..7cd01d7 100644
--- a/setup/db/db/schema-430to440.sql
+++ b/setup/db/db/schema-430to440.sql
@@ -1677,11 +1677,11 @@ ALTER TABLE `cloud`.`load_balancer_healthcheck_policies` ADD COLUMN `display` ti
ALTER TABLE `cloud`.`load_balancer_stickiness_policies` ADD COLUMN `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the policy can be displayed to the end user';
-alter table user_ip_address add column removed datetime DEFAULT NULL COMMENT 'date removed';
-alter table user_ip_address add column created datetime NULL COMMENT 'date created';
+alter table `cloud`.`user_ip_address` add column removed datetime DEFAULT NULL COMMENT 'date removed';
+alter table `cloud`.`user_ip_address` add column created datetime NULL COMMENT 'date created';
-alter table vlan add column removed datetime DEFAULT NULL COMMENT 'date removed';
-alter table vlan add column created datetime NULL COMMENT 'date created';
+alter table `cloud`.`vlan` add column removed datetime DEFAULT NULL COMMENT 'date removed';
+alter table `cloud`.`vlan` add column created datetime NULL COMMENT 'date created';
-alter table user_ip_address drop key public_ip_address;
-alter table user_ip_address add UNIQUE KEY public_ip_address (public_ip_address,source_network_id, removed);
\ No newline at end of file
+alter table `cloud`.`user_ip_address` drop key public_ip_address;
+alter table `cloud`.`user_ip_address` add UNIQUE KEY public_ip_address (public_ip_address,source_network_id, removed);