[cloudstack] 02/02: update db

[pearl11594]

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 <pearl1...@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;