This is an automated email from the ASF dual-hosted git repository.
yuqi4733 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/gravitino.git
The following commit(s) were added to refs/heads/main by this push:
new 546099929e [#8658]improvement: Replace MySQL types with H2 compatible
casts in ModelVersionMetaH2Provider and h2 scripts (#8675)
546099929e is described below
commit 546099929e73855450876434a8d4fa7ad257cc54
Author: Raj Gupta <[email protected]>
AuthorDate: Mon Sep 29 12:03:29 2025 +0530
[#8658]improvement: Replace MySQL types with H2 compatible casts in
ModelVersionMetaH2Provider and h2 scripts (#8675)
<!--
1. Title: [#<issue>] <type>(<scope>): <subject>
Examples:
- "[#123] feat(operator): support xxx"
- "[#233] fix: check null before access result in xxx"
- "[MINOR] refactor: fix typo in variable name"
- "[MINOR] docs: fix typo in README"
- "[#255] test: fix flaky test NameOfTheTest"
Reference: https://www.conventionalcommits.org/en/v1.0.0/
2. If the PR is unfinished, please mark this PR as draft.
-->
### What changes were proposed in this pull request?
- This PR updates the `ModelVersionMetaH2Provider` to make it fully
compatible with H2 by removing
SQL specific column types (`MEDIUMTEXT`, `TEXT`) and replacing them with
`CLOB`.
Fix: #8658
---
.../provider/h2/ModelVersionMetaH2Provider.java | 12 +--
scripts/h2/schema-0.6.0-h2.sql | 46 +++++------
scripts/h2/schema-0.7.0-h2.sql | 52 ++++++-------
scripts/h2/schema-0.8.0-h2.sql | 70 ++++++++---------
scripts/h2/schema-0.9.0-h2.sql | 70 ++++++++---------
scripts/h2/schema-1.0.0-h2.sql | 90 +++++++++++-----------
scripts/h2/upgrade-0.6.0-to-0.7.0-h2.sql | 6 +-
scripts/h2/upgrade-0.7.0-to-0.8.0-h2.sql | 18 ++---
scripts/h2/upgrade-0.9.0-to-1.0.0-h2.sql | 20 ++---
9 files changed, 192 insertions(+), 192 deletions(-)
diff --git
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/h2/ModelVersionMetaH2Provider.java
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/h2/ModelVersionMetaH2Provider.java
index 13f8cff362..41d857a4c4 100644
---
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/h2/ModelVersionMetaH2Provider.java
+++
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/h2/ModelVersionMetaH2Provider.java
@@ -40,10 +40,10 @@ public class ModelVersionMetaH2Provider extends
ModelVersionMetaBaseSQLProvider
+ " FROM ("
+ "<foreach collection='modelVersionMetas' item='version'
separator='UNION ALL'>"
+ " SELECT"
- + " CAST(#{version.modelId} AS BIGINT) AS model_id,
CAST(#{version.modelVersionComment} AS TEXT) AS model_version_comment,"
- + " CAST(#{version.modelVersionProperties} AS MEDIUMTEXT) AS
model_version_properties, CAST(#{version.auditInfo} AS MEDIUMTEXT) AS
audit_info,"
+ + " CAST(#{version.modelId} AS BIGINT) AS model_id,
CAST(#{version.modelVersionComment} AS CLOB) AS model_version_comment,"
+ + " CAST(#{version.modelVersionProperties} AS CLOB) AS
model_version_properties, CAST(#{version.auditInfo} AS CLOB) AS audit_info,"
+ " CAST(#{version.deletedAt} AS BIGINT) AS deleted_at,
CAST(#{version.modelVersionUriName} AS VARCHAR(128)) AS model_version_uri_name,"
- + " CAST(#{version.modelVersionUri} AS TEXT) AS model_version_uri "
+ + " CAST(#{version.modelVersionUri} AS CLOB) AS model_version_uri "
+ "</foreach>"
+ " ) v"
+ " JOIN"
@@ -68,10 +68,10 @@ public class ModelVersionMetaH2Provider extends
ModelVersionMetaBaseSQLProvider
+ " FROM ("
+ "<foreach collection='modelVersionMetas' item='version'
separator='UNION ALL'>"
+ " SELECT"
- + " CAST(#{version.modelId} AS BIGINT) AS model_id,
CAST(#{version.modelVersionComment} AS TEXT) AS model_version_comment,"
- + " CAST(#{version.modelVersionProperties} AS MEDIUMTEXT) AS
model_version_properties, CAST(#{version.auditInfo} AS MEDIUMTEXT) AS
audit_info,"
+ + " CAST(#{version.modelId} AS BIGINT) AS model_id,
CAST(#{version.modelVersionComment} AS CLOB) AS model_version_comment,"
+ + " CAST(#{version.modelVersionProperties} AS CLOB) AS
model_version_properties, CAST(#{version.auditInfo} AS CLOB) AS audit_info,"
+ " CAST(#{version.deletedAt} AS BIGINT) AS deleted_at,
CAST(#{version.modelVersionUriName} AS VARCHAR(128)) AS model_version_uri_name,"
- + " CAST(#{version.modelVersionUri} AS TEXT) AS model_version_uri,
CAST(#{version.modelVersion} AS INT) AS model_version_number "
+ + " CAST(#{version.modelVersionUri} AS CLOB) AS model_version_uri,
CAST(#{version.modelVersion} AS INT) AS model_version_number "
+ "</foreach>"
+ " ) v"
+ " JOIN"
diff --git a/scripts/h2/schema-0.6.0-h2.sql b/scripts/h2/schema-0.6.0-h2.sql
index 367edf9dbf..15fe8bac38 100644
--- a/scripts/h2/schema-0.6.0-h2.sql
+++ b/scripts/h2/schema-0.6.0-h2.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS `metalake_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`metalake_name` VARCHAR(128) NOT NULL COMMENT 'metalake name',
`metalake_comment` VARCHAR(256) DEFAULT '' COMMENT 'metalake comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'metalake properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'metalake audit info',
- `schema_version` MEDIUMTEXT NOT NULL COMMENT 'metalake schema version
info',
+ `properties` CLOB DEFAULT NULL COMMENT 'metalake properties',
+ `audit_info` CLOB NOT NULL COMMENT 'metalake audit info',
+ `schema_version` CLOB NOT NULL COMMENT 'metalake schema version info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'metalake
deleted at',
@@ -39,8 +39,8 @@ CREATE TABLE IF NOT EXISTS `catalog_meta` (
`type` VARCHAR(64) NOT NULL COMMENT 'catalog type',
`provider` VARCHAR(64) NOT NULL COMMENT 'catalog provider',
`catalog_comment` VARCHAR(256) DEFAULT '' COMMENT 'catalog comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'catalog properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'catalog audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'catalog properties',
+ `audit_info` CLOB NOT NULL COMMENT 'catalog audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'catalog
deleted at',
@@ -55,8 +55,8 @@ CREATE TABLE IF NOT EXISTS `schema_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_comment` VARCHAR(256) DEFAULT '' COMMENT 'schema comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'schema audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'schema audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'schema
deleted at',
@@ -72,7 +72,7 @@ CREATE TABLE IF NOT EXISTS `table_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'table audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'table audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'table deleted
at',
@@ -91,7 +91,7 @@ CREATE TABLE IF NOT EXISTS `fileset_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`type` VARCHAR(64) NOT NULL COMMENT 'fileset type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'fileset audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'fileset audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
@@ -111,8 +111,8 @@ CREATE TABLE IF NOT EXISTS `fileset_version_info` (
`fileset_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'fileset id',
`version` INT UNSIGNED NOT NULL COMMENT 'fileset info version',
`fileset_comment` VARCHAR(256) DEFAULT '' COMMENT 'fileset comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset properties',
- `storage_location` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset storage
location',
+ `properties` CLOB DEFAULT NULL COMMENT 'fileset properties',
+ `storage_location` CLOB DEFAULT NULL COMMENT 'fileset storage location',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
PRIMARY KEY (id),
CONSTRAINT uk_fid_ver_del UNIQUE (fileset_id, version, deleted_at),
@@ -128,8 +128,8 @@ CREATE TABLE IF NOT EXISTS `topic_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`comment` VARCHAR(256) DEFAULT '' COMMENT 'topic comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'topic properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'topic audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'topic properties',
+ `audit_info` CLOB NOT NULL COMMENT 'topic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic deleted
at',
@@ -144,7 +144,7 @@ CREATE TABLE IF NOT EXISTS `user_meta` (
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`user_name` VARCHAR(128) NOT NULL COMMENT 'username',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'user audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'user audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'user deleted
at',
@@ -156,8 +156,8 @@ CREATE TABLE IF NOT EXISTS `role_meta` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`role_name` VARCHAR(128) NOT NULL COMMENT 'role name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'role audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'role audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'role deleted
at',
@@ -184,7 +184,7 @@ CREATE TABLE IF NOT EXISTS `user_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -197,7 +197,7 @@ CREATE TABLE IF NOT EXISTS `group_meta` (
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`group_name` VARCHAR(128) NOT NULL COMMENT 'group name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'group audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'group audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'group deleted
at',
@@ -209,7 +209,7 @@ CREATE TABLE IF NOT EXISTS `group_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -223,8 +223,8 @@ CREATE TABLE IF NOT EXISTS `tag_meta` (
`tag_name` VARCHAR(128) NOT NULL COMMENT 'tag name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`tag_comment` VARCHAR(256) DEFAULT '' COMMENT 'tag comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'tag properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'tag properties',
+ `audit_info` CLOB NOT NULL COMMENT 'tag audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag deleted
at',
@@ -237,7 +237,7 @@ CREATE TABLE IF NOT EXISTS `tag_relation_meta` (
`tag_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'tag id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'tag relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag relation
deleted at',
@@ -254,7 +254,7 @@ CREATE TABLE IF NOT EXISTS `owner_meta` (
`owner_type` VARCHAR(64) NOT NULL COMMENT 'owner type',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'owner relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'owner relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'owner
relation deleted at',
diff --git a/scripts/h2/schema-0.7.0-h2.sql b/scripts/h2/schema-0.7.0-h2.sql
index 87253c502d..fcb18541d1 100644
--- a/scripts/h2/schema-0.7.0-h2.sql
+++ b/scripts/h2/schema-0.7.0-h2.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS `metalake_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`metalake_name` VARCHAR(128) NOT NULL COMMENT 'metalake name',
`metalake_comment` VARCHAR(256) DEFAULT '' COMMENT 'metalake comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'metalake properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'metalake audit info',
- `schema_version` MEDIUMTEXT NOT NULL COMMENT 'metalake schema version
info',
+ `properties` CLOB DEFAULT NULL COMMENT 'metalake properties',
+ `audit_info` CLOB NOT NULL COMMENT 'metalake audit info',
+ `schema_version` CLOB NOT NULL COMMENT 'metalake schema version info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'metalake
deleted at',
@@ -39,8 +39,8 @@ CREATE TABLE IF NOT EXISTS `catalog_meta` (
`type` VARCHAR(64) NOT NULL COMMENT 'catalog type',
`provider` VARCHAR(64) NOT NULL COMMENT 'catalog provider',
`catalog_comment` VARCHAR(256) DEFAULT '' COMMENT 'catalog comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'catalog properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'catalog audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'catalog properties',
+ `audit_info` CLOB NOT NULL COMMENT 'catalog audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'catalog
deleted at',
@@ -55,8 +55,8 @@ CREATE TABLE IF NOT EXISTS `schema_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_comment` VARCHAR(256) DEFAULT '' COMMENT 'schema comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'schema audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'schema audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'schema
deleted at',
@@ -72,7 +72,7 @@ CREATE TABLE IF NOT EXISTS `table_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'table audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'table audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'table deleted
at',
@@ -94,14 +94,14 @@ CREATE TABLE IF NOT EXISTS `table_column_version_info` (
`column_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'column id',
`column_name` VARCHAR(128) NOT NULL COMMENT 'column name',
`column_position` INT UNSIGNED NOT NULL COMMENT 'column position, starting
from 0',
- `column_type` TEXT NOT NULL COMMENT 'column type',
+ `column_type` CLOB NOT NULL COMMENT 'column type',
`column_comment` VARCHAR(256) DEFAULT '' COMMENT 'column comment',
`column_nullable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'column nullable,
0 is not nullable, 1 is nullable',
`column_auto_increment` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'column auto
increment, 0 is not auto increment, 1 is auto increment',
- `column_default_value` TEXT DEFAULT NULL COMMENT 'column default value',
+ `column_default_value` CLOB DEFAULT NULL COMMENT 'column default value',
`column_op_type` TINYINT(1) NOT NULL COMMENT 'column operation type, 1 is
create, 2 is update, 3 is delete',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'column
deleted at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'column audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'column audit info',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tid_ver_cid_del` (`table_id`, `table_version`, `column_id`,
`deleted_at`),
KEY `idx_tcmid` (`metalake_id`),
@@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS `fileset_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`type` VARCHAR(64) NOT NULL COMMENT 'fileset type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'fileset audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'fileset audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
@@ -137,8 +137,8 @@ CREATE TABLE IF NOT EXISTS `fileset_version_info` (
`fileset_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'fileset id',
`version` INT UNSIGNED NOT NULL COMMENT 'fileset info version',
`fileset_comment` VARCHAR(256) DEFAULT '' COMMENT 'fileset comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset properties',
- `storage_location` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset storage
location',
+ `properties` CLOB DEFAULT NULL COMMENT 'fileset properties',
+ `storage_location` CLOB DEFAULT NULL COMMENT 'fileset storage location',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
PRIMARY KEY (id),
CONSTRAINT uk_fid_ver_del UNIQUE (fileset_id, version, deleted_at),
@@ -154,8 +154,8 @@ CREATE TABLE IF NOT EXISTS `topic_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`comment` VARCHAR(256) DEFAULT '' COMMENT 'topic comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'topic properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'topic audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'topic properties',
+ `audit_info` CLOB NOT NULL COMMENT 'topic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic deleted
at',
@@ -170,7 +170,7 @@ CREATE TABLE IF NOT EXISTS `user_meta` (
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`user_name` VARCHAR(128) NOT NULL COMMENT 'username',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'user audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'user audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'user deleted
at',
@@ -182,8 +182,8 @@ CREATE TABLE IF NOT EXISTS `role_meta` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`role_name` VARCHAR(128) NOT NULL COMMENT 'role name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'role audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'role audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'role deleted
at',
@@ -210,7 +210,7 @@ CREATE TABLE IF NOT EXISTS `user_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -223,7 +223,7 @@ CREATE TABLE IF NOT EXISTS `group_meta` (
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`group_name` VARCHAR(128) NOT NULL COMMENT 'group name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'group audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'group audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'group deleted
at',
@@ -235,7 +235,7 @@ CREATE TABLE IF NOT EXISTS `group_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -249,8 +249,8 @@ CREATE TABLE IF NOT EXISTS `tag_meta` (
`tag_name` VARCHAR(128) NOT NULL COMMENT 'tag name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`tag_comment` VARCHAR(256) DEFAULT '' COMMENT 'tag comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'tag properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'tag properties',
+ `audit_info` CLOB NOT NULL COMMENT 'tag audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag deleted
at',
@@ -263,7 +263,7 @@ CREATE TABLE IF NOT EXISTS `tag_relation_meta` (
`tag_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'tag id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'tag relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag relation
deleted at',
@@ -280,7 +280,7 @@ CREATE TABLE IF NOT EXISTS `owner_meta` (
`owner_type` VARCHAR(64) NOT NULL COMMENT 'owner type',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'owner relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'owner relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'owner
relation deleted at',
diff --git a/scripts/h2/schema-0.8.0-h2.sql b/scripts/h2/schema-0.8.0-h2.sql
index 8a6b2f4343..00b1393c0c 100644
--- a/scripts/h2/schema-0.8.0-h2.sql
+++ b/scripts/h2/schema-0.8.0-h2.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS `metalake_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`metalake_name` VARCHAR(128) NOT NULL COMMENT 'metalake name',
`metalake_comment` VARCHAR(256) DEFAULT '' COMMENT 'metalake comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'metalake properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'metalake audit info',
- `schema_version` MEDIUMTEXT NOT NULL COMMENT 'metalake schema version
info',
+ `properties` CLOB DEFAULT NULL COMMENT 'metalake properties',
+ `audit_info` CLOB NOT NULL COMMENT 'metalake audit info',
+ `schema_version` CLOB NOT NULL COMMENT 'metalake schema version info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'metalake
deleted at',
@@ -39,8 +39,8 @@ CREATE TABLE IF NOT EXISTS `catalog_meta` (
`type` VARCHAR(64) NOT NULL COMMENT 'catalog type',
`provider` VARCHAR(64) NOT NULL COMMENT 'catalog provider',
`catalog_comment` VARCHAR(256) DEFAULT '' COMMENT 'catalog comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'catalog properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'catalog audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'catalog properties',
+ `audit_info` CLOB NOT NULL COMMENT 'catalog audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'catalog
deleted at',
@@ -55,8 +55,8 @@ CREATE TABLE IF NOT EXISTS `schema_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_comment` VARCHAR(256) DEFAULT '' COMMENT 'schema comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'schema audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'schema audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'schema
deleted at',
@@ -72,7 +72,7 @@ CREATE TABLE IF NOT EXISTS `table_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'table audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'table audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'table deleted
at',
@@ -94,14 +94,14 @@ CREATE TABLE IF NOT EXISTS `table_column_version_info` (
`column_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'column id',
`column_name` VARCHAR(128) NOT NULL COMMENT 'column name',
`column_position` INT UNSIGNED NOT NULL COMMENT 'column position, starting
from 0',
- `column_type` TEXT NOT NULL COMMENT 'column type',
+ `column_type` CLOB NOT NULL COMMENT 'column type',
`column_comment` VARCHAR(256) DEFAULT '' COMMENT 'column comment',
`column_nullable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'column nullable,
0 is not nullable, 1 is nullable',
`column_auto_increment` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'column auto
increment, 0 is not auto increment, 1 is auto increment',
- `column_default_value` TEXT DEFAULT NULL COMMENT 'column default value',
+ `column_default_value` CLOB DEFAULT NULL COMMENT 'column default value',
`column_op_type` TINYINT(1) NOT NULL COMMENT 'column operation type, 1 is
create, 2 is update, 3 is delete',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'column
deleted at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'column audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'column audit info',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tid_ver_cid_del` (`table_id`, `table_version`, `column_id`,
`deleted_at`),
KEY `idx_tcmid` (`metalake_id`),
@@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS `fileset_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`type` VARCHAR(64) NOT NULL COMMENT 'fileset type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'fileset audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'fileset audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
@@ -137,8 +137,8 @@ CREATE TABLE IF NOT EXISTS `fileset_version_info` (
`fileset_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'fileset id',
`version` INT UNSIGNED NOT NULL COMMENT 'fileset info version',
`fileset_comment` VARCHAR(256) DEFAULT '' COMMENT 'fileset comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset properties',
- `storage_location` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset storage
location',
+ `properties` CLOB DEFAULT NULL COMMENT 'fileset properties',
+ `storage_location` CLOB DEFAULT NULL COMMENT 'fileset storage location',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
PRIMARY KEY (id),
CONSTRAINT uk_fid_ver_del UNIQUE (fileset_id, version, deleted_at),
@@ -154,8 +154,8 @@ CREATE TABLE IF NOT EXISTS `topic_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`comment` VARCHAR(256) DEFAULT '' COMMENT 'topic comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'topic properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'topic audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'topic properties',
+ `audit_info` CLOB NOT NULL COMMENT 'topic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic deleted
at',
@@ -170,7 +170,7 @@ CREATE TABLE IF NOT EXISTS `user_meta` (
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`user_name` VARCHAR(128) NOT NULL COMMENT 'username',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'user audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'user audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'user deleted
at',
@@ -182,8 +182,8 @@ CREATE TABLE IF NOT EXISTS `role_meta` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`role_name` VARCHAR(128) NOT NULL COMMENT 'role name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'role audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'role audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'role deleted
at',
@@ -196,8 +196,8 @@ CREATE TABLE IF NOT EXISTS `role_meta_securable_object` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'securable
object entity id',
`type` VARCHAR(128) NOT NULL COMMENT 'securable object type',
- `privilege_names` TEXT(81920) NOT NULL COMMENT 'securable object privilege
names',
- `privilege_conditions` TEXT(81920) NOT NULL COMMENT 'securable object
privilege conditions',
+ `privilege_names` CLOB(81920) NOT NULL COMMENT 'securable object privilege
names',
+ `privilege_conditions` CLOB(81920) NOT NULL COMMENT 'securable object
privilege conditions',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable
objectcurrent version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable object
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'securable
object deleted at',
@@ -210,7 +210,7 @@ CREATE TABLE IF NOT EXISTS `user_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -223,7 +223,7 @@ CREATE TABLE IF NOT EXISTS `group_meta` (
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`group_name` VARCHAR(128) NOT NULL COMMENT 'group name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'group audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'group audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'group deleted
at',
@@ -235,7 +235,7 @@ CREATE TABLE IF NOT EXISTS `group_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -249,8 +249,8 @@ CREATE TABLE IF NOT EXISTS `tag_meta` (
`tag_name` VARCHAR(128) NOT NULL COMMENT 'tag name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`tag_comment` VARCHAR(256) DEFAULT '' COMMENT 'tag comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'tag properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'tag properties',
+ `audit_info` CLOB NOT NULL COMMENT 'tag audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag deleted
at',
@@ -263,7 +263,7 @@ CREATE TABLE IF NOT EXISTS `tag_relation_meta` (
`tag_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'tag id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'tag relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag relation
deleted at',
@@ -280,7 +280,7 @@ CREATE TABLE IF NOT EXISTS `owner_meta` (
`owner_type` VARCHAR(64) NOT NULL COMMENT 'owner type',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'owner relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'owner relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'owner
relation deleted at',
@@ -296,10 +296,10 @@ CREATE TABLE IF NOT EXISTS `model_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `model_comment` TEXT DEFAULT NULL COMMENT 'model comment',
- `model_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model properties',
+ `model_comment` CLOB DEFAULT NULL COMMENT 'model comment',
+ `model_properties` CLOB DEFAULT NULL COMMENT 'model properties',
`model_latest_version` INT UNSIGNED DEFAULT 0 COMMENT 'model latest
version',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'model audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model deleted
at',
PRIMARY KEY (`model_id`),
UNIQUE KEY `uk_sid_mn_del` (`schema_id`, `model_name`, `deleted_at`),
@@ -314,10 +314,10 @@ CREATE TABLE IF NOT EXISTS `model_version_info` (
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`model_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'model id',
`version` INT UNSIGNED NOT NULL COMMENT 'model version',
- `model_version_comment` TEXT DEFAULT NULL COMMENT 'model version comment',
- `model_version_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model version
properties',
- `model_version_uri` TEXT NOT NULL COMMENT 'model storage uri',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model version audit info',
+ `model_version_comment` CLOB DEFAULT NULL COMMENT 'model version comment',
+ `model_version_properties` CLOB DEFAULT NULL COMMENT 'model version
properties',
+ `model_version_uri` CLOB NOT NULL COMMENT 'model storage uri',
+ `audit_info` CLOB NOT NULL COMMENT 'model version audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model version
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_mid_ver_del` (`model_id`, `version`, `deleted_at`),
diff --git a/scripts/h2/schema-0.9.0-h2.sql b/scripts/h2/schema-0.9.0-h2.sql
index 50585d4283..04123cb7b1 100644
--- a/scripts/h2/schema-0.9.0-h2.sql
+++ b/scripts/h2/schema-0.9.0-h2.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS `metalake_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`metalake_name` VARCHAR(128) NOT NULL COMMENT 'metalake name',
`metalake_comment` VARCHAR(256) DEFAULT '' COMMENT 'metalake comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'metalake properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'metalake audit info',
- `schema_version` MEDIUMTEXT NOT NULL COMMENT 'metalake schema version
info',
+ `properties` CLOB DEFAULT NULL COMMENT 'metalake properties',
+ `audit_info` CLOB NOT NULL COMMENT 'metalake audit info',
+ `schema_version` CLOB NOT NULL COMMENT 'metalake schema version info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'metalake
deleted at',
@@ -39,8 +39,8 @@ CREATE TABLE IF NOT EXISTS `catalog_meta` (
`type` VARCHAR(64) NOT NULL COMMENT 'catalog type',
`provider` VARCHAR(64) NOT NULL COMMENT 'catalog provider',
`catalog_comment` VARCHAR(256) DEFAULT '' COMMENT 'catalog comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'catalog properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'catalog audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'catalog properties',
+ `audit_info` CLOB NOT NULL COMMENT 'catalog audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'catalog
deleted at',
@@ -55,8 +55,8 @@ CREATE TABLE IF NOT EXISTS `schema_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_comment` VARCHAR(256) DEFAULT '' COMMENT 'schema comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'schema audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'schema audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'schema
deleted at',
@@ -72,7 +72,7 @@ CREATE TABLE IF NOT EXISTS `table_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'table audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'table audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'table deleted
at',
@@ -94,14 +94,14 @@ CREATE TABLE IF NOT EXISTS `table_column_version_info` (
`column_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'column id',
`column_name` VARCHAR(128) NOT NULL COMMENT 'column name',
`column_position` INT UNSIGNED NOT NULL COMMENT 'column position, starting
from 0',
- `column_type` TEXT NOT NULL COMMENT 'column type',
+ `column_type` CLOB NOT NULL COMMENT 'column type',
`column_comment` VARCHAR(256) DEFAULT '' COMMENT 'column comment',
`column_nullable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'column nullable,
0 is not nullable, 1 is nullable',
`column_auto_increment` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'column auto
increment, 0 is not auto increment, 1 is auto increment',
- `column_default_value` TEXT DEFAULT NULL COMMENT 'column default value',
+ `column_default_value` CLOB DEFAULT NULL COMMENT 'column default value',
`column_op_type` TINYINT(1) NOT NULL COMMENT 'column operation type, 1 is
create, 2 is update, 3 is delete',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'column
deleted at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'column audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'column audit info',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tid_ver_cid_del` (`table_id`, `table_version`, `column_id`,
`deleted_at`),
KEY `idx_tcmid` (`metalake_id`),
@@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS `fileset_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`type` VARCHAR(64) NOT NULL COMMENT 'fileset type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'fileset audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'fileset audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
@@ -137,9 +137,9 @@ CREATE TABLE IF NOT EXISTS `fileset_version_info` (
`fileset_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'fileset id',
`version` INT UNSIGNED NOT NULL COMMENT 'fileset info version',
`fileset_comment` VARCHAR(256) DEFAULT '' COMMENT 'fileset comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset properties',
+ `properties` CLOB DEFAULT NULL COMMENT 'fileset properties',
`storage_location_name` VARCHAR(128) NOT NULL DEFAULT 'default' COMMENT
'fileset storage location name',
- `storage_location` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset storage
location',
+ `storage_location` CLOB DEFAULT NULL COMMENT 'fileset storage location',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
PRIMARY KEY (id),
CONSTRAINT uk_fid_ver_del UNIQUE (fileset_id, version,
storage_location_name, deleted_at),
@@ -155,8 +155,8 @@ CREATE TABLE IF NOT EXISTS `topic_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`comment` VARCHAR(256) DEFAULT '' COMMENT 'topic comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'topic properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'topic audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'topic properties',
+ `audit_info` CLOB NOT NULL COMMENT 'topic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic deleted
at',
@@ -171,7 +171,7 @@ CREATE TABLE IF NOT EXISTS `user_meta` (
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`user_name` VARCHAR(128) NOT NULL COMMENT 'username',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'user audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'user audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'user deleted
at',
@@ -183,8 +183,8 @@ CREATE TABLE IF NOT EXISTS `role_meta` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`role_name` VARCHAR(128) NOT NULL COMMENT 'role name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'role audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'role audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'role deleted
at',
@@ -197,8 +197,8 @@ CREATE TABLE IF NOT EXISTS `role_meta_securable_object` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'securable
object entity id',
`type` VARCHAR(128) NOT NULL COMMENT 'securable object type',
- `privilege_names` TEXT(81920) NOT NULL COMMENT 'securable object privilege
names',
- `privilege_conditions` TEXT(81920) NOT NULL COMMENT 'securable object
privilege conditions',
+ `privilege_names` CLOB(81920) NOT NULL COMMENT 'securable object privilege
names',
+ `privilege_conditions` CLOB(81920) NOT NULL COMMENT 'securable object
privilege conditions',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable
objectcurrent version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable object
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'securable
object deleted at',
@@ -211,7 +211,7 @@ CREATE TABLE IF NOT EXISTS `user_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -224,7 +224,7 @@ CREATE TABLE IF NOT EXISTS `group_meta` (
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`group_name` VARCHAR(128) NOT NULL COMMENT 'group name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'group audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'group audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'group deleted
at',
@@ -236,7 +236,7 @@ CREATE TABLE IF NOT EXISTS `group_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -250,8 +250,8 @@ CREATE TABLE IF NOT EXISTS `tag_meta` (
`tag_name` VARCHAR(128) NOT NULL COMMENT 'tag name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`tag_comment` VARCHAR(256) DEFAULT '' COMMENT 'tag comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'tag properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'tag properties',
+ `audit_info` CLOB NOT NULL COMMENT 'tag audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag deleted
at',
@@ -264,7 +264,7 @@ CREATE TABLE IF NOT EXISTS `tag_relation_meta` (
`tag_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'tag id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'tag relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag relation
deleted at',
@@ -281,7 +281,7 @@ CREATE TABLE IF NOT EXISTS `owner_meta` (
`owner_type` VARCHAR(64) NOT NULL COMMENT 'owner type',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'owner relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'owner relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'owner
relation deleted at',
@@ -297,10 +297,10 @@ CREATE TABLE IF NOT EXISTS `model_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `model_comment` TEXT DEFAULT NULL COMMENT 'model comment',
- `model_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model properties',
+ `model_comment` CLOB DEFAULT NULL COMMENT 'model comment',
+ `model_properties` CLOB DEFAULT NULL COMMENT 'model properties',
`model_latest_version` INT UNSIGNED DEFAULT 0 COMMENT 'model latest
version',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'model audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model deleted
at',
PRIMARY KEY (`model_id`),
UNIQUE KEY `uk_sid_mn_del` (`schema_id`, `model_name`, `deleted_at`),
@@ -315,10 +315,10 @@ CREATE TABLE IF NOT EXISTS `model_version_info` (
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`model_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'model id',
`version` INT UNSIGNED NOT NULL COMMENT 'model version',
- `model_version_comment` TEXT DEFAULT NULL COMMENT 'model version comment',
- `model_version_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model version
properties',
- `model_version_uri` TEXT NOT NULL COMMENT 'model storage uri',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model version audit info',
+ `model_version_comment` CLOB DEFAULT NULL COMMENT 'model version comment',
+ `model_version_properties` CLOB DEFAULT NULL COMMENT 'model version
properties',
+ `model_version_uri` CLOB NOT NULL COMMENT 'model storage uri',
+ `audit_info` CLOB NOT NULL COMMENT 'model version audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model version
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_mid_ver_del` (`model_id`, `version`, `deleted_at`),
diff --git a/scripts/h2/schema-1.0.0-h2.sql b/scripts/h2/schema-1.0.0-h2.sql
index 438c80c1a1..85d9e65f2f 100644
--- a/scripts/h2/schema-1.0.0-h2.sql
+++ b/scripts/h2/schema-1.0.0-h2.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS `metalake_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`metalake_name` VARCHAR(128) NOT NULL COMMENT 'metalake name',
`metalake_comment` VARCHAR(256) DEFAULT '' COMMENT 'metalake comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'metalake properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'metalake audit info',
- `schema_version` MEDIUMTEXT NOT NULL COMMENT 'metalake schema version
info',
+ `properties` CLOB DEFAULT NULL COMMENT 'metalake properties',
+ `audit_info` CLOB NOT NULL COMMENT 'metalake audit info',
+ `schema_version` CLOB NOT NULL COMMENT 'metalake schema version info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'metalake last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'metalake
deleted at',
@@ -39,8 +39,8 @@ CREATE TABLE IF NOT EXISTS `catalog_meta` (
`type` VARCHAR(64) NOT NULL COMMENT 'catalog type',
`provider` VARCHAR(64) NOT NULL COMMENT 'catalog provider',
`catalog_comment` VARCHAR(256) DEFAULT '' COMMENT 'catalog comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'catalog properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'catalog audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'catalog properties',
+ `audit_info` CLOB NOT NULL COMMENT 'catalog audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'catalog last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'catalog
deleted at',
@@ -55,8 +55,8 @@ CREATE TABLE IF NOT EXISTS `schema_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_comment` VARCHAR(256) DEFAULT '' COMMENT 'schema comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'schema audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'schema audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'schema last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'schema
deleted at',
@@ -72,7 +72,7 @@ CREATE TABLE IF NOT EXISTS `table_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'table audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'table audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'table last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'table deleted
at',
@@ -94,14 +94,14 @@ CREATE TABLE IF NOT EXISTS `table_column_version_info` (
`column_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'column id',
`column_name` VARCHAR(128) NOT NULL COMMENT 'column name',
`column_position` INT UNSIGNED NOT NULL COMMENT 'column position, starting
from 0',
- `column_type` TEXT NOT NULL COMMENT 'column type',
+ `column_type` CLOB NOT NULL COMMENT 'column type',
`column_comment` VARCHAR(256) DEFAULT '' COMMENT 'column comment',
`column_nullable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'column nullable,
0 is not nullable, 1 is nullable',
`column_auto_increment` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'column auto
increment, 0 is not auto increment, 1 is auto increment',
- `column_default_value` TEXT DEFAULT NULL COMMENT 'column default value',
+ `column_default_value` CLOB DEFAULT NULL COMMENT 'column default value',
`column_op_type` TINYINT(1) NOT NULL COMMENT 'column operation type, 1 is
create, 2 is update, 3 is delete',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'column
deleted at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'column audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'column audit info',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tid_ver_cid_del` (`table_id`, `table_version`, `column_id`,
`deleted_at`),
KEY `idx_tcmid` (`metalake_id`),
@@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS `fileset_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`type` VARCHAR(64) NOT NULL COMMENT 'fileset type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'fileset audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'fileset audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'fileset last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
@@ -137,9 +137,9 @@ CREATE TABLE IF NOT EXISTS `fileset_version_info` (
`fileset_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'fileset id',
`version` INT UNSIGNED NOT NULL COMMENT 'fileset info version',
`fileset_comment` VARCHAR(256) DEFAULT '' COMMENT 'fileset comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset properties',
+ `properties` CLOB DEFAULT NULL COMMENT 'fileset properties',
`storage_location_name` VARCHAR(128) NOT NULL DEFAULT 'default' COMMENT
'fileset storage location name',
- `storage_location` MEDIUMTEXT DEFAULT NULL COMMENT 'fileset storage
location',
+ `storage_location` CLOB DEFAULT NULL COMMENT 'fileset storage location',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'fileset
deleted at',
PRIMARY KEY (id),
CONSTRAINT uk_fid_ver_del UNIQUE (fileset_id, version,
storage_location_name, deleted_at),
@@ -155,8 +155,8 @@ CREATE TABLE IF NOT EXISTS `topic_meta` (
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`comment` VARCHAR(256) DEFAULT '' COMMENT 'topic comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'topic properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'topic audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'topic properties',
+ `audit_info` CLOB NOT NULL COMMENT 'topic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'topic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'topic deleted
at',
@@ -171,7 +171,7 @@ CREATE TABLE IF NOT EXISTS `user_meta` (
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`user_name` VARCHAR(128) NOT NULL COMMENT 'username',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'user audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'user audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'user last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'user deleted
at',
@@ -183,8 +183,8 @@ CREATE TABLE IF NOT EXISTS `role_meta` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`role_name` VARCHAR(128) NOT NULL COMMENT 'role name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'schema properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'role audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'schema properties',
+ `audit_info` CLOB NOT NULL COMMENT 'role audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'role last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'role deleted
at',
@@ -197,8 +197,8 @@ CREATE TABLE IF NOT EXISTS `role_meta_securable_object` (
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'securable
object entity id',
`type` VARCHAR(128) NOT NULL COMMENT 'securable object type',
- `privilege_names` TEXT(81920) NOT NULL COMMENT 'securable object privilege
names',
- `privilege_conditions` TEXT(81920) NOT NULL COMMENT 'securable object
privilege conditions',
+ `privilege_names` CLOB(81920) NOT NULL COMMENT 'securable object privilege
names',
+ `privilege_conditions` CLOB(81920) NOT NULL COMMENT 'securable object
privilege conditions',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable
objectcurrent version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'securable object
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'securable
object deleted at',
@@ -211,7 +211,7 @@ CREATE TABLE IF NOT EXISTS `user_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'user id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -224,7 +224,7 @@ CREATE TABLE IF NOT EXISTS `group_meta` (
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`group_name` VARCHAR(128) NOT NULL COMMENT 'group name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'group audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'group audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'group last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'group deleted
at',
@@ -236,7 +236,7 @@ CREATE TABLE IF NOT EXISTS `group_role_rel` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'auto increment
id',
`group_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'group id',
`role_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'role id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'relation
deleted at',
@@ -250,8 +250,8 @@ CREATE TABLE IF NOT EXISTS `tag_meta` (
`tag_name` VARCHAR(128) NOT NULL COMMENT 'tag name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`tag_comment` VARCHAR(256) DEFAULT '' COMMENT 'tag comment',
- `properties` MEDIUMTEXT DEFAULT NULL COMMENT 'tag properties',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag audit info',
+ `properties` CLOB DEFAULT NULL COMMENT 'tag properties',
+ `audit_info` CLOB NOT NULL COMMENT 'tag audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag deleted
at',
@@ -264,7 +264,7 @@ CREATE TABLE IF NOT EXISTS `tag_relation_meta` (
`tag_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'tag id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'tag relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'tag relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'tag relation last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'tag relation
deleted at',
@@ -281,7 +281,7 @@ CREATE TABLE IF NOT EXISTS `owner_meta` (
`owner_type` VARCHAR(64) NOT NULL COMMENT 'owner type',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'owner relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'owner relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'owner relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'owner
relation deleted at',
@@ -297,10 +297,10 @@ CREATE TABLE IF NOT EXISTS `model_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `model_comment` TEXT DEFAULT NULL COMMENT 'model comment',
- `model_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model properties',
+ `model_comment` CLOB DEFAULT NULL COMMENT 'model comment',
+ `model_properties` CLOB DEFAULT NULL COMMENT 'model properties',
`model_latest_version` INT UNSIGNED DEFAULT 0 COMMENT 'model latest
version',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'model audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model deleted
at',
PRIMARY KEY (`model_id`),
UNIQUE KEY `uk_sid_mn_del` (`schema_id`, `model_name`, `deleted_at`),
@@ -315,11 +315,11 @@ CREATE TABLE IF NOT EXISTS `model_version_info` (
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`model_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'model id',
`version` INT UNSIGNED NOT NULL COMMENT 'model version',
- `model_version_comment` TEXT DEFAULT NULL COMMENT 'model version comment',
- `model_version_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model version
properties',
+ `model_version_comment` CLOB DEFAULT NULL COMMENT 'model version comment',
+ `model_version_properties` CLOB DEFAULT NULL COMMENT 'model version
properties',
`model_version_uri_name` VARCHAR(128) NOT NULL COMMENT 'model version uri
name',
- `model_version_uri` TEXT NOT NULL COMMENT 'model storage uri',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model version audit info',
+ `model_version_uri` CLOB NOT NULL COMMENT 'model storage uri',
+ `audit_info` CLOB NOT NULL COMMENT 'model version audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model version
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_mid_ver_uri_del` (`model_id`, `version`,
`model_version_uri_name`, `deleted_at`),
@@ -344,7 +344,7 @@ CREATE TABLE IF NOT EXISTS `policy_meta` (
`policy_name` VARCHAR(128) NOT NULL COMMENT 'policy name',
`policy_type` VARCHAR(64) NOT NULL COMMENT 'policy type',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'policy audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'policy audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
deleted at',
@@ -357,9 +357,9 @@ CREATE TABLE IF NOT EXISTS `policy_version_info` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`policy_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'policy id',
`version` INT UNSIGNED NOT NULL COMMENT 'policy info version',
- `policy_comment` TEXT DEFAULT NULL COMMENT 'policy info comment',
+ `policy_comment` CLOB DEFAULT NULL COMMENT 'policy info comment',
`enabled` TINYINT(1) DEFAULT 1 COMMENT 'whether the policy is enabled, 0
is disabled, 1 is enabled',
- `content` MEDIUMTEXT DEFAULT NULL COMMENT 'policy content',
+ `content` CLOB DEFAULT NULL COMMENT 'policy content',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_pod_ver_del` (`policy_id`, `version`, `deleted_at`),
@@ -371,7 +371,7 @@ CREATE TABLE IF NOT EXISTS `policy_relation_meta` (
`policy_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'policy id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'policy relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'policy relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
relation deleted at',
@@ -386,10 +386,10 @@ CREATE TABLE IF NOT EXISTS `statistic_meta` (
`statistic_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'statistic id',
`statistic_name` VARCHAR(128) NOT NULL COMMENT 'statistic name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `statistic_value` MEDIUMTEXT NOT NULL COMMENT 'statistic value',
+ `statistic_value` CLOB NOT NULL COMMENT 'statistic value',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'statistic audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'statistic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'statistic
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'statistic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'statistic
deleted at',
@@ -403,9 +403,9 @@ CREATE TABLE IF NOT EXISTS `job_template_meta` (
`job_template_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'job template id',
`job_template_name` VARCHAR(128) NOT NULL COMMENT 'job template name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `job_template_comment` TEXT DEFAULT NULL COMMENT 'job template comment',
- `job_template_content` MEDIUMTEXT NOT NULL COMMENT 'job template content',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'job template audit info',
+ `job_template_comment` CLOB DEFAULT NULL COMMENT 'job template comment',
+ `job_template_content` CLOB NOT NULL COMMENT 'job template content',
+ `audit_info` CLOB NOT NULL COMMENT 'job template audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job template
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job template last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job template
deleted at',
@@ -420,7 +420,7 @@ CREATE TABLE IF NOT EXISTS `job_run_meta` (
`job_execution_id` varchar(256) NOT NULL COMMENT 'job execution id',
`job_run_status` varchar(64) NOT NULL COMMENT 'job run status',
`job_finished_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job
finished at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'job run audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'job run audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job run current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job run last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job run
deleted at',
diff --git a/scripts/h2/upgrade-0.6.0-to-0.7.0-h2.sql
b/scripts/h2/upgrade-0.6.0-to-0.7.0-h2.sql
index 4143b7ad6f..8d3c173e35 100644
--- a/scripts/h2/upgrade-0.6.0-to-0.7.0-h2.sql
+++ b/scripts/h2/upgrade-0.6.0-to-0.7.0-h2.sql
@@ -26,14 +26,14 @@ CREATE TABLE IF NOT EXISTS `table_column_version_info` (
`column_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'column id',
`column_name` VARCHAR(128) NOT NULL COMMENT 'column name',
`column_position` INT UNSIGNED NOT NULL COMMENT 'column position, starting
from 0',
- `column_type` TEXT NOT NULL COMMENT 'column type',
+ `column_type` CLOB NOT NULL COMMENT 'column type',
`column_comment` VARCHAR(256) DEFAULT '' COMMENT 'column comment',
`column_nullable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'column nullable,
0 is not nullable, 1 is nullable',
`column_auto_increment` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'column auto
increment, 0 is not auto increment, 1 is auto increment',
- `column_default_value` TEXT DEFAULT NULL COMMENT 'column default value',
+ `column_default_value` CLOB DEFAULT NULL COMMENT 'column default value',
`column_op_type` TINYINT(1) NOT NULL COMMENT 'column operation type, 1 is
create, 2 is update, 3 is delete',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'column
deleted at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'column audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'column audit info',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tid_ver_cid_del` (`table_id`, `table_version`, `column_id`,
`deleted_at`),
KEY `idx_tcmid` (`metalake_id`),
diff --git a/scripts/h2/upgrade-0.7.0-to-0.8.0-h2.sql
b/scripts/h2/upgrade-0.7.0-to-0.8.0-h2.sql
index 5cf0dfbf6e..9f52fcd738 100644
--- a/scripts/h2/upgrade-0.7.0-to-0.8.0-h2.sql
+++ b/scripts/h2/upgrade-0.7.0-to-0.8.0-h2.sql
@@ -16,8 +16,8 @@
-- specific language governing permissions and limitations
-- under the License.
--
-ALTER TABLE `role_meta_securable_object` ALTER COLUMN `privilege_names`
TEXT(81920);
-ALTER TABLE `role_meta_securable_object` ALTER COLUMN `privilege_conditions`
TEXT(81920);
+ALTER TABLE `role_meta_securable_object` ALTER COLUMN `privilege_names`
CLOB(81920);
+ALTER TABLE `role_meta_securable_object` ALTER COLUMN `privilege_conditions`
CLOB(81920);
CREATE TABLE IF NOT EXISTS `model_meta` (
`model_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'model id',
@@ -25,10 +25,10 @@ CREATE TABLE IF NOT EXISTS `model_meta` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`catalog_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'catalog id',
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
- `model_comment` TEXT DEFAULT NULL COMMENT 'model comment',
- `model_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model properties',
+ `model_comment` CLOB DEFAULT NULL COMMENT 'model comment',
+ `model_properties` CLOB DEFAULT NULL COMMENT 'model properties',
`model_latest_version` INT UNSIGNED DEFAULT 0 COMMENT 'model latest
version',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'model audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model deleted
at',
PRIMARY KEY (`model_id`),
UNIQUE KEY `uk_sid_mn_del` (`schema_id`, `model_name`, `deleted_at`),
@@ -43,10 +43,10 @@ CREATE TABLE IF NOT EXISTS `model_version_info` (
`schema_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'schema id',
`model_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'model id',
`version` INT UNSIGNED NOT NULL COMMENT 'model version',
- `model_version_comment` TEXT DEFAULT NULL COMMENT 'model version comment',
- `model_version_properties` MEDIUMTEXT DEFAULT NULL COMMENT 'model version
properties',
- `model_version_uri` TEXT NOT NULL COMMENT 'model storage uri',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'model version audit info',
+ `model_version_comment` CLOB DEFAULT NULL COMMENT 'model version comment',
+ `model_version_properties` CLOB DEFAULT NULL COMMENT 'model version
properties',
+ `model_version_uri` CLOB NOT NULL COMMENT 'model storage uri',
+ `audit_info` CLOB NOT NULL COMMENT 'model version audit info',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'model version
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_mid_ver_del` (`model_id`, `version`, `deleted_at`),
diff --git a/scripts/h2/upgrade-0.9.0-to-1.0.0-h2.sql
b/scripts/h2/upgrade-0.9.0-to-1.0.0-h2.sql
index 6bd4161e49..e019d59129 100644
--- a/scripts/h2/upgrade-0.9.0-to-1.0.0-h2.sql
+++ b/scripts/h2/upgrade-0.9.0-to-1.0.0-h2.sql
@@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `policy_meta` (
`policy_name` VARCHAR(128) NOT NULL COMMENT 'policy name',
`policy_type` VARCHAR(64) NOT NULL COMMENT 'policy type',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'policy audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'policy audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
deleted at',
@@ -35,9 +35,9 @@ CREATE TABLE IF NOT EXISTS `policy_version_info` (
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
`policy_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'policy id',
`version` INT UNSIGNED NOT NULL COMMENT 'policy info version',
- `policy_comment` TEXT DEFAULT NULL COMMENT 'policy info comment',
+ `policy_comment` CLOB DEFAULT NULL COMMENT 'policy info comment',
`enabled` TINYINT(1) DEFAULT 1 COMMENT 'whether the policy is enabled, 0
is disabled, 1 is enabled',
- `content` MEDIUMTEXT DEFAULT NULL COMMENT 'policy content',
+ `content` CLOB DEFAULT NULL COMMENT 'policy content',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
deleted at',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_pod_ver_del` (`policy_id`, `version`, `deleted_at`),
@@ -49,7 +49,7 @@ CREATE TABLE IF NOT EXISTS `policy_relation_meta` (
`policy_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'policy id',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'policy relation audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'policy relation audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy relation
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'policy relation
last version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'policy
relation deleted at',
@@ -71,10 +71,10 @@ CREATE TABLE IF NOT EXISTS `statistic_meta` (
`statistic_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'statistic id',
`statistic_name` VARCHAR(128) NOT NULL COMMENT 'statistic name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `statistic_value` MEDIUMTEXT NOT NULL COMMENT 'statistic value',
+ `statistic_value` CLOB NOT NULL COMMENT 'statistic value',
`metadata_object_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metadata object
id',
`metadata_object_type` VARCHAR(64) NOT NULL COMMENT 'metadata object type',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'statistic audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'statistic audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'statistic
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'statistic last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'statistic
deleted at',
@@ -88,9 +88,9 @@ CREATE TABLE IF NOT EXISTS `job_template_meta` (
`job_template_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'job template id',
`job_template_name` VARCHAR(128) NOT NULL COMMENT 'job template name',
`metalake_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'metalake id',
- `job_template_comment` TEXT DEFAULT NULL COMMENT 'job template comment',
- `job_template_content` MEDIUMTEXT NOT NULL COMMENT 'job template content',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'job template audit info',
+ `job_template_comment` CLOB DEFAULT NULL COMMENT 'job template comment',
+ `job_template_content` CLOB NOT NULL COMMENT 'job template content',
+ `audit_info` CLOB NOT NULL COMMENT 'job template audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job template
current version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job template last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job template
deleted at',
@@ -105,7 +105,7 @@ CREATE TABLE IF NOT EXISTS `job_run_meta` (
`job_execution_id` varchar(256) NOT NULL COMMENT 'job execution id',
`job_run_status` varchar(64) NOT NULL COMMENT 'job run status',
`job_finished_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job
finished at',
- `audit_info` MEDIUMTEXT NOT NULL COMMENT 'job run audit info',
+ `audit_info` CLOB NOT NULL COMMENT 'job run audit info',
`current_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job run current
version',
`last_version` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'job run last
version',
`deleted_at` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'job run
deleted at',
