-- ---------------------- --
-- APM-2786
-- UM, Usage mapping
-- Tables for usage types
-- ---------------------- --
CREATE TABLE IF NOT EXISTS `um_usage_type` (
	`system` CHAR(3) NOT NULL,
	`client` CHAR(3) NOT NULL,
	`type` char(1) NOT NULL COLLATE utf8mb4_bin,
	`description` tinytext NULL,
	PRIMARY KEY (`system`, `client`, `type`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `um_usage_type_selected` (
	`system` varchar(8) NOT NULL,
	`client` varchar(3) NOT NULL,
	`type` CHAR(1) NOT NULL COLLATE utf8mb4_bin,
	PRIMARY KEY (`system`, `client`, `type`)
) DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci;