DROP TABLE IF EXISTS `t_meterorigvalue`;
CREATE TABLE `t_meterorigvalue` (
`ID` int(18) NOT NULL AUTO_INCREMENT ,
`F_OrigValueID` varchar(32) DEFAULT NULL,
`F_BuildID` varchar(16) DEFAULT NULL ,
`F_GateWayID` varchar(2) DEFAULT NULL ,
`F_MeterParamID` varchar(50) DEFAULT NULL ,
`F_MeterID` smallint(6) DEFAULT NULL ,
`F_Address` varchar(16) DEFAULT NULL ,
`F_FunctionID` smallint(6) DEFAULT NULL ,
`F_OrigValue` varchar(32) DEFAULT NULL ,
`F_CollectTime` datetime NOT NULL ,
`F_ReceiveTime` datetime DEFAULT NULL ,
`F_OrigStaCode` varchar(8) DEFAULT NULL,
`F_OrigErrCode` varchar(8) DEFAULT NULL ,
`F_MeterType` smallint(6) DEFAULT NULL,
`F_PackType` smallint(6) DEFAULT NULL ,
`F_ContinusHandle` smallint(6) DEFAULT NULL ,
`F_CalcTime` datetime DEFAULT NULL ,
`F_State` smallint(6) DEFAULT NULL ,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=115169 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (month(F_CollectTime)) (
PARTITION p0 VALUES LESS THAN (1) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (2) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (3) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (4) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN (5) ENGINE = InnoDB,
PARTITION p5 VALUES LESS THAN (6) ENGINE = InnoDB,
PARTITION p6 VALUES LESS THAN (7) ENGINE = InnoDB,
PARTITION p7 VALUES LESS THAN (8) ENGINE = InnoDB,
PARTITION p8 VALUES LESS THAN (9) ENGINE = InnoDB,
PARTITION p9 VALUES LESS THAN (10)ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (11) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN MAXVALUE
)*/;
`ID` int(18) NOT NULL AUTO_INCREMENT
PRIMARY KEY (`ID`)
加上这个就会报错