You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by pe...@apache.org on 2023/08/24 13:56:39 UTC
[cloudstack] 02/02: update db
This is an automated email from the ASF dual-hosted git repository.
pearl11594 pushed a commit to branch nsx-integration
in repository https://gitbox.apache.org/repos/asf/cloudstack.git
commit bb9b6441a238d94b70deb1f6fe727d7da9f1798f
Author: Pearl Dsilva <pe...@gmail.com>
AuthorDate: Thu Aug 24 09:56:24 2023 -0400
update db
---
.../schema/src/main/resources/META-INF/db/schema-41810to41900.sql | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
index 1ed82472402..db744dca0d8 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
@@ -186,13 +186,15 @@ CREATE TABLE `cloud`.`nsx_providers` (
`uuid` varchar(40),
`zone_id` bigint unsigned NOT NULL COMMENT 'Zone ID',
`provider_name` varchar(40),
- `hostname` varchar(255) NOT NULL ,
- `username` varchar(255) NOT NULL ,
+ `hostname` varchar(255) NOT NULL,
+ `port` varchar(255),
+ `username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`tier0_gateway` varchar(255),
`edge_cluster` varchar(255),
PRIMARY KEY (`id`),
- CONSTRAINT `fk_nsx_providers_zone_id` FOREIGN KEY (`zone_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE
+ CONSTRAINT `fk_nsx_providers__zone_id` FOREIGN KEY `fk_nsx_providers__zone_id` (`zone_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE,
+ INDEX `i_nsx_providers__zone_id`(`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;