| 123456789101112131415 |
- -- WiFi配置表
- CREATE TABLE IF NOT EXISTS wifi_configurations (
- id INT AUTO_INCREMENT PRIMARY KEY,
- device_clientid VARCHAR(255) NOT NULL COMMENT '设备客户端ID',
- ssid VARCHAR(32) NOT NULL COMMENT 'WiFi SSID',
- password VARCHAR(64) NOT NULL COMMENT 'WiFi密码',
- status ENUM('pending', 'sent', 'applied', 'failed') DEFAULT 'sent' COMMENT '配置状态：pending-待发送，sent-已发送，applied-已应用，failed-失败',
- sent_at TIMESTAMP NULL COMMENT '发送时间',
- applied_at TIMESTAMP NULL COMMENT '应用时间',
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- INDEX idx_device_clientid (device_clientid),
- INDEX idx_status (status),
- INDEX idx_created_at (created_at)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='设备WiFi配置表';
|
