60 lines
1.2 KiB
MySQL
60 lines
1.2 KiB
MySQL
|
-- 添加专用终端类型支持
|
|||
|
|
-- 修改 platform_type 枚举，添加 'terminal' 类型
|
|||
|
|
|
|||
|
|
ALTER TABLE client_downloads
|
|||
|
|
MODIFY COLUMN platform_type ENUM('mobile', 'desktop', 'terminal') NOT NULL
|
|||
|
|
COMMENT '平台类型：mobile-移动端, desktop-桌面端, terminal-专用终端';
|
|||
|
|
|
|||
|
|
-- 插入专用终端示例数据
|
|||
|
|
|
|||
|
|
-- Android 专用终端
|
|||
|
|
INSERT INTO client_downloads (
|
|||
|
|
platform_type,
|
|||
|
|
platform_name,
|
|||
|
|
version,
|
|||
|
|
version_code,
|
|||
|
|
download_url,
|
|||
|
|
file_size,
|
|||
|
|
release_notes,
|
|||
|
|
is_active,
|
|||
|
|
is_latest,
|
|||
|
|
min_system_version,
|
|||
|
|
created_by
|
|||
|
|
) VALUES
|
|||
|
|
(
|
|||
|
|
'terminal',
|
|||
|
|
'android',
|
|||
|
|
'1.0.0',
|
|||
|
|
1000,
|
|||
|
|
'https://download.imeeting.com/terminals/android/iMeeting-1.0.0-Terminal.apk',
|
|||
|
|
25165824, -- 24MB
|
|||
|
|
'专用终端初始版本
|
|||
|
|
- 支持专用硬件集成
|
|||
|
|
- 优化的录音功能
|
|||
|
|
- 低功耗模式
|
|||
|
|
- 自动上传同步',
|
|||
|
|
TRUE,
|
|||
|
|
TRUE,
|
|||
|
|
'Android 5.0',
|
|||
|
|
1
|
|||
|
|
),
|
|||
|
|
|
|||
|
|
-- 单片机（MCU）专用终端
|
|||
|
|
(
|
|||
|
|
'terminal',
|
|||
|
|
'mcu',
|
|||
|
|
'1.0.0',
|
|||
|
|
1000,
|
|||
|
|
'https://download.imeeting.com/terminals/mcu/iMeeting-1.0.0-MCU.bin',
|
|||
|
|
2097152, -- 2MB
|
|||
|
|
'单片机固件初始版本
|
|||
|
|
- 嵌入式录音系统
|
|||
|
|
- 低功耗设计
|
|||
|
|
- 支持WiFi/4G上传
|
|||
|
|
- 硬件级音频处理',
|
|||
|
|
TRUE,
|
|||
|
|
TRUE,
|
|||
|
|
'ESP32 / STM32',
|
|||
|
|
1
|
|||
|
|
);
|