This is an automated email from the ASF dual-hosted git repository.
casion pushed a commit to branch dev-1.3.1
in repository https://gitbox.apache.org/repos/asf/incubator-linkis.git
The following commit(s) were added to refs/heads/dev-1.3.1 by this push:
new 69584a37c update sql index (#4023)
69584a37c is described below
commit 69584a37c7db403e22a4d54e1ef83246c2b46e00
Author: aiceflower <[email protected]>
AuthorDate: Mon Dec 19 17:29:42 2022 +0800
update sql index (#4023)
---
linkis-dist/package/db/linkis_ddl.sql | 4 ++--
linkis-dist/package/db/upgrade/1.3.1_schema/mysql/linkis_dml.sql | 2 +-
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/linkis-dist/package/db/linkis_ddl.sql
b/linkis-dist/package/db/linkis_ddl.sql
index 99babaed3..55b551270 100644
--- a/linkis-dist/package/db/linkis_ddl.sql
+++ b/linkis-dist/package/db/linkis_ddl.sql
@@ -644,7 +644,8 @@ CREATE TABLE `linkis_ps_error_code` (
`error_desc` varchar(1024) NOT NULL,
`error_regex` varchar(1024) DEFAULT NULL,
`error_type` int(3) DEFAULT 0,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ UNIQUE INDEX `idx_error_regex` (error_regex(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `linkis_cg_manager_service_instance`;
@@ -876,7 +877,6 @@ 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
diff --git a/linkis-dist/package/db/upgrade/1.3.1_schema/mysql/linkis_dml.sql
b/linkis-dist/package/db/upgrade/1.3.1_schema/mysql/linkis_dml.sql
index 95f311ebf..b44e91cfb 100644
--- a/linkis-dist/package/db/upgrade/1.3.1_schema/mysql/linkis_dml.sql
+++ b/linkis-dist/package/db/upgrade/1.3.1_schema/mysql/linkis_dml.sql
@@ -135,6 +135,6 @@ DELETE FROM `linkis_ps_error_code` WHERE error_code = 43008;
ALTER TABLE `linkis_ps_dm_datasource_env` ADD UNIQUE INDEX
`env_name_datasource_type_id` (`env_name`, `datasource_type_id`);
ALTER TABLE `linkis_ps_dm_datasource` ADD UNIQUE INDEX `datasource_name_un`
(`datasource_name`);
ALTER TABLE `linkis_ps_dm_datasource_type` ADD UNIQUE INDEX `name_un` (`name`);
-ALTER TABLE `linkis_ps_error_code` ADD UNIQUE INDEX `idx_error_regex`
(error_regex(100));
+ALTER TABLE `linkis_ps_error_code` ADD UNIQUE INDEX `idx_error_regex`
(error_regex(255));
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
