-- ------------------------------------------------
-- UM Dash. extra table to show user-based
-- break-down by type and category
-- Created 20131008
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_dash_license_alloc` (
  `user_id` int(11) NOT NULL,
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `user` varchar(12) NOT NULL,
  `cat_s` int(10) DEFAULT NULL COMMENT 'License Category according to SU01',
  `cat_r` int(10) DEFAULT NULL COMMENT 'License Category according to roles',
  `cat_u` int(10) DEFAULT NULL COMMENT 'License Category according to usage',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `sys_cli_user` (`system`,`client`,`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

