-- ----------------------------------
-- CREATE TABLE FOR LEGACY VIOLATIONS
-- ----------------------------------
CREATE TABLE IF NOT EXISTS `sod_legacy_violation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_id` int(11) NOT NULL,
  `username` varchar(12) NOT NULL,
  `system` varchar(8) NOT NULL,
  `client` varchar(3) NOT NULL,
  `causes_json` mediumtext,
  `created_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 