Miscellany

public text v1 · immutable

#1627396

·published 2009-10-18 16:57 UTC

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