-- --------------------------------------------- --
-- APM-2940 Dashboard Overhaul
-- Need table to save saved and deleted legacies
-- --------------------------------------------- --
CREATE TABLE IF NOT EXISTS `sod_dashboard_legacyhistory` (
  `date` date NOT NULL,
  `system` CHAR(3)  NOT NULL,
  `client` CHAR(3) NOT NULL,
  `added` int NOT NULL DEFAULT '0',
  `deleted` int NOT NULL DEFAULT '0',
  `found` int NOT NULL DEFAULT '0',
PRIMARY KEY (`date`,`system`,`client`));
  