cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajani Karuturi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-6808) Need to add Database Information to Alter table statements in a commit to schema-430to440.sql
Date Fri, 30 May 2014 06:44:01 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-6808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14013358#comment-14013358
] 

Rajani Karuturi commented on CLOUDSTACK-6808:
---------------------------------------------

patch on review board https://reviews.apache.org/r/22075/

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

Mime
View raw message