Robware/DB Scripts/9/create_temperature_log.sql

CREATE TABLE `temperature_log` (
  `temperature_id` int(11) NOT NULL AUTO_INCREMENT,
  `reading` float NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`temperature_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;