[
https://issues.apache.org/jira/browse/CLOUDSTACK-6808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajani Karuturi resolved CLOUDSTACK-6808.
-----------------------------------------
Resolution: Fixed
> Need to add Database Information to Alter table statements in a commit to
> schema-430to440.sql
> ----------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-6808
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6808
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Management Server
> Affects Versions: 4.4.0
> Reporter: Chandan Purushothama
> Assignee: Rajani Karuturi
> Priority: Critical
> Fix For: 4.4.0
>
>
> Database Information is missing in the commit shown below
> diff --git a/setup/db/db/schema-430to440.sql b/setup/db/db/schema-430to440.sql
> index 3b525c4..2262608 100644 (file)
> --- a/setup/db/db/schema-430to440.sql
> +++ b/setup/db/db/schema-430to440.sql
> @@ -1676,3 +1676,12 @@ CREATE TABLE `cloud`.`network_acl_item_cidrs` (
> ALTER TABLE `cloud`.`load_balancer_healthcheck_policies` ADD COLUMN `display`
> tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the policy can be displayed
> to the end user';
> 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 vlan add column removed datetime DEFAULT NULL COMMENT 'date
> removed';
> +alter table 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)
