*************************** 1. row ***************************
       Table: syslog_events
Create Table: CREATE TABLE `syslog_events` (
  `entry_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `site_index` bigint(20) NOT NULL,
  `site_syslog_id` bigint(20) DEFAULT NULL,
  `type_name` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `acknowledged` enum('yes','no') COLLATE latin1_general_ci DEFAULT 'no',
  `severity` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `location_serial` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `sub_path` text COLLATE latin1_general_ci,
  `from_time` datetime DEFAULT NULL,
  `to_time` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `count` bigint(20) DEFAULT NULL,
  `end_of_life` datetime DEFAULT NULL,
  `remind_on` datetime DEFAULT NULL,
  `state` enum('Active','Inactive','Event') COLLATE latin1_general_ci DEFAULT NULL,
  `ack_status` varchar(32) COLLATE latin1_general_ci DEFAULT NULL,
  `text` text COLLATE latin1_general_ci,
  `action_text` text COLLATE latin1_general_ci,
  `last_modification` datetime DEFAULT NULL,
  `guid` varchar(36) COLLATE latin1_general_ci DEFAULT NULL,
  `assigned_fault_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`entry_id`),
  UNIQUE KEY `guid` (`guid`),
  KEY `site_index_idx` (`site_index`),
  KEY `location_serial_idx` (`location_serial`),
  KEY `last_modified_inx_idx` (`site_index`,`last_modification`)
) ENGINE=MyISAM AUTO_INCREMENT=579 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci