-- 58 视频设备（司法所视频设备/摄像头台账）
CREATE TABLE IF NOT EXISTS video_dev (
    VID VARCHAR(32) NOT NULL,
    DEV_NAME VARCHAR(100) NOT NULL,
    DEV_IP VARCHAR(50) NOT NULL,
    CHANNEL INT NOT NULL,
    JGBM VARCHAR(18) NULL,
    LOCATION VARCHAR(200) NULL,
    DEV_STATUS TINYINT NULL,
    CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY(VID)
);

COMMENT ON TABLE video_dev IS '司法所视频设备(需求扩展)';
