CREATE TABLE `wi_measure` (
  `value` int(11) DEFAULT NULL,
  `unit` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `mantissa` int(11) DEFAULT NULL,
  `exponent` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `meastime` timestamp NULL,
  `recvtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ;