-- ------------------------------------------------
-- Updated unused_tcodes dashboard table
-- Created 20141211
-- ------------------------------------------------

DROP TABLE IF EXISTS `um_dash_unused_tcodes`;

CREATE TABLE IF NOT EXISTS `um_dash_unused_tcodes` (
  `system` varchar(8) NOT NULL,
  `client` char(3) NOT NULL,
  `tcode_id` int(11) NOT NULL,
  `last_used_date` date,
  PRIMARY KEY (`system`, `client`, `tcode_id`)
);
