This is an automated email from the ASF dual-hosted git repository.
casion pushed a commit to branch dev-1.3.2
in repository https://gitbox.apache.org/repos/asf/incubator-linkis.git
The following commit(s) were added to refs/heads/dev-1.3.2 by this push:
new f4f6ef640 [ISSUE-3978]Index optimization and dll script optimization
(#3979)
f4f6ef640 is described below
commit f4f6ef6409de075c11ff9d41d12e9333f035a399
Author: binbincheng <[email protected]>
AuthorDate: Tue Dec 20 18:53:17 2022 +0800
[ISSUE-3978]Index optimization and dll script optimization (#3979)
---
linkis-dist/package/db/linkis_ddl.sql | 95 +++++++------
.../db/upgrade/1.3.2_schema/mysql/linkis_ddl.sql | 158 ++++++++++++++++++++-
2 files changed, 210 insertions(+), 43 deletions(-)
diff --git a/linkis-dist/package/db/linkis_ddl.sql
b/linkis-dist/package/db/linkis_ddl.sql
index 4d967625f..89e95820e 100644
--- a/linkis-dist/package/db/linkis_ddl.sql
+++ b/linkis-dist/package/db/linkis_ddl.sql
@@ -15,6 +15,17 @@
* limitations under the License.
*/
+
+--Non-unique indexes are named according to "idx_fieldname[_fieldname]". For
example idx_age_name
+--The unique index is named according to "uniq_field name[_field name]". For
example uniq_age_name
+--It is recommended to include all field names for composite indexes, and the
long field names can be abbreviated. For example idx_age_name_add
+--The index name should not exceed 50 characters, and the name should be
lowercase
+--
+--非唯一索引按照“idx_字段名称[_字段名称]”进用行命名。例如idx_age_name
+--唯一索引按照“uniq_字段名称[_字段名称]”进用行命名。例如uniq_age_name
+--组合索引建议包含所有字段名,过长的字段名可以采用缩写形式。例如idx_age_name_add
+--索引名尽量不超过50个字符，命名应该使用小写
+
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `linkis_ps_configuration_config_key`;
@@ -31,7 +42,7 @@ CREATE TABLE `linkis_ps_configuration_config_key`(
`is_advanced` tinyint(1) DEFAULT NULL COMMENT 'Whether it is an advanced
parameter. If set to 1(true), parameters would be displayed only when user
choose to do so',
`level` tinyint(1) DEFAULT NULL COMMENT 'Basis for displaying sorting in the
front-end. Higher the level is, higher the rank the parameter gets',
`treeName` varchar(20) DEFAULT NULL COMMENT 'Reserved field, representing
the subdirectory of engineType',
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -41,12 +52,12 @@ CREATE TABLE `linkis_ps_configuration_key_engine_relation`(
`config_key_id` bigint(20) NOT NULL COMMENT 'config key id',
`engine_type_label_id` bigint(20) NOT NULL COMMENT 'engine label id',
PRIMARY KEY (`id`),
- UNIQUE INDEX(`config_key_id`, `engine_type_label_id`)
+ UNIQUE INDEX `uniq_kid_lid` (`config_key_id`, `engine_type_label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_ps_configuration_config_value`;
-CREATE TABLE linkis_ps_configuration_config_value(
+CREATE TABLE `linkis_ps_configuration_config_value`(
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`config_key_id` bigint(20),
`config_value` varchar(200),
@@ -54,7 +65,7 @@ CREATE TABLE linkis_ps_configuration_config_value(
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE INDEX(`config_key_id`, `config_label_id`)
+ UNIQUE INDEX `uniq_kid_lid` (`config_key_id`, `config_label_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_ps_configuration_category`;
@@ -67,7 +78,7 @@ CREATE TABLE `linkis_ps_configuration_category` (
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE INDEX(`label_id`)
+ UNIQUE INDEX `uniq_label_id` (`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
@@ -96,8 +107,8 @@ CREATE TABLE `linkis_ps_job_history_group_history` (
`execution_code` text DEFAULT NULL COMMENT 'Job origin code or code path',
`result_location` varchar(500) DEFAULT NULL COMMENT 'File path of the
resultsets',
PRIMARY KEY (`id`),
- KEY `created_time` (`created_time`),
- KEY `submit_user` (`submit_user`)
+ KEY `idx_created_time` (`created_time`),
+ KEY `idx_submit_user` (`submit_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
@@ -124,7 +135,7 @@ CREATE TABLE `linkis_ps_common_lock` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `lock_object` (`lock_object`)
+ UNIQUE KEY `uniq_lock_object` (`lock_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -237,9 +248,9 @@ CREATE TABLE `linkis_ps_variable_key_user` (
`user_name` varchar(50) DEFAULT NULL,
`value` varchar(200) DEFAULT NULL COMMENT 'Value of the global variable',
PRIMARY KEY (`id`),
- UNIQUE KEY `application_id_2` (`application_id`,`key_id`,`user_name`),
- KEY `key_id` (`key_id`),
- KEY `application_id` (`application_id`)
+ UNIQUE KEY `uniq_aid_kid_uname` (`application_id`,`key_id`,`user_name`),
+ KEY `idx_key_id` (`key_id`),
+ KEY `idx_aid` (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
@@ -257,7 +268,7 @@ CREATE TABLE `linkis_ps_variable_key` (
`value_type` varchar(50) DEFAULT NULL COMMENT 'Reserved word',
`value_regex` varchar(100) DEFAULT NULL COMMENT 'Reserved word',
PRIMARY KEY (`id`),
- KEY `application_id` (`application_id`)
+ KEY `idx_aid` (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
@@ -341,7 +352,7 @@ CREATE TABLE `linkis_ps_datasource_table` (
`is_partition_table` tinyint(1) NOT NULL,
`is_available` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `database` (`database`,`name`)
+ UNIQUE KEY `uniq_db_name` (`database`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
@@ -381,8 +392,8 @@ CREATE TABLE `linkis_ps_cs_context_map` (
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create
time',
`access_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'last
access time',
PRIMARY KEY (`id`),
- UNIQUE KEY `key` (`key`,`context_id`,`context_type`),
- KEY `keywords` (`keywords`(191))
+ UNIQUE KEY `uniq_key_cid_ctype` (`key`,`context_id`,`context_type`),
+ KEY `idx_keywords` (`keywords`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
@@ -414,7 +425,7 @@ CREATE TABLE `linkis_ps_cs_context_history` (
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'update
unix timestamp',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create
time',
`access_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'last
access time',
- KEY `keyword` (`keyword`(191))
+ KEY `idx_keyword` (`keyword`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
@@ -434,9 +445,9 @@ CREATE TABLE `linkis_ps_cs_context_id` (
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create
time',
`access_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'last
access time',
PRIMARY KEY (`id`),
- KEY `instance` (`instance`(128)),
- KEY `backup_instance` (`backup_instance`(191)),
- KEY `instance_2` (`instance`(128),`backup_instance`(128))
+ KEY `idx_instance` (`instance`(128)),
+ KEY `idx_backup_instance` (`backup_instance`(191)),
+ KEY `idx_instance_bin` (`instance`(128),`backup_instance`(128))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
@@ -491,7 +502,7 @@ CREATE TABLE if not exists
`linkis_ps_bml_resources_version` (
`client_ip` varchar(200) NOT NULL COMMENT 'Client ip',
`updator` varchar(50) DEFAULT NULL COMMENT 'updator',
`enable_flag` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Status, 1:
normal, 0: frozen',
- unique key `resource_id_version`(`resource_id`, `version`),
+ unique key `uniq_rid_version`(`resource_id`, `version`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
@@ -559,7 +570,7 @@ create table if not exists linkis_ps_bml_project(
`creator` varchar(128) not null,
`enabled` tinyint default 1,
`create_time` datetime DEFAULT now(),
- unique key(`name`),
+ unique key `uniq_name` (`name`),
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
@@ -574,7 +585,7 @@ create table if not exists linkis_ps_bml_project_user(
`creator` varchar(128) not null,
`create_time` datetime DEFAULT now(),
`expire_time` datetime default null,
- unique key user_project(`username`, `project_id`),
+ unique key `uniq_name_pid`(`username`, `project_id`),
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
@@ -598,7 +609,7 @@ CREATE TABLE `linkis_ps_instance_label` (
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'update
unix timestamp',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'update
unix timestamp',
PRIMARY KEY (`id`),
- UNIQUE KEY `label_key_value` (`label_key`,`label_value`)
+ UNIQUE KEY `uniq_lk_lv` (`label_key`,`label_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -611,7 +622,7 @@ CREATE TABLE `linkis_ps_instance_label_value_relation` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'update unix
timestamp',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create unix
timestamp',
PRIMARY KEY (`id`),
- UNIQUE KEY `label_value_key_label_id` (`label_value_key`,`label_id`)
+ UNIQUE KEY `uniq_lvk_lid` (`label_value_key`,`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_ps_instance_label_relation`;
@@ -622,7 +633,7 @@ CREATE TABLE `linkis_ps_instance_label_relation` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'update unix
timestamp',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create unix
timestamp',
PRIMARY KEY (`id`),
- UNIQUE KEY `label_instance` (`label_id`,`service_instance`)
+ UNIQUE KEY `uniq_lid_instance` (`label_id`,`service_instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -634,7 +645,7 @@ CREATE TABLE `linkis_ps_instance_info` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'update unix
timestamp',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create unix
timestamp',
PRIMARY KEY (`id`),
- UNIQUE KEY `instance` (`instance`)
+ UNIQUE KEY `uniq_instance` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_ps_error_code`;
@@ -659,7 +670,7 @@ CREATE TABLE `linkis_cg_manager_service_instance` (
`updator` varchar(32) COLLATE utf8_bin DEFAULT NULL,
`creator` varchar(32) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `instance` (`instance`)
+ UNIQUE KEY `uniq_instance` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_manager_linkis_resources`;
@@ -720,7 +731,7 @@ CREATE TABLE `linkis_cg_manager_label` (
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `label_key_value` (`label_key`,`label_value`)
+ UNIQUE KEY `uniq_lk_lv` (`label_key`,`label_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_manager_label_value_relation`;
@@ -732,7 +743,7 @@ CREATE TABLE `linkis_cg_manager_label_value_relation` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `label_value_key_label_id` (`label_value_key`,`label_id`)
+ UNIQUE KEY `uniq_lvk_lid` (`label_value_key`,`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_manager_label_resource`;
@@ -743,7 +754,7 @@ CREATE TABLE `linkis_cg_manager_label_resource` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `label_id` (`label_id`)
+ UNIQUE KEY `uniq_label_id` (`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_ec_resource_info_record`;
@@ -766,8 +777,8 @@ CREATE TABLE `linkis_cg_ec_resource_info_record` (
`used_time` datetime DEFAULT NULL COMMENT 'used time',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create time',
PRIMARY KEY (`id`),
- KEY (`ticket_id`),
- UNIQUE KEY `label_value_ticket_id` (`ticket_id`,`label_value`)
+ KEY `idx_ticket_id` (`ticket_id`),
+ UNIQUE KEY `uniq_tid_lv` (`ticket_id`,`label_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_manager_label_service_instance`;
@@ -778,7 +789,7 @@ CREATE TABLE `linkis_cg_manager_label_service_instance` (
`update_time` datetime DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- KEY label_serviceinstance(label_id,service_instance)
+ KEY `idx_lid_instance` (`label_id`,`service_instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -857,7 +868,7 @@ CREATE TABLE `linkis_ps_dm_datasource`
`expire` tinyint(1) DEFAULT 0,
`published_version_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
- UNIQUE INDEX `datasource_name_un` (`datasource_name`)
+ UNIQUE INDEX `uniq_datasource_name` (`datasource_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
@@ -876,8 +887,8 @@ CREATE TABLE `linkis_ps_dm_datasource_env`
`modify_time` datetime NOT NULL DEFAULT
CURRENT_TIMESTAMP,
`modify_user` varchar(255) COLLATE utf8_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `env_name` (`env_name`),
- UNIQUE INDEX `env_name_datasource_type_id` (`env_name`,
`datasource_type_id`)
+ UNIQUE KEY `uniq_env_name` (`env_name`),
+ UNIQUE INDEX `uniq_name_dtid` (`env_name`, `datasource_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -895,7 +906,7 @@ CREATE TABLE `linkis_ps_dm_datasource_type`
`icon` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`layers` int(3) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE INDEX `name_un` (`name`)
+ UNIQUE INDEX `uniq_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
@@ -922,7 +933,7 @@ CREATE TABLE `linkis_ps_dm_datasource_type_key`
`update_time` datetime NOT NULL DEFAULT
CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `data_source_type_id_key` (`data_source_type_id`, `key`)
+ UNIQUE KEY `uniq_dstid_key` (`data_source_type_id`, `key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for linkis_ps_dm_datasource_version
@@ -936,7 +947,7 @@ CREATE TABLE `linkis_ps_dm_datasource_version`
`comment` varchar(255) COLLATE utf8_bin NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT
CURRENT_TIMESTAMP,
`create_user` varchar(255) COLLATE utf8_bin NULL DEFAULT NULL,
- PRIMARY KEY (`version_id`, `datasource_id`) USING BTREE
+ PRIMARY KEY `uniq_vid_did` (`version_id`, `datasource_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
@@ -954,7 +965,7 @@ CREATE TABLE `linkis_mg_gateway_auth_token` (
`elapse_day` BIGINT DEFAULT NULL,
`update_by` varchar(32),
PRIMARY KEY (`id`),
-UNIQUE KEY `token_name` (`token_name`)
+UNIQUE KEY `uniq_token_name` (`token_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -973,7 +984,7 @@ CREATE TABLE `linkis_cg_tenant_label_config` (
`desc` varchar(100) COLLATE utf8_bin NOT NULL,
`bussiness_user` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `user_creator` (`user`,`creator`)
+ UNIQUE KEY `uniq_user_creator` (`user`,`creator`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
@@ -990,5 +1001,5 @@ CREATE TABLE `linkis_cg_user_ip_config` (
`desc` varchar(100) COLLATE utf8_bin NOT NULL,
`bussiness_user` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `user_creator` (`user`,`creator`)
+ UNIQUE KEY `uniq_user_creator` (`user`,`creator`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
\ No newline at end of file
diff --git a/linkis-dist/package/db/upgrade/1.3.2_schema/mysql/linkis_ddl.sql
b/linkis-dist/package/db/upgrade/1.3.2_schema/mysql/linkis_ddl.sql
index fa32d4e5a..a5a78b243 100644
--- a/linkis-dist/package/db/upgrade/1.3.2_schema/mysql/linkis_ddl.sql
+++ b/linkis-dist/package/db/upgrade/1.3.2_schema/mysql/linkis_ddl.sql
@@ -46,4 +46,160 @@ CREATE TABLE `linkis_cg_user_ip_config` (
`bussiness_user` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_creator` (`user`,`creator`)
-) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
\ No newline at end of file
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+
+--Non-unique indexes are named according to "idx_fieldname[_fieldname]". For
example idx_age_name
+--The unique index is named according to "uniq_field name[_field name]". For
example uniq_age_name
+--It is recommended to include all field names for composite indexes, and the
long field names can be abbreviated. For example idx_age_name_add
+--The index name should not exceed 50 characters, and the name should be
lowercase
+--
+--非唯一索引按照“idx_字段名称[_字段名称]”进用行命名。例如idx_age_name
+--唯一索引按照“uniq_字段名称[_字段名称]”进用行命名。例如uniq_age_name
+--组合索引建议包含所有字段名,过长的字段名可以采用缩写形式。例如idx_age_name_add
+--索引名尽量不超过50个字符，命名应该使用小写
+
+ALTER TABLE `linkis_ps_configuration_key_engine_relation`
+ DROP INDEX IF EXISTS `config_key_id`,
+ ADD UNIQUE INDEX `uniq_kid_lid` (`config_key_id`,
`engine_type_label_id`);
+
+ALTER TABLE `linkis_ps_configuration_config_value`
+ DROP INDEX IF EXISTS `config_key_id`,
+ ADD UNIQUE INDEX `uniq_kid_lid` (`config_key_id`, `config_label_id`);
+
+ALTER TABLE `linkis_ps_configuration_category`
+ DROP INDEX IF EXISTS `label_id`,
+ ADD UNIQUE INDEX `uniq_label_id` (`label_id`);
+
+
+ALTER TABLE `linkis_ps_job_history_group_history`
+ DROP INDEX IF EXISTS `created_time`,
+ DROP INDEX IF EXISTS `submit_user`,
+ ADD KEY `idx_created_time` (`created_time`),
+ ADD KEY `idx_submit_user` (`submit_user`);
+
+ALTER TABLE `linkis_ps_common_lock`
+ DROP INDEX IF EXISTS `lock_object`,
+ ADD UNIQUE KEY `uniq_lock_object` (`lock_object`);
+
+ALTER TABLE `linkis_ps_variable_key_user`
+ DROP INDEX IF EXISTS `key_id`,
+ DROP INDEX IF EXISTS `application_id`,
+ DROP INDEX IF EXISTS `application_id_2`,
+ ADD KEY `idx_key_id` (`key_id`),
+ ADD UNIQUE KEY `uniq_aid_kid_uname`
(`application_id`,`key_id`,`user_name`),
+ ADD KEY `idx_aid` (`application_id`);
+
+ALTER TABLE `linkis_ps_variable_key`
+ DROP INDEX IF EXISTS `application_id`,
+ ADD KEY `idx_aid` (`application_id`);
+
+ALTER TABLE `linkis_ps_datasource_table`
+ DROP INDEX IF EXISTS `database`,
+ ADD UNIQUE KEY `uniq_db_name` (`database`,`name`);
+
+ALTER TABLE `linkis_ps_cs_context_map`
+ DROP INDEX IF EXISTS `key`,
+ DROP INDEX IF EXISTS `keywords`,
+ ADD UNIQUE KEY `uniq_key_cid_ctype`
(`key`,`context_id`,`context_type`),
+ ADD KEY `idx_keywords` (`keywords`(191));
+
+ALTER TABLE `linkis_ps_cs_context_history`
+ DROP INDEX IF EXISTS `keyword`,
+ ADD KEY `idx_keyword` (`keyword`(191));
+
+ALTER TABLE `linkis_ps_cs_context_id`
+ DROP INDEX IF EXISTS `instance`,
+ DROP INDEX IF EXISTS `backup_instance`,
+ DROP INDEX IF EXISTS `instance_2`,
+ ADD KEY `idx_instance` (`instance`(128)),
+ ADD KEY `idx_backup_instance` (`backup_instance`(191)),
+ ADD KEY `idx_instance_bin` (`instance`(128),`backup_instance`(128));
+
+ALTER TABLE `linkis_ps_bml_resources_version`
+ DROP INDEX IF EXISTS `resource_id_version`,
+ ADD UNIQUE KEY `uniq_rid_version` (`resource_id`, `version`);
+
+ALTER TABLE `linkis_ps_bml_project`
+ DROP INDEX IF EXISTS `name`,
+ ADD UNIQUE KEY `uniq_name` (`name`);
+
+ALTER TABLE `linkis_ps_bml_project_user`
+ DROP INDEX IF EXISTS `user_project`,
+ ADD UNIQUE KEY `uniq_name_pid` (`username`, `project_id`);
+
+ALTER TABLE `linkis_ps_instance_label`
+ DROP INDEX IF EXISTS `label_key_value`,
+ ADD UNIQUE KEY `uniq_lk_lv` (`label_key`,`label_value`);
+
+ALTER TABLE `linkis_ps_instance_label_value_relation`
+ DROP INDEX IF EXISTS `label_value_key_label_id`,
+ ADD UNIQUE KEY `uniq_lvk_lid` (`label_value_key`,`label_id`);
+
+ALTER TABLE `linkis_ps_instance_label_relation`
+ DROP INDEX IF EXISTS `label_instance`,
+ ADD UNIQUE KEY `uniq_lid_instance` (`label_id`,`service_instance`);
+
+ALTER TABLE `linkis_ps_instance_info`
+ DROP INDEX IF EXISTS `instance`,
+ ADD UNIQUE KEY `uniq_instance` (`instance`);
+
+ALTER TABLE `linkis_cg_manager_service_instance`
+ DROP INDEX IF EXISTS `instance`,
+ ADD UNIQUE KEY `uniq_instance` (`instance`);
+
+ALTER TABLE `linkis_cg_manager_label`
+ DROP INDEX IF EXISTS `label_key_value`,
+ ADD UNIQUE KEY `uniq_lk_lv` (`label_key`,`label_value`);
+
+ALTER TABLE `linkis_cg_manager_label_value_relation`
+ DROP INDEX IF EXISTS `label_value_key_label_id`,
+ ADD UNIQUE KEY `uniq_lvk_lid` (`label_value_key`,`label_id`);
+
+ALTER TABLE `linkis_cg_manager_label_resource`
+ DROP INDEX IF EXISTS `label_id`,
+ ADD UNIQUE KEY `uniq_label_id` (`label_id`);
+
+ALTER TABLE `linkis_cg_ec_resource_info_record`
+ DROP INDEX IF EXISTS `ticket_id`,
+ DROP INDEX IF EXISTS `label_value_ticket_id`,
+ ADD KEY `idx_tid` (`ticket_id`),
+ ADD UNIQUE KEY `uniq_tid_lv` (`ticket_id`,`label_value`);
+
+ALTER TABLE `linkis_cg_manager_label_service_instance`
+ DROP INDEX IF EXISTS `label_serviceinstance`,
+ ADD KEY `idx_lid_instance` (`label_id`,`service_instance`);
+
+ALTER TABLE `linkis_cg_manager_label_service_instance`
+ DROP INDEX IF EXISTS `label_serviceinstance`,
+ ADD KEY `uniq_lid_instance` (`label_id`,`service_instance`);
+
+ALTER TABLE `linkis_ps_dm_datasource_env`
+ DROP INDEX IF EXISTS `env_name`,
+ DROP INDEX IF EXISTS `env_name_datasource_type_id`,
+ ADD UNIQUE KEY `uniq_env_name` (`env_name`),
+ ADD UNIQUE INDEX `uniq_name_dtid` (`env_name`, `datasource_type_id`);
+
+ALTER TABLE `linkis_ps_dm_datasource_type_key`
+ DROP INDEX IF EXISTS `data_source_type_id_key`,
+ ADD UNIQUE KEY `uniq_dstid_key` (`data_source_type_id`, `key`);
+
+ALTER TABLE `linkis_mg_gateway_auth_token`
+ DROP INDEX IF EXISTS `token_name`,
+ ADD UNIQUE KEY `uniq_token_name` (`token_name`);
+
+ALTER TABLE `linkis_ps_dm_datasource`
+ DROP INDEX IF EXISTS `datasource_name_un`,
+ ADD UNIQUE KEY `uniq_datasource_name` (`datasource_name`);
+
+ALTER TABLE `linkis_ps_dm_datasource_type`
+ DROP INDEX IF EXISTS `name_un`,
+ ADD UNIQUE INDEX `uniq_name` (`name`);
+
+ALTER TABLE `linkis_cg_user_ip_config`
+ DROP INDEX IF EXISTS `user_creator`,
+ ADD UNIQUE KEY `uniq_user_creator` (`user`,`creator`);
+
+ALTER TABLE `linkis_cg_tenant_label_config`
+ DROP INDEX IF EXISTS `user_creator`,
+ ADD UNIQUE KEY `uniq_user_creator` (`user`,`creator`);
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
