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)
