Attachment 1448405 Details for Bug 1567344 – syslog_events

syslog_events

syslog_events.table.txt (text/plain), 1.46 KB, created by Rupesh Patel on 2018-06-06 18:07:18 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Rupesh Patel

Created: 2018-06-06 18:07:18 UTC

Size: 1.46 KB

patch

obsolete

>*************************** 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

Actions: View

Attachments on bug 1567344: 1448402 | 1448403 | 1448404 | 1448405 | 1448406