CREATE TABLE adjust_shift_parameter_log (
OID varchar(40) NOT NULL COMMENT ‘日志ID’,
UnitId varchar(40) DEFAULT NULL COMMENT ‘组织ID’,
Desc varchar(8000) CHARACTER SET gb2312 DEFAULT NULL COMMENT ‘操作内容’,
Mode varchar(100) CHARACTER SET gb2312 DEFAULT NULL COMMENT ‘操作模式’,
LastUpdateUser varchar(40) CHARACTER SET gb2312 DEFAULT NULL COMMENT ‘最后更新人’,
LastUpdateTimeOffset float DEFAULT NULL,
LastUpdateTime datetime(3) DEFAULT NULL COMMENT ‘最后更新时间’,
LastUpdateTimeUtc datetime(3) DEFAULT NULL,
PRIMARY KEY (OID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=910 ROW_FORMAT=DYNAMIC
---------- error options ----------
information: [parser:1115]Unknown character set: ‘gb2312’
********** table wfmd3.optional_timeclass_detail **********
statement: CREATE TABLE optional_timeclass_detail (
Id varchar(40) NOT NULL COMMENT ‘主键’,
MainClassId varchar(40) DEFAULT ‘’ COMMENT ‘主表Id’,
ClassId varchar(40) DEFAULT ‘’ COMMENT ‘可选班Id’,
CreateTime datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
CreateUser varchar(50) DEFAULT ‘’ COMMENT ‘创建人’,
LastUpdateTime datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘最后更新时间’,
LastUpdateUser varchar(50) DEFAULT ‘’ COMMENT ‘最后更新人’,
PRIMARY KEY (Id),
KEY fk_main_calssid (MainClassId),
CONSTRAINT fk_main_calssid FOREIGN KEY (MainClassId) REFERENCES optional_timeclass_set (Id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=‘可选班别详细表’
---------- warning options ----------
information: Foreign Key fk_main_calssid is parsed but ignored by TiDB.
instruction: please ref document: https://github.com/pingcap/docs-cn/blob/master/sql/ddl.md\
",
