-- ------------------------------------------------
-- New table for user counts
-- Created 20130501
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `um_dash_user_counts` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `date` date NOT NULL,
  `count_total` int(10) NOT NULL,
  `count_open` int(10) NOT NULL,
  `count_locked` int(10) NOT NULL,
  `count_outofvalidity` int(10) NOT NULL,
  PRIMARY KEY (`system`,`client`,`date`)
) ENGINE=InnoDB;

