CREATE TABLE `staff_logs` (
  `case_id` int(11) NOT NULL AUTO_INCREMENT,
  `staffn` varchar(50) NOT NULL,
  `personr` varchar(50) NOT NULL,
  `personbr` varchar(50) NOT NULL,
  `playerid` varchar(50) NOT NULL,
  `report` int(100) NOT NULL DEFAULT '0',
  `outcome` varchar(255) NOT NULL,
  `staff_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`case_id`),
  UNIQUE KEY `case_id` (`case_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;