ALTER TABLE `temperature_log` CHANGE `reading` `inside` FLOAT NOT NULL ; ALTER TABLE `temperature_log` ADD `outside` FLOAT NOT NULL AFTER `inside` ;