CREATE TABLE IF NOT EXISTS `dxbots_logs` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `discord_bot_id` VARCHAR(32) NOT NULL,
  `type` ENUM('info', 'success', 'warning', 'error') NOT NULL DEFAULT 'info',
  `executor_discord_id` VARCHAR(32) NULL,
  `action` TEXT NOT NULL,
  `timestamp` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX `idx_bot` (`discord_bot_id`),
  INDEX `idx_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
