-- 客户端版本发布表
CREATE TABLE IF NOT EXISTS client_app_versions (
  id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
  platform VARCHAR(20) NOT NULL DEFAULT 'windows' COMMENT '平台: windows/macos/linux',
  channel VARCHAR(20) NOT NULL DEFAULT 'stable' COMMENT '发布通道: stable/beta',
  version VARCHAR(50) NOT NULL COMMENT '版本号',
  build_number INT NULL COMMENT '构建号',
  release_title VARCHAR(120) NULL COMMENT '发布标题',
  release_notes_html TEXT NULL COMMENT '富文本更新日志',
  download_url VARCHAR(500) NULL COMMENT '下载地址',
  download_hash VARCHAR(128) NULL COMMENT '下载包hash',
  is_force_update TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否强制更新',
  min_supported_version VARCHAR(50) NULL COMMENT '最低支持版本',
  status VARCHAR(20) NOT NULL DEFAULT 'draft' COMMENT '状态: draft/published/offline',
  published_at DATETIME NULL COMMENT '发布时间',
  created_by VARCHAR(64) NULL COMMENT '创建人',
  updated_by VARCHAR(64) NULL COMMENT '更新人',
  is_deleted TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  UNIQUE KEY uk_client_app_version (platform, channel, version),
  KEY idx_client_app_version_query (platform, channel, status, is_deleted, published_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户端版本发布表';