-- ------------------------------------------------------- --
-- APM-2786
-- UM, Usage mapping
-- Adding table to contain the mapping
-- ------------------------------------------------------- --
CREATE TABLE `um_usage_mapping` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `system` CHAR(3) NOT NULL,
  `client` CHAR(3) NOT NULL,
  `transaction` VARCHAR(40) NULL,
  `program` VARCHAR(40) NULL,
  `type` VARCHAR(1) NULL,
  `mapped_transaction` VARCHAR(40) NULL,
  `mapped_program` VARCHAR(40) NULL,
  `mapped_type` VARCHAR(1) NULL,
  `username` VARCHAR(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
	