· 6 years ago · Aug 20, 2019, 10:26 PM
1CREATE TABLE IF NOT EXISTS kick_punishments (`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `player` VARCHAR(100), `punisher` VARCHAR(100), `reason` TEXT, `date_time` DATETIME, `expiration_date_time` DATETIME, `status` VARCHAR(20));
2CREATE TABLE IF NOT EXISTS ban_punishments (`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `player` VARCHAR(100), `punisher` VARCHAR(100), `reason` TEXT, `date_time` DATETIME, `expiration_date_time` DATETIME, `status` VARCHAR(20));
3CREATE TABLE IF NOT EXISTS mute_punishments (`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `player` VARCHAR(100), `punisher` VARCHAR(100), `reason` TEXT, `date_time` DATETIME, `expiration_date_time` DATETIME, `status` VARCHAR(20));
4CREATE TABLE IF NOT EXISTS jail_punishments (`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `player` VARCHAR(100), `punisher` VARCHAR(100), `reason` TEXT, `date_time` DATETIME, `expiration_date_time` DATETIME, `status` VARCHAR(20));