CREATE TABLE `pdulog` ( `id` int(10) unsigned NOT NULL auto_increment, `dtstamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `unit` int(10) unsigned default NULL, `kwh_total` int(10) default NULL, `kwh_display` int(10) default NULL, `current` decimal(8,1) default NULL, `temperature` int(3) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1929427 DEFAULT CHARSET=latin1