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 <rajanikarut...@gmail.com> Authored: Fri May 30 11:47:17 2014 +0530 Committer: Kishan Kavala <kis...@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);
