-- ------------------------------------------------
-- um_dash_roles_by_type
-- Created 20130611
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_dash_roles_by_type` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `date` date NOT NULL,
  `count_composite` int(10) NOT NULL,
  `count_single` int(10) NOT NULL,
  `count_master` int(10) NOT NULL,
  `count_derived` int(10) NOT NULL,
  PRIMARY KEY (`system`,`client`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
