CREATE TABLE IF NOT EXISTS env_system_dev
.sys_access_type
(
id
BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
type_name
VARCHAR(135) NOT NULL COMMENT '接入类型名称',
create_user
INT NULL COMMENT '创建者',
update_user
INT NULL COMMENT '更新者',
create_time
datetimev2 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time
datetimev2 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
description
VARCHAR(384) NULL COMMENT '描述',
is_delete
TINYINT NOT NULL DEFAULT "0" COMMENT '是否已删除,0:未删除,1:已删除'
) ENGINE=OLAP
UNIQUE KEY(id
)
COMMENT '系统接入类型表'
DISTRIBUTED BY HASH(id
) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);