This is an automated email from the ASF dual-hosted git repository. benjobs pushed a commit to branch sync_2.1.3 in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git
commit d5f792ab110c674b888a6dc4fcf464bd542cf21d Author: benjobs <[email protected]> AuthorDate: Wed Mar 13 14:25:38 2024 +0800 [Improve] 2.1.3 ddl --- .../src/main/assembly/script/data/mysql-data.sql | 3 +- .../src/main/assembly/script/data/pgsql-data.sql | 1 + .../main/assembly/script/upgrade/mysql/2.1.2.sql | 27 +++++++++++++ .../main/assembly/script/upgrade/mysql/2.1.3.sql | 46 ++++++++++++++++++++++ .../main/assembly/script/upgrade/pgsql/2.1.2.sql | 19 +++++++++ .../main/assembly/script/upgrade/pgsql/2.1.3.sql | 24 +++++++++++ 6 files changed, 119 insertions(+), 1 deletion(-) diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/data/mysql-data.sql b/streampark-console/streampark-console-service/src/main/assembly/script/data/mysql-data.sql index 5ae06037d..b47810339 100644 --- a/streampark-console/streampark-console-service/src/main/assembly/script/data/mysql-data.sql +++ b/streampark-console/streampark-console-service/src/main/assembly/script/data/mysql-data.sql @@ -284,7 +284,8 @@ insert into `t_setting` values (6, 'alert.email.port', null, 'Alert Email Smtp P insert into `t_setting` values (7, 'alert.email.from', null, 'Alert Sender Email', 'Email to send alerts', 1); insert into `t_setting` values (8, 'alert.email.userName', null, 'Alert Email User', 'Authentication username used to send alert emails', 1); insert into `t_setting` values (9, 'alert.email.password', null, 'Alert Email Password', 'Authentication password used to send alarm email', 1); -insert into `t_setting` values (10, 'alert.email.ssl', 'false', 'Alert Email SSL', 'Whether to enable SSL in the mailbox that sends the alert', 2);insert into `t_setting` values (11, 'docker.register.address', null, 'Docker Register Address', 'Docker container service address', 1); +insert into `t_setting` values (10, 'alert.email.ssl', 'false', 'Alert Email SSL', 'Whether to enable SSL in the mailbox that sends the alert', 2); +insert into `t_setting` values (11, 'docker.register.address', null, 'Docker Register Address', 'Docker container service address', 1); insert into `t_setting` values (12, 'docker.register.user', null, 'Docker Register User', 'Docker container service authentication username', 1); insert into `t_setting` values (13, 'docker.register.password', null, 'Docker Register Password', 'Docker container service authentication password', 1); insert into `t_setting` values (14, 'docker.register.namespace', null, 'Docker namespace', 'Namespace for docker image used in docker building env and target image register', 1); diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql b/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql index 0e5a96462..d9105e592 100644 --- a/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql +++ b/streampark-console/streampark-console-service/src/main/assembly/script/data/pgsql-data.sql @@ -255,6 +255,7 @@ insert into "public"."t_setting" values (12, 'docker.register.user', null, 'Dock insert into "public"."t_setting" values (13, 'docker.register.password', null, 'Docker Register Password', 'Docker container service authentication password', 1); insert into "public"."t_setting" values (14, 'docker.register.namespace', null, 'Docker namespace', 'Namespace for docker image used in docker building env and target image register', 1); insert into "public"."t_setting" values (15, 'ingress.mode.default', null, 'Ingress domain address', 'Automatically generate an nginx-based ingress by passing in a domain name', 1); + -- ---------------------------- -- Records of t_user -- ---------------------------- diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql new file mode 100644 index 000000000..c0fafc641 --- /dev/null +++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.2.sql @@ -0,0 +1,27 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You under the Apache License, Version 2.0 + * (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +use streampark; + +set names utf8mb4; +set foreign_key_checks = 0; + +alter table `t_flink_app` + add column `dependency` text collate utf8mb4_general_ci default null after `main_class`, + modify column `modify_time` datetime not null comment 'modify time'; + +set foreign_key_checks = 1; diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.3.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.3.sql new file mode 100644 index 000000000..b942363db --- /dev/null +++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/mysql/2.1.3.sql @@ -0,0 +1,46 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You under the Apache License, Version 2.0 + * (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +use streampark; + +set names utf8mb4; +set foreign_key_checks = 0; + +update `t_menu` set menu_name='Apache Flink',order_num=1 where menu_id = 120000; +update `t_menu` set order_num=3 where menu_id = 110000; +update `t_menu` set order_num=2 where menu_id = 130000; +delete from `t_menu` where menu_id=110300; + +alter table `t_flink_app` + modify column `args` longtext, + modify column `dynamic_properties` longtext, + modify column `k8s_pod_template` longtext, + modify column `k8s_jm_pod_template` longtext, + modify column `k8s_tm_pod_template` longtext, + modify column `options` longtext comment 'json form of parameter collection ', + modify column `modify_time` datetime default null comment 'modify time'; + +alter table `t_flink_cluster` + modify column `options` longtext comment 'json form of parameter collection ', + modify column `dynamic_properties` longtext comment 'allows specifying multiple generic configuration options', + modify column `exception` longtext comment 'exception information'; + +alter table `t_message` modify column `context` longtext; + +alter table `t_flink_project` drop column `git_credential`; + +set foreign_key_checks = 1; diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.2.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.2.sql new file mode 100644 index 000000000..a87816bf4 --- /dev/null +++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.2.sql @@ -0,0 +1,19 @@ +/* +* Licensed to the Apache Software Foundation (ASF) under one or more +* contributor license agreements. See the NOTICE file distributed with +* this work for additional information regarding copyright ownership. +* The ASF licenses this file to You under the Apache License, Version 2.0 +* (the "License"); you may not use this file except in compliance with +* the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +*/ + +alter table "public"."t_flink_app" + add column "dependency" text collate "pg_catalog"."default"; diff --git a/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.3.sql b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.3.sql new file mode 100644 index 000000000..2f147d89a --- /dev/null +++ b/streampark-console/streampark-console-service/src/main/assembly/script/upgrade/pgsql/2.1.3.sql @@ -0,0 +1,24 @@ +/* +* Licensed to the Apache Software Foundation (ASF) under one or more +* contributor license agreements. See the NOTICE file distributed with +* this work for additional information regarding copyright ownership. +* The ASF licenses this file to You under the Apache License, Version 2.0 +* (the "License"); you may not use this file except in compliance with +* the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +*/ + +alter table "public"."t_flink_project" + drop column "git_credential"; + +update "public"."t_menu" set menu_name='Apache Flink',order_num=1 where menu_id = 120000; +update "public"."t_menu" set order_num=3 where menu_id = 110000; +update "public"."t_menu" set order_num=2 where menu_id = 130000; +delete from "public"."t_menu" where menu_id=110300;
