CREATE TABLE `datasync` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `opdate` datetime NULL DEFAULT NULL COMMENT '操作日期' , `opfun` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作功能', `state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态', UNIQUE INDEX `datasync_pk` (`id`) USING BTREE ) ENGINE=InnoDB ROW_FORMAT=COMPACT