CREATE TABLE `alert_logging` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` bigint(20) NOT NULL default '0',
  `type` varchar(16) NOT NULL default '',
  `tag_id` varchar(24) NOT NULL,
  `mnemonic` varchar(36) NOT NULL,
  `location_str` varchar(36) NOT NULL,
  `category_str` varchar(36) NOT NULL,
  `upper_limit_alert` double NOT NULL default '0',
  `upper_limit` double NOT NULL default '0',
  `lower_limit` double NOT NULL default '0',
  `lower_limit_alert` double NOT NULL default '0',
  `measured_value` double NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1190 DEFAULT CHARSET=latin1;