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

["Chandan Purushothama (JIRA)" <ji...@apache.org>]

Chandan Purushothama created CLOUDSTACK-6808:
------------------------------------------------

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