CREATE TABLE `def_events` (
`Block` char(36) NOT NULL DEFAULT 'ADHOC',
`EventGuid` char(255) NOT NULL DEFAULT '',
`Package` char(36) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT NULL,
`Changedby` char(255) DEFAULT NULL,
`EventParent` char(36) NOT NULL DEFAULT '',
`Rank` int(1) NOT NULL DEFAULT 0,
`Navigategroupguid` char(36) NOT NULL DEFAULT '',
`EventType` char(255) DEFAULT NULL,
`Company` char(255) NOT NULL DEFAULT 'TECHNOCORE',
`EventAction` mediumtext DEFAULT NULL,
`EventWaitTillComplete` char(1) NOT NULL DEFAULT '',
`NextEvent` char(255) DEFAULT NULL,
`EventState` char(255) DEFAULT NULL,
`EventCompletedCheckSql` mediumtext DEFAULT NULL,
`Datechanged` datetime DEFAULT NULL,
`DeleteMe` int(1) NOT NULL DEFAULT 0,
`EventSynchronous` char(1) NOT NULL DEFAULT 'Y',
PRIMARY KEY (`EventGuid`, `Block`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE IF NOT EXISTS `stage_events` (
`Guid` char(255) NOT NULL DEFAULT '0',
`EventGuid` char(255) NOT NULL DEFAULT '0',
`Navigategroupguid` char(255) NOT NULL DEFAULT '0',
`Status` char(50) DEFAULT '',
`StatusError` char(255) DEFAULT NULL,
`Response` mediumtext DEFAULT NULL,
`SourceTable` char(255) NOT NULL DEFAULT '',
`SourceStateColumn` char(255) NOT NULL DEFAULT '',
`SourceKeys` mediumtext DEFAULT NULL,
`SourceKeyVals` mediumtext DEFAULT NULL,
`ParsedFieldKeys` mediumtext DEFAULT NULL,
`ParsedFieldVals` mediumtext DEFAULT NULL,
`Param1` mediumtext DEFAULT NULL,
`Param2` mediumtext DEFAULT NULL,
`Param3` mediumtext DEFAULT NULL,
`Param4` mediumtext DEFAULT NULL,
`Param5` mediumtext DEFAULT NULL,
`Param6` mediumtext DEFAULT NULL,
`Param7` mediumtext DEFAULT NULL,
`Param8` mediumtext DEFAULT NULL,
`Param9` mediumtext DEFAULT NULL,
`Result1` mediumtext DEFAULT NULL,
`Result2` mediumtext DEFAULT NULL,
`Result3` mediumtext DEFAULT NULL,
`Result4` mediumtext DEFAULT NULL,
`Result5` mediumtext DEFAULT NULL,
`Result6` mediumtext DEFAULT NULL,
`Result7` mediumtext DEFAULT NULL,
`Result8` mediumtext DEFAULT NULL,
`Result9` mediumtext DEFAULT NULL,
`ReturnGuid` char(255) NOT NULL DEFAULT '',
`ReturnPid` int(11) NOT NULL DEFAULT 0,
`RDG` int(11) DEFAULT NULL,
`Thread` tinyint(4) DEFAULT 0,
`WorkerPid` int(11) NOT NULL DEFAULT 0,
`DispatcherName` char(255) DEFAULT NULL,
`DispatcherPid` int(11) NOT NULL DEFAULT 0,
`Instance` char(255) DEFAULT NULL,
`Nodename` char(255) DEFAULT NULL,
`Checkoutname` char(255) DEFAULT NULL,
`CPULoad` int(11) DEFAULT 0,
`MemoryLoad` int(11) DEFAULT 0,
`DiskLoad` int(11) DEFAULT 0,
`TimeScheduled` datetime DEFAULT NULL,
`TimeAdded` timestamp NULL DEFAULT current_timestamp(),
`TimeEntered` datetime DEFAULT current_timestamp(),
`TimeResheduled` int(11) DEFAULT 0,
`TimeThreaded` datetime DEFAULT NULL,
`TimeStarted` datetime DEFAULT NULL,
`TimeCompleted` datetime DEFAULT NULL,
PRIMARY KEY (`Guid`),
KEY `idx_status` (`Status`),
KEY `idx_timescheduled` (`TimeScheduled`),
KEY `idx_timecompleted` (`TimeCompleted`),
KEY `idx_eventguid` (`EventGuid`),
KEY `idx_thread` (`Thread`),
KEY `idx_navigategroupguid` (`Navigategroupguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE `track_events` (
`Guid` char(255) NOT NULL DEFAULT '',
`Package` char(36) NOT NULL DEFAULT 'ADHOC',
`SourceHost` char(255) NOT NULL DEFAULT '',
`EventContents` text NOT NULL,
`EventType` char(255) NOT NULL DEFAULT '',
`EventPackage` char(255) NOT NULL DEFAULT '',
`EventDate` char(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};