7 lines
459 B
MySQL
7 lines
459 B
MySQL
|
-- 截图持久化表：保存摄像头最新截图的 COS object key
|
||
|
|
CREATE TABLE IF NOT EXISTS wvp_ai_camera_snapshot (
|
||
|
|
camera_code VARCHAR(64) PRIMARY KEY COMMENT '摄像头编码',
|
||
|
|
cos_key VARCHAR(512) NOT NULL COMMENT 'COS 对象键（永久有效）',
|
||
|
|
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间'
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='AI摄像头截图持久化';
|