-- ------------------------------------------------
-- New table for role counts per license category
-- Created 20130506
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_dash_roles_per_license_category` (
  `date` date NOT NULL,
  `category_id` int(10) NOT NULL,
  `category` varchar(120),
  `count_roles` int(10) NOT NULL,
  PRIMARY KEY (`date`,`category_id`)
) ENGINE=InnoDB;

