CREATE TABLE `analytics` (
	`aID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`aType` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8_bin',
	`aIpAddress` BINARY(64) NULL DEFAULT NULL,
	`aUrlPath` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_bin',
	`aUrlParameters` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_bin',
	`aErrorMessage` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_bin',
	`aSubmission` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_bin',
	`aTimestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`aID`)
)
COLLATE='utf8_bin'