[GitHub] [inlong] lvanneo commented on a diff in pull request #7665: [INLONG-7658][Manager] Optimized table index

["lvanneo (via GitHub)" <gi...@apache.org>]

lvanneo commented on code in PR #7665:
URL: https://github.com/apache/inlong/pull/7665#discussion_r1148738371


##########
inlong-manager/manager-web/sql/apache_inlong_manager.sql:
##########
@@ -75,8 +75,7 @@ CREATE TABLE IF NOT EXISTS `inlong_group_ext`
     `is_deleted`      int(11)           DEFAULT '0' COMMENT 'Whether to delete, 0: not deleted, > 0: deleted',
     `modify_time`     timestamp    NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modify time',
     PRIMARY KEY (`id`),
-    UNIQUE KEY `unique_inlong_group_key` (`inlong_group_id`, `key_name`),
-    INDEX `group_ext_group_index` (`inlong_group_id`)
+    UNIQUE KEY `unique_inlong_group_key` (`inlong_group_id`, `key_name`)

Review Comment:
   > Please change the `manager-test/src/main/resources/h2/apache_inlong_manager.sql` at the same time, thanks.
   
   ok



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org