CREATE TABLE `bus_inport`
(
`id`
int(11) NOT NULL AUTO_INCREMENT
,
`paytype`
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
,
`inporttime`
datetime(0) NULL DEFAULT NULL
,
`operateperson`
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
,
`number`
int(11) NULL DEFAULT NULL
,
`remark`
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
,
`inportprice`
double NULL DEFAULT NULL
,
`providerid`
int(11) NULL DEFAULT NULL
,
`goodsid`
int(11) NULL DEFAULT NULL
,
PRIMARY KEY
(`id`
) USING BTREE
,
INDEX `FK_1o4bujsyd2kl4iqw48fie224v`
(`providerid`
) USING BTREE
,
INDEX `FK_ho29poeu4o2dxu4rg1ammeaql`
(`goodsid`
) USING BTREE
,
CONSTRAINT `bus_inport_ibfk_1` FOREIGN KEY
(`providerid`
) REFERENCES `bus_provider`
(`id`
) ON DELETE RESTRICT ON UPDATE RESTRICT
,
CONSTRAINT `bus_inport_ibfk_2` FOREIGN KEY
(`goodsid`
) REFERENCES `bus_goods`
(`id`
) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE
= InnoDB AUTO_INCREMENT
= 17 CHARACTER SET
= utf8 COLLATE
= utf8_general_ci ROW_FORMAT
= Dynamic
;
为什么复制都会出错，。。知道的请指教一下
datetime(0) 全部替换成datetime 然后就 再有就是版本低了，5.7±-------》》》》
