[jira] [Updated] (CLOUDSTACK-6808) Need to add Database Information to Alter table statements in a commit to schema-430to440.sql

["Rajani Karuturi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-6808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajani Karuturi updated CLOUDSTACK-6808:
----------------------------------------

    Priority: Critical  (was: Major)

> 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
>            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)