text: 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'