DROP TABLE IF EXISTS `audit_trail`;
CREATE TABLE `audit_trail` (
  `action_id` int NOT NULL AUTO_INCREMENT,
  `action_type` int NOT NULL,
  `user_id` int NOT NULL,
  `user_type` int NOT NULL DEFAULT '1',
  `action_timestamp` datetime NOT NULL,
  PRIMARY KEY (`action_id`)
);