This is an automated email from the ASF dual-hosted git repository.
jinsongzhou pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/amoro.git
The following commit(s) were added to refs/heads/master by this push:
new 7b7e51266 Move upgrade SQL for version 0.7.0 (#3085)
7b7e51266 is described below
commit 7b7e51266d356504bea14024a1c6b760dc36312c
Author: ZhouJinsong <[email protected]>
AuthorDate: Tue Aug 13 10:24:41 2024 +0800
Move upgrade SQL for version 0.7.0 (#3085)
Move uprade sql for 0.7.0
---
.../main/resources/mysql/{update.sql => upgrade-0.6.1-to-0.7.0.sql} | 5 +----
.../src/main/resources/{postgres/update.sql => mysql/upgrade.sql} | 6 ------
.../resources/postgres/{update.sql => upgrade-0.6.1-to-0.7.0.sql} | 2 +-
.../src/main/resources/postgres/{update.sql => upgrade.sql} | 6 ------
4 files changed, 2 insertions(+), 17 deletions(-)
diff --git a/amoro-ams/amoro-ams-server/src/main/resources/mysql/update.sql
b/amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade-0.6.1-to-0.7.0.sql
similarity index 86%
rename from amoro-ams/amoro-ams-server/src/main/resources/mysql/update.sql
rename to
amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade-0.6.1-to-0.7.0.sql
index e99d4af4a..048919990 100644
--- a/amoro-ams/amoro-ams-server/src/main/resources/mysql/update.sql
+++
b/amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade-0.6.1-to-0.7.0.sql
@@ -13,11 +13,8 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--- If you have any changes to the AMS database, please record them in this
file.
--- We will confirm the corresponding version of these upgrade scripts when
releasing.
-
ALTER TABLE table_identifier CHANGE COLUMN table_name table_name varchar(256)
NOT NULL;
ALTER TABLE table_optimizing_process CHANGE COLUMN table_name table_name
varchar(256) NOT NULL;
ALTER TABLE table_metadata CHANGE COLUMN table_name table_name varchar(256)
NOT NULL;
ALTER TABLE table_runtime CHANGE COLUMN table_name table_name varchar(256) NOT
NULL;
-ALTER TABLE table_blocker CHANGE COLUMN table_name table_name varchar(256) NOT
NULL;
+ALTER TABLE table_blocker CHANGE COLUMN table_name table_name varchar(256) NOT
NULL;
\ No newline at end of file
diff --git a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
b/amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade.sql
similarity index 70%
copy from amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
copy to amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade.sql
index 0b7bc0b3c..69f409555 100644
--- a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
+++ b/amoro-ams/amoro-ams-server/src/main/resources/mysql/upgrade.sql
@@ -15,9 +15,3 @@
-- If you have any changes to the AMS database, please record them in this
file.
-- We will confirm the corresponding version of these upgrade scripts when
releasing.
-
-ALTER TABLE table_identifier ALTER COLUMN table_name TYPE varchar(256) NOT
NULL;
-ALTER TABLE table_optimizing_process ALTER COLUMN table_name TYPE varchar(256)
NOT NULL;
-ALTER TABLE table_metadata ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
-ALTER TABLE table_runtime ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
-ALTER TABLE table_blocker ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
diff --git a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
b/amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade-0.6.1-to-0.7.0.sql
similarity index 98%
copy from amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
copy to
amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade-0.6.1-to-0.7.0.sql
index 0b7bc0b3c..c1bb51995 100644
--- a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
+++
b/amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade-0.6.1-to-0.7.0.sql
@@ -20,4 +20,4 @@ ALTER TABLE table_identifier ALTER COLUMN table_name TYPE
varchar(256) NOT NULL;
ALTER TABLE table_optimizing_process ALTER COLUMN table_name TYPE varchar(256)
NOT NULL;
ALTER TABLE table_metadata ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
ALTER TABLE table_runtime ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
-ALTER TABLE table_blocker ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
+ALTER TABLE table_blocker ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
\ No newline at end of file
diff --git a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
b/amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade.sql
similarity index 70%
rename from amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
rename to amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade.sql
index 0b7bc0b3c..69f409555 100644
--- a/amoro-ams/amoro-ams-server/src/main/resources/postgres/update.sql
+++ b/amoro-ams/amoro-ams-server/src/main/resources/postgres/upgrade.sql
@@ -15,9 +15,3 @@
-- If you have any changes to the AMS database, please record them in this
file.
-- We will confirm the corresponding version of these upgrade scripts when
releasing.
-
-ALTER TABLE table_identifier ALTER COLUMN table_name TYPE varchar(256) NOT
NULL;
-ALTER TABLE table_optimizing_process ALTER COLUMN table_name TYPE varchar(256)
NOT NULL;
-ALTER TABLE table_metadata ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
-ALTER TABLE table_runtime ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
-ALTER TABLE table_blocker ALTER COLUMN table_name TYPE varchar(256) NOT NULL;
