-- ------------------------------------------------
-- UM Dashboard history table for license counts.
-- Created 20130718
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_dash_license_alloc_history` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `date` date NOT NULL,
  `alloc_type` char(1) NOT NULL,
  `category_id` int(10) NOT NULL,
  `count` int(10) NOT NULL,
  `sum_cost` int(10) NOT NULL,
  PRIMARY KEY (`system`,`client`,`date`,`alloc_type`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
