Bug: Compatibility issue with PostgreSQL when creating the 'MigrateEsIndexPatternTable' table

[qihang-sun]

Relevant server.conf | webapi.conf

postgre

Relevant logs

CREATE TABLE "es_index_pattern" ("id" bigserial,"datasource_id" bigint not null default '0',"name" varchar(191) not null default '',"time_field" varchar(128) not null default '',"allow_hide_system_indices" tinyint(1) not null default 0,"fields_format" varchar(4096) not null default '',"create_at" bigint  default '0',"create_by" varchar(64) default '',"update_at" bigint  default '0',"update_by" varchar(64) default '',PRIMARY KEY ("id"))CHARSET=utf8mb4
migrate/migrate_es_index_pattern.go:29 failed to migrate es index pattern table: ERROR: syntax error at or near "CHARSET" (SQLSTATE 42601)

System info

n9e v6.0.0

Steps to reproduce

1.启动时，pg数据库中如果不存在es_index_pattern这张表时，新建表失败，pgsql不支持这种设置字符集的方式，mysql无报错

Expected behavior

建表成功

Actual behavior

建表失败

Additional info

No response