CREATE TABLE reported (
  date datetime NOT NULL default '0000-00-00 00:00:00',
  value float NOT NULL default '0',
  rules text,
  UNIQUE KEY entries (date,value),
  KEY date (date)
);

CREATE TABLE syslog (
  date datetime NOT NULL default '0000-00-00 00:00:00',
  value float NOT NULL default '0'
);