CREATE TABLE `meteo` ( `date_heure` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `temp` double NOT NULL, `pression` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;