-- ---------------------------------------------------------------------
-- New table for new dashboard holding counts on warning type / reaction
-- ---------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `sod_dashboard_reactioncount` (
  `system` VARCHAR(8) NOT NULL,
  `client` VARCHAR(3) NOT NULL,
  `warning_type_id` INT NOT NULL,
  `count` INT NULL,
PRIMARY KEY (`system`, `client`, `warning_type_id`));