CREATE TABLE `n_eventlog` (
	`eid` BIGINT(20) UNSIGNED NOT NULL COMMENT 'Event Mapped-ID',
	`timestamp_raw` BIGINT(20) UNSIGNED NOT NULL COMMENT 'UNIX epoch in milliseconds',
	`event_faction` ENUM('ALIENS','RESISTANCE') NOT NULL COMMENT 'Event faction',
	`origin_type` ENUM('PLAYER','SENDER','SECURE') NOT NULL COMMENT 'Event origin type',
	`pid` INT(10) UNSIGNED NOT NULL COMMENT 'Originating Player Mapped-ID',
	`player_faction` ENUM('ALIENS','RESISTANCE') NOT NULL COMMENT 'Originating player faction',
	`loc1_id` INT(10) UNSIGNED NULL DEFAULT NULL COMMENT 'Location 1 Mapped-ID',
	`loc1_lat` DECIMAL(9,6) NULL DEFAULT NULL COMMENT 'Location 1 latitude',
	`loc1_lng` DECIMAL(9,6) NULL DEFAULT NULL COMMENT 'Location 1 longitude',
	`loc2_id` INT(10) UNSIGNED NULL DEFAULT NULL COMMENT 'Location 2 Mapped-ID',
	`loc2_lat` DECIMAL(9,6) NULL DEFAULT NULL COMMENT 'Location 2 latitude',
	`loc2_lng` DECIMAL(9,6) NULL DEFAULT NULL COMMENT 'Location 2 longitude',
	`event_action` ENUM('CAPTURE','LINK','FIELD','NOLINK','NOFIELD','FRACKER','BEACON') NULL DEFAULT NULL COMMENT 'Event action',
	`deltaMU` BIGINT(20) NOT NULL DEFAULT '0' COMMENT 'Delta MU',
	`event_type` ENUM('PLAYER_GENERATED','SYSTEM_BROADCAST') NOT NULL COMMENT 'Event type',
	`event_category` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Event category',
	PRIMARY KEY (`eid`),
	INDEX `key_pid` (`pid`),
	INDEX `key_loc1_id` (`loc1_id`),
	INDEX `key_loc2_id` (`loc2_id`),
	INDEX `timeline` (`timestamp_raw`)
)
COMMENT='Global event log (normalized)'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;

CREATE TABLE `idmap_players` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Mapped ID',
	`guid` BINARY(16) NOT NULL COMMENT 'Related GUID',
	`name` VARCHAR(20) NOT NULL COMMENT 'Related NAME',
	PRIMARY KEY (`id`),
	UNIQUE INDEX `key_player` (`guid`, `name`)
)
COMMENT='Contains ID to GUID+name map for players'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=1
;