CREATE TABLE IF NOT EXISTS `voicesupport_logs` (
  `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
  `admin` VARCHAR(255) NOT NULL,
  `admin_id` VARCHAR(32) NOT NULL,
  `admin_avatar` VARCHAR(255) NULL,
  `channel` VARCHAR(255) NOT NULL,
  `user` VARCHAR(255) NOT NULL,
  `user_id` VARCHAR(32) NOT NULL,
  `user_avatar` VARCHAR(255) NULL,
  `timestamp` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX `idx_admin_id` (`admin_id`),
  INDEX `idx_user_id` (`user_id`),
  INDEX `idx_timestamp` (`timestamp`),
  INDEX `idx_channel` (`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
