mysql用federated引擎建表因为有json格式的字段导致建表失败应该咋解决啊
CREATE SERVER fedlink_entry
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'xxx', PASSWORD 'xxx',HOST 'xxx', PORT 3306, DATABASE 'dcim4_xhbx');
DROP TABLE IF EXISTS om_on_inspection_entry;
CREATE TABLE om_on_inspection_entry (ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,ENTRY_NAME varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工单名称',PLAN_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检计划主键',TEMP_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模板主键',ROOM_ID_S json NULL COMMENT '机房主键',USER_CONSULT json NULL COMMENT '可查看人',ENTRY_USER_CONSULT json NULL COMMENT '可巡检人',ENTRY_USER_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实际巡检人',PLAN_START_DATE datetime NULL DEFAULT NULL COMMENT '计划开始日期',PLAN_END_DATE datetime NULL DEFAULT NULL COMMENT '计划结束日期',ENTRY_START_DATE datetime NULL DEFAULT NULL COMMENT '工单开始日期',ENTRY_END_DATE datetime NULL DEFAULT NULL COMMENT '工单结束时间',ENTRY_STATUS char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工单状态 0未巡检 1 巡检中 2已完成 3 逾期完成 4 逾期',RESULT_ALL int(11) NULL DEFAULT NULL COMMENT '所有内容数量',RESULT_ABNORMAL int(11) NULL DEFAULT NULL COMMENT '异常内容数量',RESULT_NORMAL int(11) NULL DEFAULT NULL COMMENT '正常内容数量',RESULT_HANDLE int(11) NULL DEFAULT NULL COMMENT '已处理内容数量',CREATE_BY varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,ACTIVE_FLAG int(11) NOT NULL,UPDATE_BY varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,CREATE_DATE datetime NOT NULL,UPDATE_DATE datetime NULL DEFAULT NULL,
PRIMARY KEY (ID) USING BTREE
)
ENGINE=FEDERATED
CONNECTION='fedlink_entry/om_on_inspection_entry';
创建成功后表打不开
