· 8 years ago · Feb 19, 2018, 04:08 PM
1DROP TABLE IF EXISTS `staff_logs`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `staff_logs` (
5 `case_id` int(11) NOT NULL AUTO_INCREMENT,
6 `staffn` varchar(50) NOT NULL,
7 `personr` varchar(50) NOT NULL,
8 `personbr` varchar(50) NOT NULL,
9 `playerid` varchar(64) NOT NULL,
10 `report` varchar(100) NOT NULL,
11 `outcome` varchar(255) NOT NULL,
12 `staff_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
13 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
14 PRIMARY KEY (`case_id`),
15 UNIQUE KEY `case_id` (`case_id`)
16) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;