*************************** 1. row ***************************
       Table: alarm_events
Create Table: CREATE TABLE `alarm_events` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `alarm_id_key` int(11) NOT NULL,
  `acknowledged` enum('yes','no') COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
  `certainty` float DEFAULT NULL,
  `LastAlarmType` char(32) COLLATE latin1_general_ci DEFAULT NULL,
  `state_change` enum('yes','no') COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
  `assigned_fault_id` int(11) DEFAULT NULL,
  `site_index` int(11) DEFAULT NULL,
  `fault_id` int(11) DEFAULT NULL,
  `risk_id` int(11) DEFAULT NULL,
  `damage_id` int(11) DEFAULT NULL,
  `FromTime` datetime DEFAULT NULL,
  `ToTime` datetime DEFAULT NULL,
  `LastTimeRed` datetime DEFAULT NULL,
  `LastTimeYellow` datetime DEFAULT NULL,
  `LastTimeBlue` datetime DEFAULT NULL,
  `CountRed` int(11) DEFAULT NULL,
  `CountYellow` int(11) DEFAULT NULL,
  `CountBlue` int(11) DEFAULT NULL,
  `MeasurementKey` varchar(128) COLLATE latin1_general_ci DEFAULT NULL,
  `ConditionKey` varchar(128) COLLATE latin1_general_ci DEFAULT NULL,
  `FaultFreq` double DEFAULT NULL,
  `FaultIntervalWidth` double DEFAULT NULL,
  `AlarmType` varchar(32) COLLATE latin1_general_ci DEFAULT NULL,
  `AckStatus` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`event_id`),
  UNIQUE KEY `event_id` (`event_id`),
  UNIQUE KEY `remote_primary_idx` (`site_index`,`alarm_id_key`),
  KEY `assigned_fault_idx` (`assigned_fault_id`)
) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci