CREATE TABLE `document_log` (
  `document_log_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(11) unsigned DEFAULT NULL,
  `action_date` datetime NOT NULL,
  `action` text NOT NULL,
  PRIMARY KEY (`document_log_id`),
  KEY `document_id` (`document_id`),
  CONSTRAINT `document_log_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `document` (`document_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
