-- ---------------------------------------------
-- Create table for UM high tcode usage settings
-- ---------------------------------------------
CREATE TABLE IF NOT EXISTS `um_dash_settings_high_usage` (
  `system` VARCHAR(8) NOT NULL,
  `client` VARCHAR(3) NOT NULL,
  `collect_hits` TINYINT NULL,
  retention INT NULL,
  minimum_threshold INT NULL,
  minimum_dynpro INT NULL,
  default_threshold INT NULL,
  default_dynpro INT NULL,
  default_days INT NULL,
  notifications_send TINYINT NULL,
  notifications_regardless TINYINT NULL,
  notifications_interval INT NULL,
  notifications_emails TEXT NULL,
PRIMARY KEY (`system`, `client`));