mysql迁移达梦迁移非法的基类名JSON 求大佬解答

最新推荐文章于 2024-08-07 12:00:15 发布

m0_65880409

最新推荐文章于 2024-08-07 12:00:15 发布

阅读量540

点赞数

文章标签： mysql json android

本文链接：https://blog.csdn.net/m0_65880409/article/details/133812784

版权

错误号: -3719

错误消息: 第25 行附近出现错误:
非法的基类名[JSON]

---------------------------------
CREATE TABLE "SYSDBA"."T_AMP_PPW_ALLOT_ORDER"
(
"ID" BIGINT NOT NULL,
"SERIAL_NUMBER" VARCHAR(30) NULL,
"OUT_ORDER_ID" BIGINT NULL,
"IN_ORDER_ID" BIGINT NULL,
"INSTITUTION_ID" BIGINT NULL,
"FROM_WAREHOUSE_ID" BIGINT NULL,
"TO_WAREHOUSE_ID" BIGINT NULL,
"OPERATE_DATE" TIMESTAMP(0) NULL,
"ORDER_TYPE" INT NULL,
"MATERIAL_TYPE" INT NULL,
"REMARK" VARCHAR(1000) NULL,
"STATUS" INT NULL,
"ATTACHMENT" JSON NULL,
"CONTACT_NAME" VARCHAR(100) NULL,
"CONTACT_WAY" VARCHAR(100) NULL,
"CREATE_BY_ID" BIGINT NULL,
"CREATE_BY_NAME" VARCHAR(30) NULL,
"CREATE_BY_TIME" TIMESTAMP(0) NULL,
"UPDATE_BY_ID" BIGINT NULL,
"UPDATE_BY_NAME" VARCHAR(30) NULL,
"UPDATE_BY_TIME" TIMESTAMP(0) NULL,
"DELETE_FLAG" INT NULL
)