Database SQL

CREATE TABLE IF NOT EXISTS duty_hours (
    discord_id VARCHAR(255) NOT NULL PRIMARY KEY,
    department VARCHAR(255) NOT NULL,
    total_time INT DEFAULT 0,
    last_updated INT UNSIGNED NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS active_users (
    discord_id VARCHAR(255) NOT NULL PRIMARY KEY,
    department VARCHAR(255) NOT NULL,
    last_clock_in DATETIME,
    location VARCHAR(255)
);

CREATE TABLE `duty_hours_archive` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `discord_id` VARCHAR(255) NOT NULL,
  `department` VARCHAR(100) NOT NULL,
  `total_time` INT(11) DEFAULT 0,
  `last_updated` INT(11) DEFAULT NULL,
  `archive_date` VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX (`discord_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `suspended_users` (
    `discord_id` VARCHAR(255) NOT NULL,
    `release_time` INT(11) NOT NULL,
    PRIMARY KEY (`discord_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `suspension_history` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `discord_id` VARCHAR(255) NOT NULL,
    `reason` TEXT NOT NULL,
    `issued_by` VARCHAR(255) NOT NULL,
    `duration` VARCHAR(100) DEFAULT NULL,
    `issued_at` INT(11) NOT NULL,
    `expires_at` INT(11) NOT NULL,
    PRIMARY KEY (`id`),
    INDEX `idx_user` (`discord_id`),
    INDEX `idx_staff` (`issued_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;