去除DEFAULT CURRENT_TIMESTAMP该项即可成功导入
如果是ON UPDATE CURRENT_TIMESTAMP 这个,一起删除
-- ----------------------------
-- Table structure for `order_charges_detail`
-- ----------------------------
DROP TABLE IF EXISTS `order_charges_detail` ;
CREATE TABLE `order_charges_detail` (
`id` int (11 ) NOT NULL AUTO_INCREMENT,
`car_order_id` bigint(20 ) NOT NULL COMMENT '订单id' ,
`overplus_capital` decimal (10 ,2 ) DEFAULT NULL COMMENT '剩余未还本金' ,
`new_interest` decimal (10 ,2 ) DEFAULT NULL COMMENT '今日产生利息' ,
`exceed` decimal (10 ,0 ) DEFAULT NULL COMMENT '产生的逾期费' ,
`make_date` date NOT NULL COMMENT '费用产生日期' ,
`create_date` datetime NOT NULL **DEFAULT CURRENT_TIMESTAMP ** COMMENT '产生时间' ,
PRIMARY KEY (`id` ),
KEY `FK_7myj6292pytjkquub43qkgdes` (`car_order_id` ),
CONSTRAINT `FK_7myj6292pytjkquub43qkgdes` FOREIGN KEY (`car_order_id` ) REFERENCES `car_order` (`id` )
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='订单每日产生费用明细表' ;