Installation

CREATE TABLE IF NOT EXISTS possible_gang_mdt (    id INT AUTO_INCREMENT PRIMARY KEY,    gang_name VARCHAR(50) NOT NULL,    strikes INT DEFAULT 0,    strike_logs TEXT DEFAULT '[]',    last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,    UNIQUE KEY unique_gang (gang_name));
CREATE TABLE IF NOT EXISTS `gang_cooldowns` (    `id` int(11) NOT NULL AUTO_INCREMENT,    `citizenid` varchar(50) NOT NULL,    `left_gang` varchar(50) NOT NULL,    `left_at` BIGINT NOT NULL,    PRIMARY KEY (`id`),    UNIQUE KEY `citizenid` (`citizenid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `gang_permissions` (    `id` INT AUTO_INCREMENT PRIMARY KEY,    `gang_name` VARCHAR(50) NOT NULL,    `grade_level` INT NOT NULL DEFAULT 0,    `open_gang_stash` TINYINT(1) NOT NULL DEFAULT 0,    `open_turf_shop` TINYINT(1) NOT NULL DEFAULT 0,    `open_territory_stash` TINYINT(1) NOT NULL DEFAULT 0,    `manage_members` TINYINT(1) NOT NULL DEFAULT 0,    `manage_territories` TINYINT(1) NOT NULL DEFAULT 0,    `manage_wars` TINYINT(1) NOT NULL DEFAULT 0,    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,    UNIQUE KEY `unique_gang_grade` (`gang_name`, `grade_level`),    INDEX `idx_gang_name` (`gang_name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;