Menu Admin V2

CREATE TABLE `yzgradestaff` (
  `id` int(11) NOT NULL,
  `grade_name` text NOT NULL,
  `grade` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `yzgradestaff`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `yzgradestaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

CREATE TABLE `yzjoueurstaff` (
  `id` int(11) NOT NULL,
  `license` text NOT NULL,
  `name` text NOT NULL,
  `grade_name` text NOT NULL,
  `grade` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `yzjoueurstaff`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `yzjoueurstaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
  
INSERT INTO yzjoueurstaff (license, name, grade_name, grade) VALUES
('license:xxxxxx', 'Yazho', 'Developpeur', '99');

INSERT INTO yzgradestaff (grade_name, grade) VALUES
('Developpeur', '99');

CREATE TABLE `yzbans` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `license` VARCHAR(255) NOT NULL,
  `reason` VARCHAR(255) NOT NULL,
  `expires_at` INT NOT NULL,
  `readable_time` DATETIME NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS yzbans_historique (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `license` VARCHAR(255) NOT NULL,
    `reason` TEXT NOT NULL,
    `duration` INT NOT NULL,
    `banned_at` DATETIME NOT NULL,
    `expires_at` DATETIME NOT NULL
);

CREATE TABLE IF NOT EXISTS yzkicks_historique (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `license` VARCHAR(255) NOT NULL,
    `reason` TEXT NOT NULL
);