PHFd1Wyr

1CREATE TABLE IF NOT EXISTS `monitor` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4  `serra` varchar(10) NOT NULL,
5  `temp` float NOT NULL,
6  `umidita` float NOT NULL,
7  `luce` int(11) NOT NULL,
8  `piante` int(11) NOT NULL,
9  PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;