CREATE TABLE `ticket_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `action_source` tinyint(4) NOT NULL,
  `action_type` tinyint(4) NOT NULL,
  `action_by` int(11) NOT NULL,
  `action_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_action_idx` (`ticket_id`,`action_type`),
  KEY `usr_idx` (`action_by`)
) ENGINE=InnoDB AUTO_INCREMENT=136933 DEFAULT CHARSET=utf8