CREATE TABLE IF NOT EXISTS `reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` mediumtext DEFAULT NULL,
`type` varchar(75) DEFAULT NULL,
`title` mediumtext DEFAULT NULL,
`description` longtext DEFAULT NULL,
`chat` longtext NOT NULL DEFAULT '{}',
`screenshot` longtext DEFAULT NULL,
`claimed` int(1) DEFAULT 0,
`claimedBy` longtext DEFAULT NULL,
`closed` int(1) DEFAULT 0,
`closedBy` longtext DEFAULT NULL,
`createdTime` varchar(50) DEFAULT NULL,
`closedTime` varchar(50) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `reports_statistics` (
`identifier` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`claimed` int(10) DEFAULT 0,
`closed` int(10) DEFAULT 0,
`sentmessages` int(10) DEFAULT 0,
`resolved_reports` int(10) DEFAULT 0,
UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;