CREATE TABLE `tbldata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `temperature` decimal(10,0) DEFAULT NULL,
  `used` char(1) DEFAULT 'N',
  `dateCreation` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1