Installation
Last updated
CREATE TABLE `jail_history` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`player_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`staff_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`time` INT(11) NOT NULL,
`reason` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
`remaining_time` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4;
CREATE TABLE `players_jail` (
`player_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`remaining_time` INT(11) NOT NULL,
PRIMARY KEY (`player_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;