CREATE TABLE IF NOT EXISTS `acsensorwerte` (
`id` bigint(11) NOT NULL,
  `gruppe` tinyint(4) NOT NULL,
  `sensorid` tinyint(4) NOT NULL,
  `led1` smallint(6) NOT NULL,
  `led2` smallint(6) NOT NULL,
  `nacht` smallint(6) NOT NULL,
  `licht_an` tinyint(4) NOT NULL,
  `co2_an` tinyint(4) NOT NULL,
  `heizer_an` tinyint(4) NOT NULL,
  `aquatemp` float NOT NULL,
  `airtemp` float NOT NULL,
  `pump1` smallint(6) NOT NULL,
  `pump2` smallint(6) NOT NULL,
  `pump3` smallint(6) NOT NULL,
  `pump4` smallint(6) NOT NULL,
  `datumzeit` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Messwerte';
