-- ------------------------------------------------
-- Maintain pre-calculated validity dates for 
-- usage data
-- Created 20131101
-- ------------------------------------------------

CREATE  TABLE `um_usage_dates_min_max` (
  `system` CHAR(8) NOT NULL ,
  `client` CHAR(3) NOT NULL ,
  `min` DATE NOT NULL ,
  `max` DATE NOT NULL ,
  PRIMARY KEY (`system`, `client`)
);

CREATE  TABLE `um_usage_dates_disabled` (
  `system` CHAR(8) NOT NULL ,
  `client` CHAR(3) NOT NULL ,
  `date` DATE NOT NULL ,
  PRIMARY KEY (`system`, `client`, `date`)
);
