DROP TABLE IF EXISTS ACGH
;
CREATE TABLE ACGH
(id
int(8) NOT NULL AUTO_INCREMENT COMMENT '主键ID',ifACGHCheckType
varchar(10) DEFAULT NULL COMMENT '是否已行aCGH检查---yes,no',ACGHCheckType
varchar(50) DEFAULT NULL COMMENT 'ACGH检查类型',ACGHCheckDate
varchar(20) DEFAULT NULL COMMENT 'ACGH检查日期',ACGHCheckCompany
varchar(50) DEFAULT NULL COMMENT 'ACGH送检公司',ACGHCheckResult
varchar(255) DEFAULT NULL COMMENT 'ACGH检查结果',ACGHFamilyVerificationResult
varchar(255) DEFAULT NULL COMMENT 'ACGH家系验证结果',geneticsId
int(8) DEFAULT NULL COMMENT '遗传学检查ID',patientId
varchar(50) NOT NULL COMMENT '遗传学检查ID',maketime
varchar(50) NOT NULL DEFAULT current_timestamp() COMMENT '创建时间',tableName
varchar(100) NOT NULL DEFAULT 'ACGH' COMMENT '表名',modelName
varchar(100) NOT NULL DEFAULT 'aCGH' COMMENT '模块名',
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='ACGH';
-- Records of ACGH
INSERT INTO ACGH
VALUES ('1', null, null, '2018-07-05', '阿斯达', '已出#的试试#否', '哒哒哒哒哒哒多多多多多多多多多多', null, '大士大夫似的', '2018-07-05 19:52:23', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('2', null, null, '', '', '结果未回', '', null, '大士大夫似的', '2018-07-09 09:19:47', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('3', null, null, '', '', '结果未回', '', null, '大士大夫似ç', '2018-07-10 08:34:58', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('6', null, null, '2018-07-11', 'dddd', '已出#dddddddd#是', 'dddddddddddddd', null, '123456789', '2018-07-11 15:51:46', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('7', null, null, '', '', '结果未回', '', null, '123456789', '2018-07-11 16:32:01', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('8', null, null, '2018-07-13', '88888888888', '已出#555#是', '888888888888888', null, 'test', '2018-07-13 16:09:40', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('10', null, null, '', '', '结果未回', '', null, '121212', '2018-07-26 14:22:16', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('11', null, null, '', '', '结果未回', '', null, '121212', '2018-07-26 15:35:35', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('12', null, null, '', '', '结果未回', '', null, '121212', '2018-07-26 15:57:40', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('13', null, null, '', '', '结果未回', '', null, '2323232', '2018-07-27 15:16:17', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('14', null, null, '2018-09-12', '', '结果未回', '', null, '201708888', '2018-09-04', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('15', null, null, '2018-09-12', '', '结果未回', '', null, '201708888', '2018-09-13', 'ACGH', 'aCGH');
INSERT INTO ACGH
VALUES ('16', '是', null, '2018-09-14', '4444444444', '结果未回', '44444444444444445', null, '123456789', '2018-09-15', 'ACGH', 'aCGH');
报下面这个错
[Err] 1067 - Invalid default value for 'maketime' 是怎么回事啊 请详细解决方案