CREATE TABLE `eventlog` (
	`guid` CHAR(34) NOT NULL COMMENT 'Event GUID',
	`timestamp_raw` BIGINT(20) UNSIGNED NOT NULL COMMENT 'UNIX epoch in milliseconds',
	`timestamp_d` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp (human-readable)',
	`player_name` VARCHAR(20) NOT NULL COMMENT 'Event origin name',
	`player_guid` CHAR(34) NOT NULL COMMENT 'Event origin GUID',
	`loc1_name` VARCHAR(128) NULL DEFAULT NULL COMMENT 'Loc1 name',
	`loc1_guid` CHAR(35) NULL DEFAULT NULL COMMENT 'Loc1 GUID',
	`event_action` ENUM('CAPTURE','LINK','FIELD') NULL DEFAULT NULL COMMENT 'Event action',
	`plaintext` TEXT NOT NULL COMMENT 'Event plaintext',
	PRIMARY KEY (`guid`),
	INDEX `timeline` (`timestamp_raw`),
	INDEX `player_name_key` (`player_name`),
	INDEX `portal1_name_key` (`loc1_name`),
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;